To ease the debugging of packages, you standardize the SQL Server Integration Services
(SSIS) package logging methodology.
The methodology has the following requirements:
Centralized logging in SQL Server
Simple deployment
Availability of log information through reports or T-SQL
Automatic purge of older log entries
Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing
the amount of deployment and development effort.
What should you do?
A.
Deploy the package by using an msi file.
B.
Use the gacutil command.
C.
Create an OnError event handler.
D.
Create a reusable custom logging component.
E.
Use the dtutil /copy command.
F.
Use the Project Deployment Wizard.
G.
Run the package by using the dtexec /rep /conn command.
H.
Add a data tap on the output of a component in the package data flow.
I.
Run the package by using the dtexec /dumperror /conn command.
J.
Run the package by using the dtexecui.exe utility and the SQL Log provider.
K.
Deploy the package to the Integration Services catalog by using dtutil and use SQL
Server to store the configuration.
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
J
F
Yep you got it. F is correct
Yes it is J
agreed. J is the correct answer.
As question is not specific to SQL server 2012…so Project Deployment Wizard should not be an option. Correct answer is J
Though the question does not say it specifically, it is SQL Server 2012.
This exam is part of SQL Server 2012 certification. All questions should be considered in context of SQL 2012 unless specified otherwise.
How can J answer the Automatic purge of older log entries ??? it is F guys…
sql log provider can purge old records in SQL server logs. J is correct
I think its ‘F’
is the same with question 17 right? there the answer is Configure the SSIS solution to use the Project Deployment Model according to koala why here is j? it should be F
F
Yeah, it’s same as Q.17. But for both it’s J.
J is Right.
I think it’s J
F
F
F is correct
You use F to deploy the project and J to execute, in one of many execution methodologies. Since this is a question of setting logs and you clearly need the automatic log maintenance action of the ssisdb, F is the answer because you configure logs etc. before deployment. By the time are executing the logs should have been configured.