Examkin

Soru

Zorluk: KolayRelational Data Storage Solutions

An educational institution wants to move its student grading database from a local server to Azure. The database configuration depends on SQL Server Agent to run automated weekly reports, and uses cross-database queries to reference records in a separate database on the same server.

Which two Azure SQL options support these requirements? (Choose two.)

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

Cevap

The correct database deployment options are Azure SQL Managed Instance and SQL Server on Azure Virtual Machines.
The correct options are Azure SQL Managed Instance and SQL Server on Azure Virtual Machines. Both options provide the compatibility required to support SQL Server Agent and cross-database queries. Azure SQL Managed Instance provides these capabilities as a fully managed service, whereas SQL Server on Azure Virtual Machines provides full feature parity with on-premises SQL Server instances.

Adım Adım Çözüm

1
Analyze the database requirements for the migration.
Identify that the database requires SQL Server Agent and cross-database queries.
Determining key technical dependencies is crucial for selecting the appropriate deployment tier.
2
Evaluate Azure SQL Database options (single database and elastic pool) against these requirements.
Rule them out as they do not natively support SQL Server Agent or cross-database queries.
Azure SQL Database focuses on hyper-scale single-database scenarios and lacks native support for several legacy instance-level features.
3
Evaluate Azure SQL Managed Instance and SQL Server on Azure VMs.
Confirm that both support SQL Server Agent and cross-database queries.
Azure SQL Managed Instance provides instance-level compatibility, and SQL Server on Azure VMs provides full SQL Server parity.

Anahtar Kavram

Identifying database compatibility requirements (such as SQL Server Agent and cross-database queries) to choose between Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Tahmini Süre:1m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru