Implementing a SQL Data Warehouse — Question 46

You plan to deploy several Microsoft SQL Server Integration Services (SSIS) packages to a highly available SQL Server instance. The instance is configured to use an AlwaysOn availability group that has two replicas.
You need to identify which deployment method must be used to ensure that the packages are always accessible from all the nodes in the availability group.
Which deployment method should you use for the packages?

Answer options

• A. Deploy to the msdb database on the secondary replica.
• B. Deploy to the msdb database on the primary replica.
• C. Deploy to a file on the hard drive of the primary replica.
• D. Deploy to a shared folder on a file server.

Correct answer: A

Explanation

The correct answer is A, as deploying to the msdb database on the secondary replica ensures that the SSIS packages are accessible across all nodes in the availability group. Option B is incorrect because deploying only to the primary replica limits access to that node. Options C and D do not provide the necessary availability across replicas, as C restricts access to the primary and D may not be configured for high availability.