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 ofdata.
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.)
Hot Area:
Answer:
Explanation:
Verified answer as correct.
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx
To achieve the reqieriments of the question you have todo the following:
1) The first row of the file contains the first row ofdata.
The Checkbox “column names in the first data row” has to be checked off
2) Each record is of the same length.
The Format-Listbox has to be changed to “Fixed”. Then every line has the same length (Attention: Lines then are NOT separated by CrLf as usual).
If you choose delimited then CrLf seperates the lines, but they have Differenz length.
If you choose Ragged right then the last filed has different sizes.
3) The date follows the U.S. date Format:
Set the field Locale to “English (US)”
4) The file supports international characters
The Checkbox “Unicode” has to be checked.
Why is that necessary? The field Customername in the table has Type nvarchar(50). That means it is a unicode-field and can be filled with international characters like german umlaute
It is described here:
http://msdn.microsoft.com/en-us/library/ms178430(v=sql.110).aspx?appid=dev10idef1&l=de-de&k=k(sql11.dts.impexpwizard.chooseadestination.f1)&rd=true
is this correct?
isn’t it delimited on the Format field?
There is a little confusion whether we should still select the items even if they are already set to the correct values. Such as Set the field Locale to “English (US)” when it is already “English (US)”.
I think the answer should be you should still the answers that are responsible for the features as your computer could be in a different locale.