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 dat
a.
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.)
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/ms178804.aspxhttp://msdn.microsoft.com/en-us/library/ms187828.aspx
The sentence “the first row of the file is to contain the first row of data.” I would assume this identifies data as actual records and not the column names? Therefore the “Column names in the first data row” should be left unchecked, no? I’m open to be corrected!
In addition, “Each record is of the same length.” I think this a red herring to get you to pick fixed width format. What’s the consensus on this?
0
0
I believe you are correct.
0
0
70-463 question that lost his way into this exam dump. Won’t be on the 70-462 exam 😉
0
1
This DOES occur on a 70-462 exam!
I agree with Fiachra and Matt.
0
0
Not correct, I had this exam question on the exam yesterday
0
0
what do you think the correct answer?
0
0
Given answer is right.
0
0
Here is a good Blog You may Come across Exciting that we encourage you to visit.
0
0
I thought that the unicode box would be checked? Why would this not be
0
0
You are right. ‘The file supports international characters.’ Unicode box should be checked.
0
0
Format: Fixed Width
Unicode: Checked
Column names in the firs data rows: if check we get an error, can be checked if Format is “Delimited”
0
0
Format: Fixed width
Unicode: checked
Column names in the first date row: unchecked
1
0
Agreed….
0
0
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”
1
0