PrepAway - Latest Free Exam Questions & Answers

You plan to deploy several Microsoft SQL Server Integration Services (SSIS) packages to a highly available SQL

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?

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.

Explanation:

Before you can configure SSIS to enable support of AlwaysOn on the new added secondary Replicas, you must connect to all new added secondary replicas.

Note: To use SSIS with AlwaysOn, you-ll need to add the SSIS Catalog (SSISDB) into an Availability Group. You-ll need to do the following steps:

Make sure you meet the prerequisites for using AlwaysOn

Connect to every node and create the SSISDB catalog. We need to create the catalog even on secondary nodes to create the other server-level objects (cleanup jobs, keys, accounts etc) that are used by SSIS.

Delete the SSISDB databases on secondary nodes.

Create an availability group, specifying SSISDB as the user database

Specify secondary replicas.

References: https://chrislumnah.com/2017/05/09/enabling-alwayson-for-ssisdb/


Leave a Reply