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-900 Exam - Topic 12 Question 1 Discussion

You have a transactional application that stem data in an Azure SQ1 managed instance. When should you implement a read-only database replica?
C) You need to implement high availability in the event of a regional outage
A) You need to generate reports without affecting the transactional workload.
B) You need to audit the transactional application.
D) You need to improve the recovery point objective (RPO).

Microsoft DP-900 Exam - Topic 12 Question 1 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 1
Topic #: 12
[All DP-900 Questions]

You have a transactional application that stem data in an Azure SQ1 managed instance. When should you implement a read-only database replica?

Show Suggested Answer Hide Answer
Suggested Answer: C

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver15

by Cecily at May 08, 2022, 12:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Izetta
7 months ago
Wait, can a read-only replica really help with RPO? Sounds surprising!
upvoted 0 times
...
Tanja
7 months ago
D is interesting, but I’m not sure it applies here.
upvoted 0 times
...
Kara
8 months ago
C seems a bit off for a read-only replica.
upvoted 0 times
...
Annalee
8 months ago
I think B could also be relevant, but not the main reason.
upvoted 0 times
...
Makeda
8 months ago
A is definitely the right choice!
upvoted 0 times
...
Dierdre
8 months ago
Option D sounds familiar too, but I can't recall if read-only replicas directly improve RPO. I need to think about that one more.
upvoted 0 times
...
Roselle
8 months ago
I practiced a similar question, and I feel like option B is more about auditing rather than performance, so it might not be the best choice here.
upvoted 0 times
...
Billye
8 months ago
I'm not entirely sure, but I remember something about read replicas being useful for high availability. Maybe option C?
upvoted 0 times
...
Gilberto
8 months ago
I think option A makes the most sense since read-only replicas are often used for reporting to avoid slowing down the main database.
upvoted 0 times
...
Phillip
8 months ago
I think the key is understanding who is responsible for ensuring the product meets the minimum specifications. Let me think this through step-by-step.
upvoted 0 times
...
Brock
8 months ago
Okay, I think I've got it. The key is understanding how the nested loops work and how the variables are being updated. I'll double-check my work, but I'm feeling confident about this one.
upvoted 0 times
...
Milly
8 months ago
Hmm, I'm torn between Joint Commission and state law. Wish I remembered more from our healthcare regulations lecture.
upvoted 0 times
...
Carri
8 months ago
I'm a bit confused by this question. I'm not sure if Availability Management or Service Level Management could also be responsible for first-line support. I'll have to review my notes to be sure.
upvoted 0 times
...
Willow
8 months ago
I'm not entirely sure about this one. The wording is a bit tricky. I'll have to think it through carefully and eliminate the incorrect options.
upvoted 0 times
...

Save Cancel