You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance to administrate and maintain their database. The SQL Server 2008 instance
contains a database named CK_DB that contains a table named CK_Tbl.
You have to put the output of the entire information from CK_Tbl to a file. You have received
instructions from management to ensure that your solution will provide the desired output in a
Microsoft Office Open XML document format whilst making sure that the data export process is
protected for reuse.
What should you do?
A.
You should consider using the bulk copy program function.
B.
You should consider using the SQLCmd function and save the output to a file.
C.
You should consider using the SQL Import and Export Data Wizard and save the output to a file.
D.
You should consider using the bulk copy program function along with a format file and an output file.