Question 1
You administer a Microsoft SQL Server 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.)
Correct answer: To work with this question, an Exam Simulator is required.
Explanation:
References:http://msdn.microsoft.com/en-us/library/ms178804.aspxhttp://msdn.microsoft.com/en-us/library/ms187828.aspx
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx