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 run the package by using a SQL Server Agent job and use the Job Activity Monitor to view the progress of the job.

Does the solution meet the goal?