AZ-900 Describe Azure architecture and services Practice Question
A company is designing a multi-tier application on Azure. The web tier needs to scale out based on CPU usage, while the database tier requires high-performance storage for transactional data. Which combination of Azure services should they choose?
⚠ Common exam trap
Watch out — candidates often confuse Azure Functions with App Service for web tier scaling, overlooking that Functions is for event-driven, stateless code, not for a full web application with persistent scaling needs.
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 App Service and Azure SQL Database
Azure App Service provides built-in autoscaling based on metrics like CPU usage, making it ideal for the web tier that needs to scale out. Azure SQL Database offers high-performance, low-latency storage for transactional data with features like automatic indexing and in-memory OLTP, meeting the database tier's requirements.
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 Functions and Azure Cosmos DB
Why it's wrong here
Azure Functions is a serverless compute service that scales to zero and executes code on triggers; it is not intended to host an always-on web tier, because it introduces cold starts and lacks persistent application state. Azure Cosmos DB is a multi-model NoSQL database with horizontal partitioning and wire protocols for MongoDB/Cassandra, not a relational engine, so it cannot replace a SQL database for ACID-heavy transaction processing in a traditional web app.
When this WOULD be correct
A company needs a serverless compute solution for event-driven workloads (e.g., processing IoT data) and a globally distributed NoSQL database for low-latency access. The question would specify event-driven scaling and NoSQL requirements.
- ✓
Azure App Service and Azure SQL Database
Why this is correct
Azure App Service is a fully managed PaaS offering for web applications that provides automatic scaling, load balancing, and built-in DevOps capabilities without managing VMs. Azure SQL Database is a managed relational database with high availability, automated backups, and a compatibility level for typical transactional SQL workloads. Together they form a standard multi-tier stack where the web tier handles HTTP requests and the data tier stores structured data with low-latency access.
- ✗
Azure Virtual Machine Scale Sets and Azure Files
Why it's wrong here
Azure Virtual Machine Scale Sets provide autoscaling for compute, but Azure Files offers shared file storage with latency unsuitable for transactional database workloads, which require low-latency block storage such as Azure SQL Database or managed disks. This combination tempts because Azure Files is a convenient shared storage for web-tier static content or application configuration, where throughput matters more than sub-millisecond I/O.
When this WOULD be correct
A company needs to run a legacy application with stateful VMs that require shared file storage across instances, and the database tier can use a separate VM with managed disks for performance. The question would emphasize lift-and-shift migration with minimal code changes.
- ✗
Azure Kubernetes Service and Blob Storage
Why it's wrong here
Azure Kubernetes Service gives you managed Kubernetes orchestration but requires cluster management, autoscaling of pods, and more operational overhead than PaaS web hosting, making it heavier than necessary for a typical web tier. Blob Storage is object storage optimized for large amounts of unstructured data; it is accessed via REST and has higher latency per I/O than block-based database storage, so it is unsuitable for transactional workloads that require low-latency reads and writes. This pairing might be considered because AKS scales containers and Blob can hold static assets, but it does not provide a relational database tier.
When this WOULD be correct
A company needs to run containerized microservices with auto-scaling and store large amounts of unstructured data (e.g., images, videos) with high durability and low cost.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The AZ-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Azure App Service and Azure SQL DatabaseCorrect answer▾
Why this is correct
Azure App Service is a fully managed PaaS offering for web applications that provides automatic scaling, load balancing, and built-in DevOps capabilities without managing VMs. Azure SQL Database is a managed relational database with high availability, automated backups, and a compatibility level for typical transactional SQL workloads. Together they form a standard multi-tier stack where the web tier handles HTTP requests and the data tier stores structured data with low-latency access.
✗Azure Functions and Azure Cosmos DBWrong answer — click to see why▾
Why this is wrong here
Azure Functions is event-driven and not designed for scaling a web tier based on CPU usage; it scales based on events. Azure Cosmos DB is a NoSQL database, not optimized for high-performance transactional storage like SQL databases.
★ When this WOULD be the correct answer
A company needs a serverless compute solution for event-driven workloads (e.g., processing IoT data) and a globally distributed NoSQL database for low-latency access. The question would specify event-driven scaling and NoSQL requirements.
Why candidates choose this
Candidates may associate 'scaling out' with serverless (Functions) and 'high-performance' with Cosmos DB, overlooking that the web tier requires CPU-based scaling and the database tier needs transactional support.
✗Azure Virtual Machine Scale Sets and Azure FilesWrong answer — click to see why▾
Why this is wrong here
Azure Files provides shared file storage, not high-performance transactional storage needed for a database tier. Virtual Machine Scale Sets can scale VMs but require manual database management, unlike Azure SQL Database's managed scaling.
★ When this WOULD be the correct answer
A company needs to run a legacy application with stateful VMs that require shared file storage across instances, and the database tier can use a separate VM with managed disks for performance. The question would emphasize lift-and-shift migration with minimal code changes.
Why candidates choose this
Candidates may confuse 'scaling out' with Virtual Machine Scale Sets and think Azure Files is suitable for databases, overlooking that Azure Files is not optimized for transactional workloads.
✗Azure Kubernetes Service and Blob StorageWrong answer — click to see why▾
Why this is wrong here
Azure Kubernetes Service (AKS) is for container orchestration, not a simple web tier scaling solution, and Blob Storage is object storage, not suitable for high-performance transactional database workloads.
★ When this WOULD be the correct answer
A company needs to run containerized microservices with auto-scaling and store large amounts of unstructured data (e.g., images, videos) with high durability and low cost.
Why candidates choose this
Candidates may associate AKS with scaling and Blob Storage with Azure storage, overlooking the specific requirements for a multi-tier app with a transactional database.
Analysis generated from the official AZ-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
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.
Key term
Azure App Service
Azure App Service is a fully managed platform for building, deploying, and scaling web applications and APIs without managing the underlying infrastructure.
About these practice questions
This AZ-900 question is part of Courseiva's 981-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.