nerdexam
Microsoft

AZ-305 · Question #438

Drag and Drop Question You have an Azure subscription. You are designing a deployment plan for the Azure App Service web apps shown in the following table. You need to recommend a database solution…

The correct answer is Azure Database for PostgreSQL flexible server in the general purpose tier; Azure Cosmos DB for NoSQL and a single-region writes with availability zones SLA. Based on the requirements for zone redundancy while minimizing costs and administrative effort, App1 (which requires NoSQL capabilities) should use Azure Cosmos DB for NoSQL with a single-region writes with availability zones SLA, as this provides zone redundancy within a…

Submitted by ahmad_uae· Mar 6, 2026Design Data Storage Solutions - specifically selecting appropriate Azure database services that meet availability, redundancy, and cost optimization requirements as part of the AZ-305 Designing Microsoft Azure Infrastructure Solutions certification.

Question

Drag and Drop Question You have an Azure subscription. You are designing a deployment plan for the Azure App Service web apps shown in the following table. You need to recommend a database solution for the apps. The solution must meet the following requirements: - Provide zone redundancy. - Minimize costs and administrative effort. What should you include in the recommendation for each app? To answer, drag the appropriate database types to the correct apps. Each database type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibits

AZ-305 question #438 exhibit 1
AZ-305 question #438 exhibit 2

Answer Area

Drag items

Azure Cosmos DB for NoSQL and a multiple region, single-region writes without availability zones SLAAzure Cosmos DB for NoSQL and a single-region writes with availability zones SLAAzure Cosmos DB for NoSQL and a single-region writes without availability zones SLAAzure Database for PostgreSQL flexible server in the burstable tierAzure Database for PostgreSQL flexible server in the general purpose tierAzure Database for PostgreSQL single server in the memory optimized tier

Correct arrangement

  • Azure Database for PostgreSQL flexible server in the general purpose tier
  • Azure Cosmos DB for NoSQL and a single-region writes with availability zones SLA

Explanation

Based on the requirements for zone redundancy while minimizing costs and administrative effort, App1 (which requires NoSQL capabilities) should use Azure Cosmos DB for NoSQL with a single-region writes with availability zones SLA, as this provides zone redundancy within a single region at lower cost than multi-region writes. App2 (which requires relational/PostgreSQL capabilities) should use Azure Database for PostgreSQL flexible server in the general purpose tier, because the flexible server supports availability zones (zone redundancy) unlike the legacy single server option, and the general purpose tier is required for zone redundancy as the burstable tier does not support high availability with zone redundancy. The burstable tier is excluded because it lacks support for zone-redundant high availability, making it unsuitable when zone redundancy is a hard requirement.

Topics

#Azure Cosmos DB#Azure Database for PostgreSQL#Zone Redundancy#Database Solutions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice