You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is
put in place. The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of
deployment and development effort. What should you do?

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is
put in place. The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
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.
Open a command prompt and run the gacutil command.

B.
Open a command prompt and execute the package by using the SQL Log provider and running the
dtexecui.exe utility.

C.
Add an OnError event handler to the SSIS project.

D.
Use an msi file to deploy the package on the server.

E.
Configure the output of a component in the package data flow to use a data tap.

F.
Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL
Server.

G.
Open a command prompt and run the dtexec /rep /conn command.

H.
Open a command prompt and run the dtutil /copy command.

I.
Open a command prompt and run the dtexec /dumperror /conn command.

J.
Configure the SSIS solution to use the Project Deployment Model.
K.
Create a reusable custom logging component and use it in the SSIS project.

Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Justin Thompson

Justin Thompson

Ridiculous…they are only looking for one answer and K would not minimize the development and deployment effort.

pb7788

pb7788

K would minimize the development and deployment efforts if it did, in fact, get reused.

Andrey Trifonov

Andrey Trifonov

Answer is J

cyndilin

cyndilin

J

cyndlin

cyndlin

ignore my previous reply. It’s B