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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.