Microsoft DP-900 Exam - Topic 12 Question 1 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 1
Topic #: 12

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).

Show Suggested 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:

Submit Cancel

Izetta

4 months ago

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

upvoted 0 times

...

Tanja

4 months ago

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

upvoted 0 times

...

Kara

4 months ago

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

upvoted 0 times

...

Annalee

5 months ago

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

upvoted 0 times

...

Makeda

5 months ago

A is definitely the right choice!

upvoted 0 times

...

Dierdre

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...