YOU WANT TO EXPORT DATA FROM A SQL SERVER INSTANCE TO A TEXT FILE....

1. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P153 PPSX 1. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P153 PPSX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P153 PPSX
1. You want to export data from a SQL Server instance to a text file. This operation needs to be scheduled to run at night without human intervention. Select the best option from the following possibilities:A. Use BCP in a SQL Server Agent JobB. Use BULK INSERT in a SQL Server Agent JobC. Use SQLCMD in a SQL Server Agent JobD. Use OSQL in a SQL Server Agent JobCorrect Answer and Explanation: A. A is the correct answer. BCP can be used to export data from SQL Server as well as import to SQL Server. It could be entered in an Operating System Command step in a SQL Server Agent Job for scheduling purposes.Incorrect Answers and Explanations: B, C, and D. Answer B is incorrect, because the BULK INSERT statement can not export data from SQL Server. Answers C and D are incorrect because you might be able to make the SQLCMD or OSQL tools export data, but they are not ideal for exporting data.