Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A company is planning to migrate an on-premises inventory application to Azure. The application database tier consists of three databases that frequently execute cross-database queries using three-part names. The databases also rely on SQL Server Agent for scheduled data-cleansing jobs. You need to design a relational data storage solution that supports these database features while minimizing the operational effort required to manage operating system patching and backups.

Which Azure SQL deployment option should you recommend?

  1. A
    Azure SQL Database single database
  2. B
    Azure SQL Database elastic pool
  3. Azure SQL Database Managed InstanceCevap
  4. D
    SQL Server on Azure Virtual Machines (VMs)

Cevap

Azure SQL Database Managed Instance
The correct answer is Azure SQL Database Managed Instance. It supports near 100% compatibility with the on-premises SQL Server database engine, including native support for SQL Server Agent and cross-database queries. As a Platform as a Service (PaaS) offering, it automatically handles operating system updates, database engine patching, and backups, which satisfies the requirement to minimize administrative overhead.

Adım Adım Çözüm

1
Analyze the technical requirements of the on-premises database tier.
Identify the need for SQL Server Agent for scheduled jobs and cross-database query support (three-part names).
Determining compatibility constraints is the first step in mapping workloads to the correct Azure SQL service.
2
Evaluate the management and administrative overhead constraints.
Note that the solution must minimize operational effort for OS patching and backups.
This requirement points toward a Platform as a Service (PaaS) solution rather than an Infrastructure as a Service (IaaS) solution.
3
Match requirements against the capabilities of Azure SQL tiers.
Select Azure SQL Database Managed Instance because it offers near-complete compatibility with SQL Server features like SQL Server Agent and cross-database queries, while operating as a fully managed PaaS database service.
Only the Managed Instance tier satisfies all technical features without requiring the operational overhead of managing virtual machines.

Anahtar Kavram

Selecting Azure SQL deployment options based on legacy SQL Server feature requirements and management boundaries.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru