Question 1

A global SaaS provider uses Azure Database for PostgreSQL - Flexible Server for their core application.

The business requires a disaster recovery architecture that meets the following constraints:
1. The database must be replicated to a secondary Azure region.
2. In the event of a primary region failure, the application must be able to fail over to the secondary region.
3. During normal operations, the secondary region database must be accessible for read-only analytical queries to offload reporting workloads.

Which TWO features should you configure to meet these requirements? (Select TWO)

Accepted Answer

Identify how PostgreSQL handles cross-region replication (Read Replicas) and how failover is executed (Promotion).

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Selecting Auto-failover groups, which is an Azure SQL feature, not a PostgreSQL feature.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam