Examkin

Question

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

A company needs to deploy a database in Azure that supports traditional relational database constraints, ACID transactions, and structured schemas. To minimize administration, the company wants to avoid managing the underlying virtual machines and operating systems. Which Azure service should the company select?

  1. A
    Azure Cosmos DB
  2. Azure SQL DatabaseAnswer
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Microsoft 365

Answer

Azure SQL Database
Azure SQL Database is a fully managed Platform as a Service (PaaS) database engine. It provides native support for relational constraints, structured schemas, and ACID transactions while offloading all underlying operating system and software maintenance, backups, and patching to Microsoft.

Step-by-Step Solution

1
Identify the data structure requirement.
The application requires a database that supports traditional relational database constraints, ACID transactions, and structured schemas.
This rules out non-relational database services such as Azure Cosmos DB.
2
Identify the management and administrative requirements.
The company wants to avoid managing the underlying virtual machines and operating systems.
This dictates a Platform as a Service (PaaS) database option, ruling out Infrastructure as a Service (IaaS) solutions like running SQL Server on Virtual Machines.
3
Select the service that meets both requirements.
Azure SQL Database is a relational database service provided as a fully managed PaaS.
It offers full SQL Server relational capabilities while Microsoft manages all hardware, VM patching, and operating system updates.

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