ExpertHard1 markMultiple Choice
AZ-305 · Question 18 · Domain 2.1: Relational Data Storage
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:
- The database must be replicated to a secondary Azure region.
- In the event of a primary region failure, the application must be able to fail over to the secondary region.
- 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)
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:
- The database must be replicated to a secondary Azure region.
- In the event of a primary region failure, the application must be able to fail over to the secondary region.
- 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)
Answer options:
A.
Zone-redundant High Availability (HA)
B.
Read replicas in the secondary region
C.
Promote the read replica to a standalone server during a disaster
D.
Auto-failover groups
E.
Geo-redundant backup (GRS) restore
How to approach this question
Identify how PostgreSQL handles cross-region replication (Read Replicas) and how failover is executed (Promotion).
Full Answer
For Azure Database for PostgreSQL - Flexible Server, cross-region disaster recovery and read scale-out are achieved using Read Replicas. You deploy a read replica in a secondary region, which satisfies the reporting requirement. In the event of a primary region outage, you manually 'promote' the read replica. This severs the replication link and makes the server read-write, completing the failover process.
Common mistakes
Selecting Auto-failover groups, which is an Azure SQL feature, not a PostgreSQL feature.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard