Examkin

Question

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

A software development team is building a custom employee tracking system. They need a database that supports traditional relational schemas, structured query language (SQL), and ACID transactions. Additionally, the team requires that Microsoft automatically manages all operating system patching and database engine updates so they can focus purely on application development. Which Azure service meets these requirements?

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

Answer

Azure SQL Database
Azure SQL Database is a fully managed relational database engine (PaaS) that handles upgrading, patching, backups, and monitoring without user involvement, making it the correct fit for the required relational schema and automatic patching.

Step-by-Step Solution

1
Analyze the database schema and query requirements.
The solution requires traditional relational schemas, SQL, and ACID transactions. This points to a relational database service.
Eliminating non-relational database services such as NoSQL alternatives.
2
Analyze the management and patching requirements.
The customer wants Microsoft to automatically manage the operating system patching and database software updates.
This points to a Platform as a Service (PaaS) offering and eliminates Infrastructure as a Service (IaaS) options like Virtual Machines where the customer is responsible for OS patching.
3
Select the service that is a fully managed PaaS relational database.
Azure SQL Database is a fully managed PaaS relational database that matches all specified criteria.
Ensures the correct balance of relational database features and cloud management responsibilities.

Key Concept

Azure relational database services and PaaS shared responsibility
Rate this question

Topics

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

More questions from this topic