Quick Answer
The answer is Azure SQL Database serverless. This service is the correct choice because it offers a consumption-based pricing model that automatically pauses the database during periods of inactivity and scales compute resources on demand, perfectly matching the startup’s need for minimal administration, automatic scaling during peak usage, and a limited budget. On the Microsoft Azure Data Fundamentals DP-900 exam, this scenario tests your understanding of how serverless compute tiers differ from provisioned tiers, specifically that serverless is designed for intermittent, unpredictable workloads rather than steady-state traffic. A common trap is selecting Azure SQL Database with a provisioned tier, which charges for allocated resources even when idle, or choosing Azure Cosmos DB, which is NoSQL and not relational. Remember the memory tip: “Serverless sleeps when you do” — it pauses during inactivity, saving costs for apps like fitness trackers with variable usage patterns.
This DP-900 practice question tests your understanding of identify considerations for relational data on azure. 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 startup is building a new mobile app that will track user fitness activities. They need a relational database to store user profiles, activity logs, and goals. The database must be easy to set up, require minimal administration, and automatically scale during peak usage. The startup has a limited budget and prefers a consumption-based pricing model. Which Azure service should they choose?
Azure Database for MySQL serverless
Why wrong: MySQL is relational, but Azure SQL Database serverless is more commonly used for new apps.
SQL Server on Azure Virtual Machines
Why wrong: Requires manual administration and scaling.
Azure SQL Database serverless
Serverless offers consumption-based pricing and auto-scaling.
Azure SQL Managed Instance
Why wrong: Higher cost, no serverless, more administration.
Answer choices
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 serverless
Azure SQL Database serverless is the correct choice because it provides a consumption-based pricing model that automatically pauses during inactivity and scales compute resources based on demand, requiring minimal administration. This aligns perfectly with the startup's need for easy setup, minimal administration, automatic scaling during peak usage, and a limited budget.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Azure Database for MySQL serverless
Why it's wrong here
MySQL is relational, but Azure SQL Database serverless is more commonly used for new apps.
SQL Server on Azure Virtual Machines
Why it's wrong here
Requires manual administration and scaling.
Azure SQL Database serverless
Why this is correct
Serverless offers consumption-based pricing and auto-scaling.
Related concept
Read the scenario before looking for a memorised answer.
Azure SQL Managed Instance
Why it's wrong here
Higher cost, no serverless, more administration.
Common exam traps
The trap here is that candidates may confuse 'serverless' with 'PaaS' and choose Azure Database for MySQL serverless (Option A) because it also offers consumption-based pricing, but the question specifies a relational database for user profiles, activity logs, and goals, and Azure SQL Database serverless provides better integration with .NET and other Microsoft technologies commonly used in mobile app backends.
Detailed technical explanation
Azure SQL Database serverless uses a compute auto-scaling model where the database pauses after a configurable period of inactivity (default 1 hour), resuming automatically on the next connection, and billing is per second for compute used. This is ideal for intermittent workloads like a fitness app where usage spikes during peak hours (e.g., morning workouts) but drops at night, allowing the startup to pay only for actual compute consumption rather than provisioned capacity.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
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
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Identify considerations for relational data on Azure — study guide chapter
Learn the concepts, then practise the questions
Identify considerations for relational data on Azure practice questions
Targeted practice on this topic area only
All DP-900 questions
982 questions across all exam domains
Microsoft Azure Data Fundamentals DP-900 study guide
Full concept coverage aligned to exam objectives
DP-900 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise DP-900 questions linked to Describe core data concepts.
Practise DP-900 questions linked to Describe an analytics workload on Azure.
Practise DP-900 questions linked to Identify considerations for relational data on Azure.
Practise DP-900 questions linked to Describe considerations for working with non-relational data on Azure.
Practise DP-900 questions linked to DP-900 fundamentals.
Practise DP-900 questions linked to DP-900 scenario.
Practise DP-900 questions linked to DP-900 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Identify considerations for relational data on Azure — This question tests Identify considerations for relational data on Azure — Read the scenario before looking for a memorised answer..
The correct answer is: Azure SQL Database serverless — Azure SQL Database serverless is the correct choice because it provides a consumption-based pricing model that automatically pauses during inactivity and scales compute resources based on demand, requiring minimal administration. This aligns perfectly with the startup's need for easy setup, minimal administration, automatic scaling during peak usage, and a limited budget.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
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 →
Same concept, more angles
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A small business wants to migrate their on-premises SQL Server database to Azure. They have limited budget and want to minimize ongoing management overhead. The database is less than 50 GB and is used by a single application with low concurrent users. The application requires compatibility with SQL Server features such as T-SQL, stored procedures, and functions. The business does not require high availability or disaster recovery. Which Azure relational database service should they choose?
easyWhy B: Azure SQL Database serverless tier is the best choice because it provides a fully managed, PaaS relational database service that supports T-SQL, stored procedures, and functions, while automatically pausing during idle periods to reduce costs. With a database under 50 GB, low concurrency, and no HA/DR requirements, the serverless tier minimizes both management overhead and cost, as it charges only for compute used per second and storage consumed.
Last reviewed: Jun 24, 2026
This DP-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 DP-900 exam.
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.
Sign in to join the discussion.