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, simply select the option or options in the answer area that
you would configure.)
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms1 87828.aspx
The answer is wrong.
Check unicode and change the format to fixed rather than delimited
column names in the first data row must be unchecked
This is the correct answer
Sure? It says “The first row of the file contains the first row of data”. Doesn’t this mean that the first row of the text file should be the header?
nvm, my mistake here.
I think it must be
1-Unicode “English United States”
2-“Fixed width” because the Question say “Each record is of the same length”
3- The First Row have the Names must be Checked the question say “Column Name is in the first data row “
the first row contains the first line of DATA!!
MUGEN IS CORRECT!
Agree with Mugen.
Mugen is correct