exam questions

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 1 question 22 discussion

Actual exam question from Microsoft's 70-462
Question #: 22
Topic #: 1
[All 70-462 Questions]

HOTSPOT -
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.)
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
LiamLin
4 years ago
Locale = Unicode Format = Ragged Right
upvoted 1 times
...
Melymel
4 years, 10 months ago
Unicode should be enabled and format should be fixed width since each record is the same length
upvoted 1 times
LiamLin
4 years ago
Locale = Unicode Format = Ragged Right
upvoted 1 times
...
...
davidkuz
5 years, 2 months ago
should not Unicode be enabled? Also should it not be fixed width?
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...