Azure SQL Database Serverless Use Cases
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?
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.
⚠ Common exam trap
It's easy for candidates to 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.
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 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.
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 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.
- ✗
Azure SQL Managed Instance
Why it's wrong here
Higher cost, no serverless, more administration.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
Learn chapter
Relational Data Concepts
Key term
Relational database
A relational database organizes data into tables with rows and columns, where each table relates to others using unique keys, allowing efficient storage, retrieval, and manipulation of structured information.
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DP-900
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?
easy- A.SQL Server on Azure Virtual Machines
- ✓ B.Azure SQL Database (serverless tier)
- C.Azure SQL Managed Instance
- D.Azure Database for MySQL
Why 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.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.