Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureMedium
A financial company uses Azure Database for PostgreSQL to store customer transaction data. Due to increasing demand during peak hours, the database is experiencing performance bottlenecks, specifically with read-heavy analytical queries. The company needs to offload these read workloads from the primary database to improve overall responsiveness. Which Azure Database for PostgreSQL feature should be utilized?
- APoint-in-time Restore
- BHigh Availability
- CConnection Pooling
- DRead Replicas
Show answer & explanationAnswer & explanation
Correct answer: D. Read Replicas
Read Replicas in Azure Database for PostgreSQL are designed to offload read-heavy workloads from the primary server, improving performance and scalability for read operations.
Why the other options are wrong
- A. Point-in-time Restore is a disaster recovery feature for restoring a database to an earlier state, not for improving read performance.
- B. High Availability (HA) ensures continuous operation in case of failures but does not inherently improve read scalability.
- C. Connection Pooling manages database connections efficiently but does not scale out read workloads across multiple database instances.
Azure DB for PostgreSQL Read Replicas
Read Replicas in Azure Database for PostgreSQL allow you to scale out read-heavy workloads by creating read-only copies of your primary database.
- Improves read scalability and performance.
- Asynchronous replication from primary.
- Can be created in the same or different regions.
Memory trick: Read Replicas: Replicate for Reads, Relieve Primary.