PrepAway - Latest Free Exam Questions & Answers

How can you find this information?

A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the
Project Deployment Model.
Sometimes the package is started as part of a multistep SQL job. At other times, the
package is started manually by a database administrator by using the Object Explorer in
SQL Server Management Studio.
You need to identify the authenticated user responsible for starting the package each time it
executes.
How can you find this information?

PrepAway - Latest Free Exam Questions & Answers

A.
In the SSISDB.[catalog], query the .[executions] view.

B.
In the SSISDB.[catalog] , query the [event_messages] view.

C.
In SQL Server Management Studio, view the SQL Agent Job History.

D.
In SQL Server Management Studio, view the SQL Agent Error Log.

E.
In SQL Server Management Studio, view the SQL Server Log.

One Comment on “How can you find this information?


Leave a Reply