Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You have a transactional application that stores data in an Azure SQL (DP-900)
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
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).
Solution
Correct answer: A. You need to generate reports without affecting the transactional workload.
A read-only database replica is a secondary database that is a read-only copy of the primary database. It's useful for offloading read-intensive workloads, such as reporting and analytics, from the primary database, which can help improve the performance of the transactional workload.
While a read-only replica can also provide some level of high availability, it's not the best solution for scenario C, as it's not a fully writable replica and may not be suitable for handling write workloads in the event of a regional outage.
Auditing (scenario B) typically requires a different approach, such as using Azure SQL Auditing, which logs database events to a storage account or Log Analytics workspace.
Improving the recovery point objective (RPO) (scenario D) is typically achieved through backups and geo-replication, rather than a read-only replica.
Category: Identify considerations for relational data on Azure