Microsoft Azure Data Fundamentals — Question 271

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

Answer options

• A. You need to generate reports without affecting the transactional workload.
• B. You need to audit the transactional application.
• C. You need to implement high availability in the event of a regional outage.
• D. You need to improve the recovery point objective (RPO).

Correct answer: A

Explanation

The correct answer is A because a read-only database replica allows for reporting tasks to be performed without putting additional strain on the primary transactional workload. Options B, C, and D do not directly relate to the use of a read-only replica, as they pertain to auditing, high availability, and recovery objectives rather than reporting needs.