Implementing a SQL Data Warehouse — Question 44

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an on-premises Microsoft SQL Server instance and a Microsoft Azure SQL Data Warehouse instance. You move data from the on-premises database to the data warehouse once each day by using a SQL Server Integration Services (SSIS) package.
You observe that the package no longer completes within the allotted time.
You need to determine which tasks are taking a long time to complete.
Solution: You enable package logging within SSIS.
Does the solution meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution of enabling package logging in SSIS does not directly identify which tasks are taking a long time; rather, it logs events and errors of the entire package execution. While logging is useful for troubleshooting, it does not provide the specific performance metrics needed to ascertain which specific tasks are causing delays. Therefore, the answer is No.