Soru

Zorluk: OrtaAzure Database Services (Relational, Non-Relational, and Cosmos DB)

A company is planning to host four new application workloads on Microsoft Azure. Each workload has specific database requirements. Which Azure database service should you select for each application workload?

  • A web application that stores semi-structured catalog data using JSON documents and requires global distribution with guaranteed single-digit millisecond latency.Azure Cosmos DB
  • A corporate application migrating from an on-premises Microsoft SQL Server environment that requires a fully managed relational database engine with high compatibility.Azure SQL Database
  • An open-source application built using the LAMP stack (Linux, Apache, MySQL, PHP) that requires a managed relational database service in Azure.Azure Database for MySQL
  • An analytics application that requires a fully managed relational database based on the PostgreSQL engine to run complex spatial queries.Azure Database for PostgreSQL

Cevap

Match the web application requiring JSON documents and low latency with Azure Cosmos DB; match the corporate SQL Server migration with Azure SQL Database; match the LAMP stack application with Azure Database for MySQL; and match the PostgreSQL analytics application with Azure Database for PostgreSQL.
The correct matches correctly align the application workload requirements with their targeted Azure Database services. Relational database engines (SQL Server, MySQL, PostgreSQL) are matched to their corresponding managed PaaS offerings (Azure SQL Database, Azure Database for MySQL, Azure Database for PostgreSQL), while the non-relational JSON workload with global scaling needs is matched to Azure Cosmos DB.

Adım Adım Çözüm

1
Analyze the web application workload.
The requirement specifies JSON documents, global distribution, and single-digit millisecond latency, which describes the capabilities of a NoSQL database system.
Azure Cosmos DB is Azure's premier NoSQL and globally distributed database solution.
2
Analyze the corporate application migration.
The workload requires high compatibility with Microsoft SQL Server in a fully managed Platform as a Service (PaaS) format.
Azure SQL Database offers a managed relational database engine natively compatible with on-premises SQL Server.
3
Analyze the open-source web application stack.
The workload utilizes the traditional LAMP stack, which relies specifically on the MySQL database engine.
Azure Database for MySQL provides a fully managed community edition of MySQL.
4
Analyze the analytics application workload.
The requirement specifies a managed relational database that must be based on the PostgreSQL engine.
Azure Database for PostgreSQL is the designated managed service for hosting community-edition PostgreSQL workloads in Azure.

Anahtar Kavram

Selecting the correct Azure database service based on relational versus non-relational database types, compatibility requirements, and engine types.
Tahmini Süre:1m 30s
Bu soruyu puanla