You need to ensure that the following requirements are met: • The first row of the file contains the first row of data

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

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

Answer:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


John

John

This answer is wrong. Column names check box should not be selected.

Stu

Stu

Agreed. Column headers should not be in the first row as this answer states. Should it not also have “fixed width” and “Unicode” selected to meet the criteria?

khalil

khalil

agreed with Stu and John: the answer is wrong,
should be unicode selected (support international characters).
column names should be uncheck (column names are not data from table)
format should be fixed width (as mentioned in the requirement, it is fixed widht)