Examkin

Soru

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

An organization is planning to deploy different database workloads to Microsoft Azure. Match each Azure database service to its corresponding capability description.

  • Azure Cosmos DBA multi-model database service designed for non-relational data with global scale and schema-less storage.
  • Azure SQL Managed InstanceA fully managed relational database service that supports SQL Server agent and cross-database queries without providing operating system access.
  • SQL Server on Azure Virtual MachinesA relational database deployment that provides full administrative control over the operating system and database configuration.

Cevap

Azure Cosmos DB matches the multi-model database service for non-relational data. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system.
Azure Cosmos DB matches the multi-model database service because it is Azure's flagship globally distributed NoSQL database. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access because it acts as a PaaS database offering high compatibility with SQL Server engine features without OS management. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system because it is an IaaS solution that places the entire VM under customer control.

Adım Adım Çözüm

1
Identify the data model and management requirements of the workloads.
Separate the requirements into non-relational (NoSQL), managed relational (PaaS) with specific legacy feature support, and full OS-level control (IaaS).
Azure offers distinct database services optimized for relational versus non-relational data, as well as different levels of administrative management.
2
Map the non-relational workload requirements to the correct service.
Azure Cosmos DB is selected for its schema-less, multi-model, and globally distributed non-relational capabilities.
Cosmos DB is the primary Azure PaaS offering designed specifically for high-performance, non-relational datasets.
3
Differentiate between the two SQL Server relational deployment options based on administrative control.
SQL Server on Azure VMs maps to the option with full operating system access, while Azure SQL Managed Instance maps to the fully managed service without operating system access.
Virtual Machines represent Infrastructure as a Service (IaaS) where you retain OS access, whereas SQL Managed Instance is a Platform as a Service (PaaS) where Microsoft manages the OS.

Anahtar Kavram

Understanding the differences between Azure relational databases (Azure SQL Managed Instance, SQL Server on Azure VMs) and non-relational databases (Azure Cosmos DB), alongside IaaS versus PaaS management models.
Bu soruyu puanla

Konular

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

Bu konudan daha fazla soru