mediummultiple choiceObjective-mapped

A company runs a web application on Azure App Service with a backing Azure SQL Database in a single region. They need to ensure availability during an Azure region outage. The solution must automatically fail over the entire application stack with minimal data loss and redirect user traffic to the secondary region. Which combination of Azure services should they implement?

Question 1mediummultiple choice
Full question →

A company runs a web application on Azure App Service with a backing Azure SQL Database in a single region. They need to ensure availability during an Azure region outage. The solution must automatically fail over the entire application stack with minimal data loss and redirect user traffic to the secondary region. Which combination of Azure services 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

Distractor review

Azure Traffic Manager with active-passive and geo-replication for Azure SQL Database

Traffic Manager can route traffic but does not provide HTTP-level routing or WAF capabilities. Geo-replication for SQL Database alone does not provide automatic failover; auto-failover groups are needed.

B

Best answer

Azure Front Door with active-active or active-passive routing and auto-failover groups for Azure SQL Database

Azure Front Door provides global HTTP/HTTPS routing with health probes and automatic failover, and auto-failover groups for SQL Database provide geo-replication with automatic failover, meeting RPO and RTO requirements.

C

Distractor review

Azure Application Gateway with backend pools in multiple regions and SQL Database failover groups

Azure Application Gateway is a regional load balancer and cannot route traffic across regions globally.

D

Distractor review

Azure Load Balancer with multiple regions and Azure SQL Database automatic failover

Azure Load Balancer is a regional layer-4 load balancer and cannot handle cross-region traffic routing.

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: Azure Front Door with active-active or active-passive routing and auto-failover groups for Azure SQL Database — Azure Front Door provides global load balancing and traffic routing with health probes and automatic failover. For the database, auto-failover groups enable geo-replication with automatic failover and RPO of seconds to minutes. Traffic Manager can also do global routing but Front Door is better for web applications with HTTP/HTTPS. Application Gateway is regional. Azure Load Balancer does not provide global routing.

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.