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, simply select the option or options in the answer area that
you would configure.)

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, simply select the option or options in the answer area that
you would configure.)

Answer:

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms1 87828.aspx



Leave a Reply 8

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


Mugen

Mugen

The answer is wrong.
Check unicode and change the format to fixed rather than delimited

column names in the first data row must be unchecked

SQLdba

SQLdba

This is the correct answer

Ninja

Ninja

Sure? It says “The first row of the file contains the first row of data”. Doesn’t this mean that the first row of the text file should be the header?

Ninja

Ninja

nvm, my mistake here.

Mido

Mido

I think it must be

1-Unicode “English United States”
2-“Fixed width” because the Question say “Each record is of the same length”
3- The First Row have the Names must be Checked the question say “Column Name is in the first data row “

Islam

Islam

the first row contains the first line of DATA!!

MUGEN IS CORRECT!

MKL

MKL

Agree with Mugen.

BigD

BigD

Mugen is correct