Examkin

Question

Difficulty: MediumAzure Database Services (Relational, Non-Relational, and Cosmos DB)

An enterprise is migrating its on-premises SQL Server-based human resources (HR) application to Azure. The application requires a relational database that supports strict schema constraints, ACID transactions, and SQL Server compatibility. The enterprise wants to minimize administrative overhead by ensuring that Microsoft automatically handles operating system updates and database patching. Which Azure service should the enterprise select?

  1. Azure SQL DatabaseAnswer
  2. B
    Azure Cosmos DB
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure Database for PostgreSQL

Answer

Azure SQL Database
Azure SQL Database is a fully managed relational database service (Platform as a Service) that provides SQL Server compatibility, strict schema enforcement, ACID compliance, and automatic operating system and database engine patching by Microsoft.

Step-by-Step Solution

1
Identify the database model requirement from the scenario.
The scenario requires a relational database that supports traditional schemas, ACID transactions, and SQL Server compatibility.
This rules out non-relational (NoSQL) databases.
2
Identify the management and patching requirements.
The solution must be fully managed with Microsoft handling operating system and database patching, which points to a Platform as a Service (PaaS) database service.
This rules out Infrastructure as a Service (IaaS) database hosting where the customer manages the operating system.
3
Select the service that satisfies both the relational and fully managed requirements.
Azure SQL Database is a fully managed relational database service (PaaS) that meets all the criteria.
It matches the schema, compatibility, and management requirements.

Key Concept

Azure relational database services and their management models (PaaS vs. IaaS)
Estimated Time:1m 0s
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic