Question 692 of 1,031

Describe Azure architecture and services →mediumMultiple ChoiceObjective-mapped

Quick Answer

The correct choice is Azure SQL Database elastic pool because it allows multiple databases to share a single pool of eDTU resources, enabling cost-effective handling of unpredictable bursts without over-provisioning each database individually. With low average usage under 5 DTU but peaks up to 50 DTU, an elastic pool aggregates these variable demands across 50 databases, so the pooled capacity absorbs spikes while you pay only for the total eDTUs needed, not per-database maximums. On the AZ-900 exam, this scenario tests your understanding of how elastic pools optimize cost for workloads with low average usage and bursts, often appearing as a trap where candidates mistakenly choose single databases or serverless—remember, elastic pools are designed exactly for many databases with variable, low-average usage. A quick memory tip: think of an elastic pool as a shared pizza—each database takes a slice only when hungry, but you only pay for the whole pizza, not each person’s maximum appetite.

AZ-900 Describe Azure architecture and services Practice Question

This AZ-900 practice question tests your understanding of describe azure architecture and services. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company manages 50 Azure SQL Databases, each used by a different department. Each database experiences low average usage (less than 5 DTU on average) but unpredictable hourly peaks that can reach up to 50 DTU for short bursts. The company wants to minimize total cost while ensuring every database can handle its peak load without performance degradation. Which Azure SQL Database deployment option should the company choose?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

Clue: "minimum / minimize"
Why it matters: Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.

Question 1mediummultiple choice

Full question →

A
Azure SQL Database elastic pool
Correct. An elastic pool allows multiple databases to share a pool of resources (DTUs or vCores). Each database can burst up to the pool's limit, accommodating peak loads cost-effectively because the pooled resources are larger than any single database's average but smaller than the sum of all peaks.
B
Azure SQL Database single database with 50 DTU
Why wrong: Incorrect. A single database with 50 DTU provisioned for each of the 50 databases would be extremely expensive because most of the time the databases use only 5 DTU. The cost would be far higher than an elastic pool while not providing additional benefit.
C
Azure SQL Managed Instance
Why wrong: Incorrect. Azure SQL Managed Instance offers instance-level compatibility and is optimized for migrations from on-premises SQL Server. It does not provide the granular resource-sharing model of elastic pools for many small databases. It would be overprovisioned and more costly for this use case.
D
SQL Server on an Azure virtual machine
Why wrong: Incorrect. Running SQL Server on an Azure VM is an IaaS solution that requires manual management of SQL Server licenses, patching, and scaling. It offers more control but is less cost-effective and more complex to manage than a PaaS elastic pool for this pattern of many small databases with variable peaks.

Full breakdown with real-world context →

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Azure SQL Database elastic pool

Azure SQL Database elastic pool is the correct choice because it allows multiple databases to share a fixed pool of DTU resources, enabling the aggregated peak loads to be handled efficiently without over-provisioning each database individually. With low average usage (less than 5 DTU) but unpredictable bursts up to 50 DTU, an elastic pool provides the necessary headroom for spikes while minimizing total cost by only paying for the pooled eDTUs, not per-database maximums.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

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

✓
Azure SQL Database elastic pool
Why this is correct
Correct. An elastic pool allows multiple databases to share a pool of resources (DTUs or vCores). Each database can burst up to the pool's limit, accommodating peak loads cost-effectively because the pooled resources are larger than any single database's average but smaller than the sum of all peaks.
Clue confirmation
The clue word "minimum / minimize" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
Azure SQL Database single database with 50 DTU
Why it's wrong here
Incorrect. A single database with 50 DTU provisioned for each of the 50 databases would be extremely expensive because most of the time the databases use only 5 DTU. The cost would be far higher than an elastic pool while not providing additional benefit.
✗
Azure SQL Managed Instance
Why it's wrong here
Incorrect. Azure SQL Managed Instance offers instance-level compatibility and is optimized for migrations from on-premises SQL Server. It does not provide the granular resource-sharing model of elastic pools for many small databases. It would be overprovisioned and more costly for this use case.
✗
SQL Server on an Azure virtual machine
Why it's wrong here
Incorrect. Running SQL Server on an Azure VM is an IaaS solution that requires manual management of SQL Server licenses, patching, and scaling. It offers more control but is less cost-effective and more complex to manage than a PaaS elastic pool for this pattern of many small databases with variable peaks.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often choose the single database with 50 DTU (Option B) because they focus on the peak requirement (50 DTU) without considering the cost inefficiency of provisioning each database for its maximum, missing the elastic pool's ability to share resources and reduce total cost.

Detailed technical explanation

How to think about this question

Under the hood, elastic pools use a shared resource model where the total eDTUs (or vCores) are allocated across all databases in the pool, and each database can burst up to the pool's max eDTU limit (e.g., 50 eDTU per database) as long as the aggregate pool consumption does not exceed the pool's total eDTU. This leverages the statistical multiplexing effect—since not all databases peak simultaneously, the pool can be sized for the sum of averages rather than the sum of peaks, often yielding 3-5x cost savings. A real-world scenario is a SaaS provider with hundreds of tenant databases; elastic pools allow them to handle sporadic usage spikes without over-provisioning each tenant's database.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.

TExam Day Tips

Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A startup's cloud architect reviews their monthly bill and notices costs are higher than expected for a long-running batch job. Switching from on-demand instances to Reserved Instances — or using Spot/Preemptible VMs — can reduce compute costs by up to 72 %. Questions like this test whether you understand the tradeoffs between commitment, flexibility, and cost across cloud pricing models.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related AZ-900 practice-question pages

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

Describe cloud concepts practice questions

Practise AZ-900 questions linked to Describe cloud concepts.

Describe Azure architecture and services practice questions

Practise AZ-900 questions linked to Describe Azure architecture and services.

Describe Azure management and governance practice questions

Practise AZ-900 questions linked to Describe Azure management and governance.

AZ-900 Azure services practice questions

Practise AZ-900 questions linked to AZ-900 Azure services.

AZ-900 pricing and support practice questions

Practise AZ-900 questions linked to AZ-900 pricing and support.

AZ-900 security and compliance practice questions

Practise AZ-900 questions linked to AZ-900 security and compliance.

AZ-900 governance practice questions

Practise AZ-900 questions linked to AZ-900 governance.

Practice this exam

Start a free AZ-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

AZ-900 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this AZ-900 question test?

Describe Azure architecture and services — This question tests Describe Azure architecture and services — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Azure SQL Database elastic pool — Azure SQL Database elastic pool is the correct choice because it allows multiple databases to share a fixed pool of DTU resources, enabling the aggregated peak loads to be handled efficiently without over-provisioning each database individually. With low average usage (less than 5 DTU) but unpredictable bursts up to 50 DTU, an elastic pool provides the necessary headroom for spikes while minimizing total cost by only paying for the pooled eDTUs, not per-database maximums.

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

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "minimum / minimize". Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.