ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 5 question 28 discussion

Actual exam question from Microsoft's DP-300
Question #: 28
Topic #: 5
[All DP-300 Questions]

HOTSPOT
-

You plan to deploy three instances of SQL Server on Azure Virtual Machines that will each contain 20 databases.

You need to recommend a solution that meets the following requirements:

• Ensures that the deployment is highly available
• Minimizes administrative effort to manage users, logins, permissions, and SQL Server Agent jobs across the instances

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by pjfunner at May 28, 2024, 4:44 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
c80f499
3 months ago
Contained 2022 A "contained availability group" in Azure 2022 refers to a special type of Always On availability group (AG) in SQL Server that manages metadata objects like user logins, permissions, and SQL Agent jobs at the AG level, meaning these objects are replicated and synchronized across all replicas within the availability group, eliminating the need to manually manage them on each server individually; essentially, it allows for self-contained management of server-level objects within the AG itself, including its own copies of the master and msdb system database
upvoted 1 times
...
2f5c7cd
6 months, 2 weeks ago
Contained 2022 https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/contained-availability-groups-overview?view=sql-server-ver16
upvoted 2 times
2f5c7cd
6 months, 2 weeks ago
As Vitos25 already mentioned.
upvoted 1 times
...
...
Vitos25
7 months, 2 weeks ago
Seems like answer is wrong It should be contained 2022
upvoted 1 times
Vitos25
7 months, 2 weeks ago
Here is the source https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/contained-availability-groups-overview?view=sql-server-ver16
upvoted 2 times
...
...
pjfunner
11 months ago
The minimum SQL version for SQL on Azure VM is 2016 that supports Availability Groups. There for the answer should be "Always On" and "2017"
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago