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