Exam 70-767 topic 1 question 67 discussion

Actual exam question from Microsoft's 70-767

Question #: 67
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: A 🗳️
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/

by Vlad0 at July 19, 2020, 8:15 a.m.

Comments

Submit Cancel

Anette

4 years, 8 months ago

In a second thought, after reading more regarding Always On availability group I thing the answer A is right. See links below: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups?view=sql-server-ver15

upvoted 3 times

Lukis92

4 years, 6 months ago

Can you pinpoint why the A is right? I read the attached articles carefully and still think that B is the correct answer. I would agree with you if instead of word "Deploy" there was "Replicate". All databases within one particular availability group are deployed to the primary replica in the first node and then based on configuration the secondary databases are synchronized with the current state of the primary replica in synchronous-commit or asynchronous-commit mode.

upvoted 1 times

...

TrungMyLanTJ

4 years, 4 months ago

System databases are not mirrored nor replicated in both mirroring and alwayson availability groups. Msdb is a system database and thus it must be deployed separatelly in other nodes A is the correct answer

upvoted 2 times

...

Vlad0

4 years, 9 months ago

I am not sure to undestand why it's not B (Deploy to the msdb database on the primary replica.) I thought that If you deployed in the primary replica, it would have been replicate in the second replica.

upvoted 3 times

Anette

4 years, 8 months ago

I agree

upvoted 2 times

Anette

4 years, 8 months ago

And I think its B https://www.rathishkumar.in/2019/06/step-by-step-guide-to-add-ssidb-to-alwayson-ag.html

upvoted 1 times

...

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam

Exam 70-767 topic 1 question 67 discussion

Comments

Anette

Lukis92

TrungMyLanTJ

Vlad0

Anette

Anette

SY0-701