Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 3 Question 9 Discussion

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet thefollowing requirements:Support failovers that do not require client applications to change their connection strings.Replicate the database to a secondary Azure region.Support failover to the secondary region.What should you include in the recommendation?
D) geo-replication
A) failover groups
B) transactional replication
C) Availability Zones

Microsoft DP-300 Exam - Topic 3 Question 9 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 9
Topic #: 3
[All DP-300 Questions]

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the

following requirements:

Support failovers that do not require client applications to change their connection strings.

Replicate the database to a secondary Azure region.

Support failover to the secondary region.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: D

Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center (region).

Incorrect Answers:

C: Availability Zones are unique physical locations within a region. Each zone is made up of one or more

datacenters equipped with independent power, cooling, and networking.


https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

by Deandrea at May 05, 2022, 01:49 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Belen
9 months ago
A is the way to go, no doubt about it!
upvoted 0 times
...
Zona
9 months ago
I thought geo-replication was the go-to for this kind of setup.
upvoted 0 times
...
Skye
9 months ago
Wait, are we sure A is the best option?
upvoted 0 times
...
Gail
9 months ago
I think D could work too, but not as seamless.
upvoted 0 times
...
Pamela
9 months ago
Definitely A, failover groups are perfect for this!
upvoted 0 times
...
Carin
9 months ago
Availability Zones seem more about uptime within a region rather than cross-region failover, so I don't think that's the answer here.
upvoted 0 times
...
Truman
10 months ago
I'm not entirely sure, but I remember something about geo-replication being useful for disaster recovery. Does it support automatic failover?
upvoted 0 times
...
Bette
10 months ago
I think failover groups might be the right choice since they handle automatic failover without needing to change connection strings.
upvoted 0 times
...
Clare
10 months ago
I practiced a similar question, and I feel like transactional replication might not meet all the requirements, especially for failover.
upvoted 0 times
...
Milly
10 months ago
I'm pretty sure the answer is B. lvsnapshot sounds like the command to create a snapshot of a logical volume.
upvoted 0 times
...
Dorethea
10 months ago
Hmm, I'm a bit confused about the difference between a regular directory listing and a recursive one. I'll have to think this through carefully.
upvoted 0 times
...
Anika
10 months ago
Okay, let me think this through. The key details are the Sponsor portal, Kerberos authentication, and delegating to a third party. Based on that, I'm leaning towards option B, Active Directory, since it supports Kerberos and can integrate with third-party authentication providers.
upvoted 0 times
...
Felix
10 months ago
I vaguely remember that a 'Clinic without walls' allows doctors to work in multiple locations independently, which seems different from a consolidated group.
upvoted 0 times
...
Louvenia
10 months ago
I've got a good handle on business architecture, so I feel confident I can figure out how it provides value for solution architecture.
upvoted 0 times
...

Save Cancel