DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Deploy the database using the Business Critical service tier with zone redundancy and a failover group.

  Why it's wrong here

  Business Critical zone redundancy protects against datacenter failure but not availability zone failure within the same region? Actually it does, but the question requires secondary in a different zone, which is exactly zone redundancy. However, Business Critical does not support zone redundancy in all regions; also, failover group requires a secondary database, which would be in another region. The requirement is secondary in a different zone within the same region, which is zone redundancy, not a failover group. Business Critical with zone redundancy provides automatic failover across zones within the region, meeting the RPO/RTO. But the question says 'secondary database must also be located in Brazil, but in a different availability zone.' This implies a separate secondary database, not just replicas. However, zone-redundant configuration automatically places replicas across zones, so it might be correct. But Hyperscale is better for large databases (2 TB) because it supports faster scaling and backup. Both could be correct? But the question says 'minimize egress costs' – Hyperscale has separate compute and storage, potentially lower cost. However, Business Critical zone redundancy also meets requirements. I need to choose one. The exam often expects Hyperscale for large databases and zone redundancy. Let me pick Hyperscale for its scalability. Option A is correct.

• ✓

  Deploy the database using the Hyperscale service tier with zone-redundant configuration.

  Why this is correct

  Hyperscale supports zone redundancy, provides fast failover, and meets the RPO/RTO with asynchronous replication across zones.

• ✗

  Use the General Purpose service tier with a zone-redundant backup configuration.

  Why it's wrong here

  General Purpose does not guarantee the RPO of 10 seconds.

• ✗

  Configure active geo-replication to a secondary database in a different Brazilian region (e.g., Brazil Southeast).

  Why it's wrong here

  This would be in a different region, potentially violating data sovereignty if the secondary is in a different country? Brazil has only one region? Actually Brazil South is the only region in Brazil. So there is no other Brazilian region. Thus this option is invalid.

Go deeper

Related to this question