Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A company plans to migrate an on-premises inventory management database system to Azure. The system requires support for SQL Server Agent to run automated tasks and native cross-database queries. The database must remain highly available and survive the outage of an entire Azure availability zone. The company wants to minimize the administrative overhead of managing the underlying operating system, patching, and backups. Which Azure SQL deployment option should you choose?

  1. A
    SQL Server on an Azure Virtual Machine using locally redundant storage
  2. Azure SQL Managed Instance with zone redundancyCevap
  3. C
    Azure SQL Database single database with zone redundancy
  4. D
    Azure SQL Database elastic pool

Cevap

Azure SQL Managed Instance with zone redundancy
The correct option is Azure SQL Managed Instance with zone redundancy because it satisfies the need for instance-level features (SQL Server Agent and cross-database queries) while minimizing administrative overhead by offering a fully managed PaaS model. Configuring it with zone redundancy ensures the database can survive an availability zone outage.

Adım Adım Çözüm

1
Evaluate feature requirements for SQL Server Agent and cross-database queries.
Identify that instance-level capabilities are required, which rules out Azure SQL Database single database and elastic pool.
Azure SQL Database single database and elastic pools do not natively support SQL Server Agent or cross-database queries.
2
Assess administrative overhead requirements.
Exclude SQL Server on Azure Virtual Machines.
SQL Server on Azure Virtual Machines is an IaaS option that requires the operations team to handle OS patching, database backups, and high availability, violating the requirement to minimize administrative overhead.
3
Verify high availability and zone resilience requirements.
Select Azure SQL Managed Instance configured with zone redundancy.
Azure SQL Managed Instance supports zone redundancy to ensure application uptime during an availability zone outage while providing fully managed backups and patching.

Anahtar Kavram

Selecting appropriate Azure SQL relational database deployment options based on legacy feature support, administrative overhead, and high availability constraints.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru