CORRECT TEXT
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, simply select the option or options in the answer area that you would
configure.)
Answer: See the explanation
Explanation:
Tick the “Unicode” checkbox.
Set the Format option to “Fixed Width”
Untick the “Column names in the first data row” checkbox.Each record is of the same length = Fixed Width.
The file supports international characters = Unicode.
The date follows the U.S. date format = Locale (already configured).
The first row of the file contains the first row of data = Uncheck “Column names in the first data row”