nerdexam
MicrosoftMicrosoft

AZ-305 · Question #438

AZ-305 Question #438: Real Exam Question with Answer & 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

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:

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.

Full AZ-305 PracticeBrowse All AZ-305 Questions