nerdexam
Microsoft

DP-900 · Question #10

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

Sign in or unlock DP-900 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.

Submitted by marco_it· Mar 30, 2026Identify considerations for relational data on Azure

Question

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

Options

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

Unlock DP-900 to see the answer

You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#read replica#reporting#OLTP#workload isolation
Full DP-900 Practice