Comprehensive Detailed Explanation
The requirement is:
Implement a relational database in Azure.
Minimize ongoing maintenance.
Let’s analyze each option:
A. SQL Server on Azure Virtual Machines
This is an IaaS solution.
You (the customer) are responsible for OS patching, SQL Server installation, backups, updates, and maintenance.
High maintenance burden → not the right choice.
B. Azure SQL Database
This is a PaaS (Platform as a Service) offering.
Microsoft manages infrastructure, patching, backups, and high availability.
You only manage the schema, tables, and data.
Best fit for minimizing maintenance.
C. Azure HDInsight
This is a big data and analytics service, designed for Hadoop, Spark, Hive, etc.
Not a relational database. → incorrect.
D. Azure Cosmos DB
This is a globally distributed NoSQL database (supports multiple APIs: SQL API, MongoDB API, Cassandra API, etc.).
While it reduces maintenance, it is not a relational database. → incorrect.
Correct Answer: B. Azure SQL Database
Microsoft References
What is Azure SQL Database?
SQL Server on Azure VMs vs. Azure SQL Database
