exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 3 question 80 discussion

Actual exam question from Microsoft's 70-463
Question #: 80
Topic #: 3
[All 70-463 Questions]

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 areathat you would configure.)
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
https://www.sqlshack.com/export-data-sql-server-flat-file/

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
davidkuz
5 years, 4 months ago
should format not be fixed width to all be same length?
upvoted 3 times
sanketh
5 years, 2 months ago
Yes it should be, also the unicode radio button needs to be checked as per the requirement
upvoted 3 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 ...