Discuss Microsoft DP-900 Exam Topic 12 Question 1

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

AYou need to generate reports without affecting the transactional workload.

BYou need to audit the transactional application.

CYou need to implement high availability in the event of a regional outage

DYou need to improve the recovery point objective (RPO).

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

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

14 comments · newest first

Izetta 12 months ago

Wait, can a read-only replica really help with RPO? Sounds surprising!

Tanja 1 year ago

D is interesting, but I’m not sure it applies here.

Kara 1 year ago

C seems a bit off for a read-only replica.

Annalee 1 year ago

I think B could also be relevant, but not the main reason.

Makeda 1 year ago

A is definitely the right choice!

Dierdre 1 year 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.

Roselle 1 year 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.

Billye 1 year ago

I'm not entirely sure, but I remember something about read replicas being useful for high availability. Maybe option C?

Gilberto 1 year 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.

Phillip 1 year 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.

Brock 1 year 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.

Milly 1 year ago

Hmm, I'm torn between Joint Commission and state law. Wish I remembered more from our healthcare regulations lecture.

Carri 1 year 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.

Willow 1 year 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.

Microsoft DP-900 Exam - Topic 12 Question 1 Discussion