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:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

should use Project deployment model to query the catalog views