Microsoft
70-432 · Question #55
70-432 Question #55: Real Exam Question with Answer & Explanation
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.
Community Discussion
No community discussion yet for this question.