YOU NEED TO IMPORT DATA FROM A DATA FILE THAT HAS A DIFFERENT NUMBE...

3. You need to import data from a data file that has a different number of fields than the target table. What could you do to import the file (select all that apply)?A. Create a format file to map the columnsB. Create an XML format file to map the columnsC. Run BCP without a format fileD. Run BULK INSERT without a format fileCorrect Answers and Explanation: A and B. Answers A and B are correct. By creating either a non-XML or XML format file, you can map the fields in the source file to the columns in the destination table.Incorrect Answers and Explanations: C and D. Answers C and D are incorrect because without a format file of some type, both BCP and BULK INSERT will fail on the mismatched columns.