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

The correct answer is A. You need to generate reports without affecting the transactional workload. Use read-only replicas to offload read-only query workloads. https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

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

How the community answered

(19 responses)

A
79% (15)
B
5% (1)
C
5% (1)
D
11% (2)

Explanation

Use read-only replicas to offload read-only query workloads. https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Topics

#read replica#reporting#OLTP#workload isolation

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice