Examkin

Soru

Zorluk: KolayRelational Data Storage Solutions

A company plans to migrate a legacy on-premises database to Azure. The database relies on SQL Server Agent for scheduled maintenance tasks and uses SQL Server Common Language Runtime (CLR) integration. Which of the following Azure relational database solutions natively support both SQL Server Agent and CLR? (Select TWO).

  1. SQL Server on Azure Virtual MachinesCevap
  2. Azure SQL Managed InstanceCevap
  3. C
    Azure SQL Database single database
  4. D
    Azure SQL Database elastic pool

Cevap

SQL Server on Azure Virtual Machines and Azure SQL Managed Instance
SQL Server on Azure Virtual Machines and Azure SQL Managed Instance are the relational database deployment options in Azure that provide instance-level features, including native support for SQL Server Agent and SQL CLR.

Adım Adım Çözüm

1
Identify the key relational database feature requirements.
The requirements are SQL Server Agent and SQL Common Language Runtime (CLR) support.
These are instance-level features commonly used in legacy database workloads.
2
Evaluate Azure SQL options against the requirements.
Azure SQL Database single database and elastic pools do not support SQL Server Agent or CLR natively. Azure SQL Managed Instance and SQL Server on Azure VMs support both features.
To determine which Azure services provide the required feature parity.
3
Select the correct solutions based on the feature comparison.
SQL Server on Azure Virtual Machines and Azure SQL Managed Instance satisfy all criteria.
To choose the relational database options that support the requested features.

Anahtar Kavram

Azure SQL Feature Compatibility
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru