You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rowsfrom a
SQL Azure database. The project uses the Package 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?
A.
Add an OnError event handler to the SSIS project.
B.
Use an msi file to deploy the package on the server.
C.
Open a command prompt and run the gacutil command.
D.
Open a command prompt and run the dtutil /copy command.
E.
Open a command prompt and run the dtexec /rep /conn command.
F.
Open a command prompt and run the dtexec /dumperror /conn command.
G.
Run the package by using the dtexecui.exe utilityand the SQL Log provider.
H.
Create a reusable custom logging component and use it in the SSIS project.
I.
Configure the SSIS solution to use the Project Deployment Model.
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.
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/hh231102.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx
I Configure the SSIS solution to use the Project Deployment Model.
what about K?
Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL
Server.
As I understand it, dtutil can be used to deploy projects into ssisdb, but the reason why K is wrong is because this is yet another question of epic stupidity. The project has to be deployed in the ssisdb, as a project. If you deploy it with dtutil, it could have been deployed as a package is msdb or a project in ssisdb. K says to deploy it as a package, the part about dtutil is irrelevant. K rules itself out by virtue of its question construction, not a fundamental knowledge of dtutil. Answer I ensures a project deployment because it says use the project deployment model, which is what we want because the question says ensure that “the project is deployed”, not “the package is deployed”. I’m convinced these questions are actually a test of the nuances of the English language and not fundamental knowledge about SSIS because Microsoft hates foreigners.
How about D (Open a command prompt and run the dtutil /copy command)?
“This project is deployed to SQL Server on a test server.” If it is already deployed as a project on test server all you need to do is to copy. Solution should already be configured to use project deployment. Makes sense?
But again “The project uses the Package Deployment Model.” makes I look more plausible.