Examkin

Question

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

A company is developing a custom accounting application that requires a relational database with strict schema enforcement and transactional integrity (ACID compliance). The solution must minimize administrative overhead, and Microsoft must be responsible for operating system patching and database engine updates. Which Azure service should the company select?

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

Answer

Azure SQL Database
Azure SQL Database is the correct choice because it is a fully managed relational database engine (PaaS) that handles operating system patching, updates, and backups automatically while providing relational features and transactional integrity (ACID compliance).

Step-by-Step Solution

1
Analyze the application requirements
The application requires a relational database structure with strict schema enforcement and transactional integrity.
This narrows the choices down to relational database options.
2
Analyze the management requirements
The company wants to minimize administrative overhead, and Microsoft must handle OS patching and database engine updates.
This requires a Platform as a Service (PaaS) database service.
3
Match the combined requirements to the correct Azure service
Azure SQL Database fits both the relational database requirement and the fully managed PaaS requirement.
It handles patching automatically and offers full relational capabilities.

Key Concept

Selecting Azure relational database services and understanding PaaS vs IaaS management responsibilities
Estimated Time:1m 0s
Rate this question

Topics

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

More questions from this topic