Examkin

Soru

Zorluk: KolayRelational Data Storage Solutions

A company is planning to migrate a legacy inventory application to Azure. The application's database relies heavily on SQL Server Agent for automated job scheduling and requires cross-database queries between multiple databases on the same server instance. The company wants to minimize administrative overhead and avoid managing the underlying operating system. Which Azure SQL deployment option should you recommend?

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

Cevap

Azure SQL Managed Instance
Azure SQL Managed Instance provides near-100% feature compatibility with the SQL Server database engine, including support for SQL Server Agent and cross-database queries, while operating as a fully managed PaaS service that eliminates operating system management overhead.

Adım Adım Çözüm

1
Analyze the technical requirements of the database migration, focusing on feature compatibility.
The database requires native support for SQL Server Agent and cross-database queries.
These are instance-level features of SQL Server.
2
Analyze the administrative constraints for the target database service.
The target option must minimize administrative overhead and avoid operating system management.
This requirement indicates a Platform as a Service (PaaS) model rather than Infrastructure as a Service (IaaS).
3
Evaluate the Azure SQL deployment options to find the best fit.
Azure SQL Managed Instance satisfies the PaaS constraint and supports instance-level features like SQL Server Agent and cross-database queries.
It offers the management benefits of a fully managed database alongside the instance-level feature set required for migration.

Anahtar Kavram

Azure SQL deployment option selection based on feature compatibility and administrative overhead requirements
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru