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.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx
They are some problem on this anwser not ?
– “The first row of the file contains the first row of data.” so why checked “Column name in the first data row” ?
– “Each record is of the same length.” so we must choose “fixed” and not “delimited” format ?
agree. I would also set Unicode
The first row of the file contains the first row of data. (‘Column names in the first data row’ should be un-checked)
Each record is of the same length. (‘Format’ should be set to ‘Fixed’)
The date follows the U.S. date format. (‘Locale’ should be set to ‘English (United States)’)
The file supports international characters. (‘Unicode’ should be checked)
This would mean the provided answer screenshot is incorrect.
Agree
I agree with Eli