Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A company plans to migrate an on-premises database environment to Azure. The environment contains multiple databases that require the execution of native cross-database queries using three-part names. In addition, the databases rely heavily on SQL Server Agent for scheduled ETL processes.

Which two database options should you recommend to support this migration? (Select two.)

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

Cevap

Azure SQL Managed Instance and SQL Server on Azure Virtual Machines are the correct options.
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines both support SQL Server Agent and native cross-database queries using three-part names because they provide instance-level SQL Server features. Managed Instance offers these capabilities with the benefits of a fully managed service (PaaS), while SQL Server on Azure VMs provides a complete SQL Server environment in an infrastructure-as-a-service (IaaS) model.

Adım Adım Çözüm

1
Analyze the technical requirements of the migration: SQL Server Agent and native cross-database queries using three-part names.
These are instance-level features of SQL Server.
Knowing that these are instance-level features helps eliminate options that only operate at the database level.
2
Evaluate the capabilities of Azure SQL Database offerings (single database and elastic pools).
Azure SQL Database does not natively support SQL Server Agent or native cross-database queries using three-part names.
Azure SQL Database is a database-scoped service and does not support these instance-level capabilities.
3
Evaluate the capabilities of Azure SQL Managed Instance and SQL Server on Azure VMs.
Both offerings provide instance-scoped database engines that support SQL Server Agent and cross-database queries.
Azure SQL Managed Instance provides near-complete compatibility with SQL Server, and SQL Server on Azure VMs runs a full SQL Server instance.

Anahtar Kavram

Instance-level vs. database-level feature compatibility in Azure SQL options
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru