nerdexam
Microsoft

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.

Submitted by omar99· Mar 30, 2026Analyze solution requirements

Question

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

Options

  • ASQL Server on Azure Virtual Machines
  • BAzure SOL Database
  • CAzure HDInsight
  • DAzure Cosmos DB

How the community answered

(23 responses)
  • A
    13% (3)
  • B
    83% (19)
  • C
    4% (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.

ASQL Server on Azure Virtual Machines

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.

BAzure SOL DatabaseCorrect

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.

CAzure HDInsight

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.

DAzure Cosmos DB

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

#Azure SQL Database#managed database#PaaS#relational database

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice