70-432 · Question #55
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is…
The correct answer is C. You should run the SQL Import and Export Data Wizard and save the output to a file. See the full explanation below for the reasoning.
Question
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?
Options
- AYou should run the bulk copy program utility along with an output file and no format file
- BYou should run the SQLCmd utility and save the output to a file
- CYou should run the SQL Import and Export Data Wizard and save the output to a file.
- DYou should run the bulk copy program utility along with a format file and an output file.
How the community answered
(43 responses)- A16% (7)
- B2% (1)
- C74% (32)
- D7% (3)
Community Discussion
No community discussion yet for this question.