Examkin

Question

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

A global organization is designing a cloud architecture on Azure. They have two primary database requirements:

1. A database for a real-time recommendation engine that requires horizontal scaling, global distribution with multi-region writes, and support for Cassandra and Graph APIs.
2. A transactional relational database for financial audit logs where the organization requires built-in high availability and automatic operating system patching, without the administrative overhead of managing virtual machines.

Which combination of Azure services and deployment models meets these requirements?

  1. Azure Cosmos DB (a Platform as a Service multi-model service) for the recommendation engine, and Azure SQL Database (a Platform as a Service relational service) for the financial logs.Answer
  2. B
    Azure Cosmos DB (a Platform as a Service relational service) for the recommendation engine, and Azure SQL Database (a Platform as a Service relational service) for the financial logs.
  3. C
    Azure Cosmos DB (a Platform as a Service multi-model service) for the recommendation engine, and SQL Server on Azure Virtual Machines (a Platform as a Service relational service) for the financial logs.
  4. D
    Azure Cosmos DB (a Software as a Service database service) for the recommendation engine, and Azure SQL Database (a Software as a Service database service) for the financial logs.

Answer

Azure Cosmos DB (a Platform as a Service multi-model service) for the recommendation engine, and Azure SQL Database (a Platform as a Service relational service) for the financial logs.
The correct option accurately maps the multi-model requirements of the recommendation engine (Cassandra and Gremlin APIs) to Azure Cosmos DB, a PaaS service. It also matches the relational financial database to Azure SQL Database, which automatically manages host OS patching and high availability as a PaaS service.

Step-by-Step Solution

1
Analyze the requirements for the recommendation engine.
The recommendation engine requires horizontal scale, global multi-region writes, and compatibility with Cassandra and Graph APIs, which points to a NoSQL multi-model service.
Azure Cosmos DB is Azure's premier NoSQL multi-model PaaS database service designed to satisfy these specific API and scalability requirements.
2
Analyze the requirements for the financial logs database.
The financial logs database requires a relational model where Azure automatically manages host operating system patching and high availability, without the customer managing virtual machines.
Azure SQL Database is a fully managed relational PaaS database that satisfies the schema constraints and eliminates OS administration overhead.
3
Map the selected services to their correct cloud deployment models.
Both Azure Cosmos DB and Azure SQL Database are deployed as Platform as a Service (PaaS) database options.
Under the shared responsibility model, PaaS ensures that Microsoft manages OS patching, physical infrastructure, and high availability, while the customer manages database configuration and data.

Key Concept

Azure relational and non-relational database services and their cloud service models.
Estimated Time:2m 0s
Rate this question

Topics

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

More questions from this topic