HOTSPOT
You administer a Microsoft SQL Server 2012 database. The database contains a table that has the
following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export
Wizard. You need to ensure that the following requirements are met:
• The first row of the file contains the first row of data.
• Each record is of the same length.
• The date follows the U.S. date format.
• The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in
the answer area.)
This answer is wrong. Column names check box should not be selected.
Agreed. Column headers should not be in the first row as this answer states. Should it not also have “fixed width” and “Unicode” selected to meet the criteria?
agreed with Stu and John: the answer is wrong,
should be unicode selected (support international characters).
column names should be uncheck (column names are not data from table)
format should be fixed width (as mentioned in the requirement, it is fixed widht)