AI-102 · Question #126
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
The correct answer is B. Azure SOL Database. To implement a relational database in Azure with minimized ongoing maintenance, Azure SQL Database is the appropriate choice as it is a fully managed PaaS offering.
Question
Options
- ASQL Server on Azure Virtual Machines
- BAzure SOL Database
- CAzure HDInsight
- DAzure Cosmos DB
How the community answered
(23 responses)- A13% (3)
- B83% (19)
- C4% (1)
Why each option
To implement a relational database in Azure with minimized ongoing maintenance, Azure SQL Database is the appropriate choice as it is a fully managed PaaS offering.
SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering, which requires the user to manage the operating system, SQL Server installation, and patching, leading to higher ongoing maintenance.
Azure SQL Database is a fully managed Platform as a Service (PaaS) relational database offering that automates many administrative tasks like patching, backups, and high availability, significantly reducing ongoing maintenance for users.
Azure HDInsight is a managed analytics service for big data processing using open-source frameworks like Hadoop and Spark, not primarily a relational database, and does not fit the requirement.
Azure Cosmos DB is a globally distributed NoSQL database service, not a relational database, and thus does not meet the "relational database" requirement.
Concept tested: Azure relational database PaaS offerings
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
Topics
Community Discussion
No community discussion yet for this question.