Examkin

Soru

Zorluk: KolayRelational Data Storage Solutions

A medical group is planning to migrate a local relational database to the cloud. The database contains several legacy features, including SQL Server Agent jobs and cross-database queries across two databases. You need to recommend a fully managed database solution that minimizes management overhead while supporting these features. Which Azure SQL deployment option should you select?

  1. A
    Azure SQL Database (Single Database)
  2. B
    Azure SQL Database Elastic Pool
  3. Azure SQL Managed InstanceCevap
  4. D
    SQL Server on Azure Virtual Machines

Cevap

Azure SQL Managed Instance
Azure SQL Managed Instance provides near-100% compatibility with the SQL Server database engine, including support for SQL Server Agent and cross-database queries. Because it is a fully managed platform-as-a-service (PaaS), it also minimizes administrative overhead by automating patching, backups, and high availability.

Adım Adım Çözüm

1
Identify the legacy database feature requirements.
The requirements are support for SQL Server Agent and cross-database queries.
These are instance-level features of SQL Server.
2
Filter Azure SQL options based on support for these legacy features.
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines support both SQL Server Agent and cross-database queries.
Azure SQL Database (Single Database or Elastic Pools) does not support these instance-level features natively.
3
Filter remaining options based on management overhead and platform type.
Azure SQL Managed Instance is chosen because it is a fully managed PaaS solution.
SQL Server on Azure Virtual Machines is an IaaS solution that requires significant administrative effort for OS patching, SQL updates, and backup management.

Anahtar Kavram

Selecting the correct Azure SQL service based on compatibility with instance-level features and administrative management overhead.
Tahmini Süre:45s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru