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 create a set of Microsoft SQL Server Integration Services (SSIS) packages to support an ETL process.
You need to deploy the SSIS packages and meet the following requirements:
Maximize ease of use for backup processes.
Manage security of packages from a single place.
Maintain versioning of packages.
Implement parameters to assign values to packages.
Use stored procedures to run SSIS packages. Use SQL Server Agent to run packages.
Solution: You use the Project Deployment model with an SSIS catalog to store and manage packages.
Does this meet the goal?
A. Yes
B. No
