What should you do?

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.)

View Answer

Answer:

Explanation:

References:

http://msdn.microsoft.com/en-us/library/ms178804.aspx

http://msdn.microsoft.com/en-us/library/ms187828.aspx