Which three actions should you perform in sequence?

DRAG DROP
You have a business intelligence (BI) solution that uses SQL Server Integration Services
(SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path
for each package execution.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.

DRAG DROP
You have a business intelligence (BI) solution that uses SQL Server Integration Services
(SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path
for each package execution.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Show Hint

Leave a Reply 2

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

Fabio J.

Fabio J.

The correct answer it’s

[BOX 1] _ Configure Project Deployment Model
[BOX 2] _ Execute the package and use the Verbose logging level
[BOX 3] _ Create a SQL Server Reporting Services (SSRS) report that the queries the catalog.execution_data_statistics view

Reply