AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a fully managed relational database with built-in high availability, automated backups, and intelligent performance optimization for SQL Server workloads?
⚠ Common exam trap
A common mix-up: candidates confuse 'fully managed relational database' with 'SQL Server on Azure VMs' because both run SQL Server, but the key distinction is that Azure SQL Database is PaaS (no management overhead) while SQL Server on Azure VMs is IaaS (you manage the SQL Server and high availability).
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
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational database engine that handles SQL Server workloads. It provides built-in high availability with a 99.99% SLA, automated backups with point-in-time restore, and intelligent performance optimization features like automatic tuning and intelligent insights, all without requiring any manual patching or infrastructure management.
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
Why it's wrong here
Azure Database for MySQL is a PaaS relational database service, but it is built around the MySQL engine, not the Microsoft SQL Server engine. Choosing it for a SQL Server workload would require re-platforming the application, rewriting T-SQL-specific code, and changing connection strings, because it does not support SQL Server features like SQL Server Agent or T-SQL language extensions. Therefore it is not the correct answer when a fully managed SQL Server offering is needed.
- ✓
Azure SQL Database
Why this is correct
Azure SQL Database is the correct fully managed PaaS option for SQL Server workloads. Microsoft handles the underlying infrastructure, operating system, SQL Server patches, built-in high availability, automatic backups, and point-in-time restore, so you only manage the database schema and data. It is the direct service-level answer for running SQL Server without managing virtual machines.
- ✗
SQL Server on Azure VMs
Why it's wrong here
SQL Server on Azure VMs provisions an actual virtual machine image with SQL Server installed, which is an IaaS model. You are responsible for configuring and patching the OS and SQL Server, managing backups, and implementing your own high-availability solutions, so it is not fully managed. Although it supports full SQL Server compatibility, the operational overhead makes it the wrong choice for a fully managed requirement.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service that supports document, key-value, graph, and columnar data models with APIs such as Core (SQL), MongoDB, Cassandra, Table, and Gremlin. Its query language is not the T-SQL relational dialect used by Microsoft SQL Server, and it does not provide SQL Server compatibility. Thus it is wrong for a SQL Server relational database scenario.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
High availability
High availability is a system design approach that aims to keep applications and services operational and accessible with minimal downtime, even when some components fail.
Key term
PaaS
Platform as a Service (PaaS) is a cloud computing model that provides a managed platform for developers to build, run, and manage applications without dealing with the underlying infrastructure.
About these practice questions
One of 981 original AZ-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 →
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.