You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance to administrate and maintain their database. The SQL Server 2008 instance contains a
database named ABC_DB that contains a table named ABC_Tbl.
You have to put the output of the entire information from ABC_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 utility and what step should you use to accomplish this task? (Each correct option is part of
the answer. Choose TWO)
A.
Use the Package Migration Wizard…
B.
Use the ISIS…
C.
Use the Process Control Tool…
D.
Use Process Control Tool…
E.
Use the bulk copy program..
F.
Use the Microsoft SQL Server Import and Export Wizard…
G.
Use the dtexec.exe…
H.
Use the DTS Designer…
I.
..with a format file
J.
..with an output file.
K.
..and store the output in a file.
Explanation: