PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document f

You administer a SQL Server 2008 instance that contains a database named
AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all
data from this table to a file.
You need to ensure that the following data export requirements are met:
A Microsoft Office Open XML document format is used The data export process is saved for
reuse.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Run the SQLCmd utility and save the output to a file.

B.
Run the SQL Import and Export Data Wizard and save the output to a file.

C.
Run the bulk copy program utility along with a format file and an output file.

D.
Run the bulk copy program utility along with an output file and no format file.


Leave a Reply