hardmultiple choiceObjective-mapped

A company runs a critical application on Azure SQL Database in the West US region. They need a disaster recovery solution with an RPO of 5 seconds and an RTO of 1 hour. They also need to be able to perform patching and maintenance on the primary without downtime. Which configuration should they implement?

Question 1hardmultiple choice
Full question →

A company runs a critical application on Azure SQL Database in the West US region. They need a disaster recovery solution with an RPO of 5 seconds and an RTO of 1 hour. They also need to be able to perform patching and maintenance on the primary without downtime. Which configuration should they implement?

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Best answer

Active geo-replication with auto-failover group

Auto-failover groups provide the required RPO and RTO, and allow planned failover for maintenance without data loss.

B

Distractor review

Azure SQL Database backup to geo-redundant storage

Geo-restore from backups has a higher RPO (1 hour) and RTO (12 hours), not meeting requirements.

C

Distractor review

Azure SQL Database with zone-redundant configuration

Zone redundancy protects against datacenter failure within a region, not a regional disaster.

D

Distractor review

Azure SQL Database with failover group using manual failover

Manual failover requires human intervention and may not meet the RTO of 1 hour for automatic failover.

Common exam trap

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Technical deep dive

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

  • Static NAT maps one inside address to one outside address.
  • PAT allows many inside hosts to share one public address using ports.
  • Inside local and inside global describe the private and translated addresses.
  • NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

  • Identify inside and outside interfaces first.
  • Check whether the scenario needs static NAT, dynamic NAT or PAT.
  • Do not confuse NAT matching ACLs with normal packet-filtering intent.

Related practice questions

Related AZ-305 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

FAQ

Questions learners often ask

What does this AZ-305 question test?

Static NAT maps one inside address to one outside address.

What is the correct answer to this question?

The correct answer is: Active geo-replication with auto-failover group — Auto-failover groups with active geo-replication provide an RPO of 5 seconds (synchronous replication within the group) and an RTO of about 1 hour. They allow planned failover to the secondary for maintenance, minimizing downtime. Geo-restore from backups has longer RTO, zone redundancy doesn't address cross-region DR, and manual failover requires more intervention.

What should I do if I get this AZ-305 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.