Exam 70-463 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-463

Question #: 54
Topic #: 1

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?

A. Create a reusable custom logging component.
B. Use the gacutil command.
C. Use the Project Deployment Wizard.
D. Run the package by using the dtexec /rep /conn command.
E. Add a data tap on the output of a component in the package data flow.
F. Create an OnErrorevent handler.
G. Use the dtutil /copy command.
H. Deploy the package by using an msi file.
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.

Show Suggested Answer

Suggested Answer: J 🗳️
References: http://msdn.microsoft.com/en-us/library/ms140246.aspx http://msdn.microsoft.com/en-us/library/hh231187.aspx

by LuckyKatt at Dec. 29, 2019, 3:44 a.m.

Comments

Submit Cancel

cornford

4 years, 11 months ago

Question states "Your solution must minimize deployment and development efforts." You just need to debug quickly with minimal effort so J is correct.

upvoted 1 times

...

LuckyKatt

5 years, 7 months ago

Answer k (which is hiding on the J line) seems like the best answer, as that would deploy the package to the server so logging would occur for each execution. Using dtexec would do logging for one manual execution, but not for each job execution.

upvoted 2 times

...