Medium1 markMultiple Choice
Domain 2.1: Design a data storage solution for relational dataDomain 2Relational DataPostgreSQLHigh Availability

AZ-305 · Question 18 · Domain 2.1: Design a data storage solution for relational data

A media company is building a global content management system using Azure Database for PostgreSQL - Flexible Server.

The application has a heavy read-to-write ratio (90% reads, 10% writes). Users in Europe and Asia are experiencing high latency when reading data, as the primary database is located in East US. You need to improve read performance for global users while maintaining high availability for the primary database in East US.

Which TWO features should you configure? (Select TWO)

Answer options:

A.

Zone-redundant High Availability (HA)

B.

Cross-region Read Replicas

C.

Azure Cache for Redis

D.

Auto-failover groups

E.

Multi-region writes

How to approach this question

Address the two requirements: HA in the primary region (Zone-redundant HA) and low-latency reads globally (Cross-region Read Replicas).

Full Answer

To maintain high availability for the primary database in East US, you should enable Zone-redundant High Availability, which synchronously replicates data to a standby server in a different Availability Zone. To solve the read latency for users in Europe and Asia, you should deploy Cross-region Read Replicas. The application can direct read queries to the local replicas, while write queries continue to go to the primary server in East US.

Common mistakes

Selecting Multi-region writes, confusing PostgreSQL capabilities with Azure Cosmos DB capabilities.

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1

55 questions · hints · full answers · grading

More questions from this exam