Practice Questions
Question 1
Which Azure SQL offering is fully managed and requires the least administrative effort?
A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Synapse Analytics
✅ Answer: C
Explanation:
Azure SQL Database is a fully managed PaaS service with minimal administration.
Question 2
Which Azure SQL service provides the highest level of compatibility with on-premises SQL Server while still being a PaaS solution?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Cosmos DB
✅ Answer: B
Explanation:
Azure SQL Managed Instance offers near 100% compatibility with SQL Server.
Question 3
Which Azure SQL option allows full control over the operating system?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool
✅ Answer: C
Explanation:
SQL Server on Azure VM is an IaaS offering, giving full OS-level control.
Question 4
Which service is BEST suited for a cloud-native application with minimal management overhead?
A. SQL Server on Azure Virtual Machines
B. Azure SQL Managed Instance
C. Azure SQL Database
D. Azure Data Lake
✅ Answer: C
Explanation:
Azure SQL Database is optimized for modern cloud applications.
Question 5
Which Azure SQL service supports instance-level features such as SQL Agent?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Blob Storage
✅ Answer: B
Explanation:
Managed Instance supports many instance-level features not available in Azure SQL Database.
Question 6
A company wants to migrate an existing SQL Server database with minimal changes. Which service should they choose?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure Synapse Analytics
✅ Answer: B
Explanation:
Managed Instance is designed for lift-and-shift migrations with high compatibility.
Question 7
Which Azure SQL option requires you to manage backups, updates, and patching?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool
✅ Answer: C
Explanation:
In IaaS (Azure VM), the customer is responsible for management tasks.
Question 8
Which of the following best describes Platform as a Service (PaaS) in the Azure SQL family?
A. Full control over hardware and OS
B. No database management required at all
C. Azure manages infrastructure and database maintenance
D. Only supports non-relational data
✅ Answer: C
Explanation:
PaaS handles infrastructure, patching, backups, and high availability.
Question 9
Which Azure SQL service is MOST appropriate when you need maximum control and customization?
A. Azure SQL Database
B. Azure SQL Managed Instance
C. SQL Server on Azure Virtual Machines
D. Azure SQL Elastic Pool
✅ Answer: C
Explanation:
SQL Server on Azure VM provides full control over configuration and environment.
Question 10
Which statement best describes the relationship between the Azure SQL family products?
A. They use completely different database engines
B. They all use the SQL Server engine with different management levels
C. Only Azure SQL Database supports SQL
D. Only SQL Server on Azure VM supports relational data
✅ Answer: B
Explanation:
All Azure SQL offerings are based on the SQL Server engine, differing mainly in management and control.
✅ Quick Exam Takeaways
✔ Azure SQL Database
- Fully managed (PaaS)
- Best for cloud-native apps
✔ Azure SQL Managed Instance
- Near full SQL Server compatibility
- Best for migrations
✔ SQL Server on Azure VM
- Full control (IaaS)
- You manage everything
✔ Key concept:
👉 More control = more responsibility
👉 More automation = less control
Go to the DP-900 Exam Prep Hub main page.
The Data Community 