Examkin

Question

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

An organization is deploying a new application that requires a relational database. They want a service where Microsoft automatically manages the underlying operating system patching, hardware maintenance, and database engine updates. Which Azure service should the organization choose?

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

Answer

Azure SQL Database
Azure SQL Database is a fully managed Platform as a Service (PaaS) database engine that handles database management functions such as upgrading, patching, backups, and monitoring without user involvement. It also natively supports relational database workloads.

Step-by-Step Solution

1
Identify the database structure requirement from the scenario.
The application requires a relational database.
This rules out non-relational database services such as Azure Cosmos DB.
2
Determine the management model requirement for maintenance tasks like OS patching and database engine updates.
The organization wants Microsoft to handle all patching and engine updates automatically, indicating a Platform as a Service (PaaS) database service.
This rules out Infrastructure as a Service (IaaS) offerings like SQL Server on Azure Virtual Machines, where the customer is responsible for maintaining the operating system and database software.

Key Concept

Azure PaaS Relational Database Services vs. IaaS and NoSQL
Estimated Time:45s
Rate this question

Topics

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

More questions from this topic