Question 64: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses thePackage Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server. What should you do?

1. A. Open a command prompt and run the dtexec /dumperror /conn command.
2. B. Create a reusable custom logging component and use it inthe SSIS project.
3. C. Open a command prompt and run the gacutil command.
4. D. Add an OnError event handler to the SSIS project.
5. E. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
6. F. Open a command prompt and run the dtexec /rep /conn command.
7. G. Open a command prompt and run the dtutil /copy command.
8. H. Use an msi file to deploy the package on the server.
9. I. Configure the SSIS solution to use the Project Deployment Model. — đáp án hiện tại
10. J. Configure the output of a component in the package data flow to use a data tap. K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.