Examkin

Soru

Zorluk: ZorRelational Data Storage Solutions

A financial services firm plans to migrate its core transactional and reporting database system to Microsoft Azure. The system consists of three databases that regularly perform cross-database transactions and query each other using standard three-part naming conventions. The application requires SQL Server Agent for automated scheduling, database mail services, and must be deployed with private IP addresses within a dedicated Azure Virtual Network. The firm has a primary operational driver to minimize the administrative overhead of managing the underlying operating system and database clustering for high availability. Which database solution should you recommend to meet these requirements?

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

Cevap

Azure SQL Managed Instance
Azure SQL Managed Instance is the correct choice because it provides near 100% compatibility with the on-premises SQL Server database engine. It natively supports instance-level features such as SQL Server Agent, Database Mail, and cross-database queries using three-part names. It also integrates natively into an Azure Virtual Network to provide private IP addresses. As a fully managed Platform as a Service (PaaS), it offloads the administrative overhead of managing the operating system, backups, updates, and high-availability configuration.

Adım Adım Çözüm

1
Analyze the migration compatibility and feature requirements.
The application requires SQL Server Agent, Database Mail, and cross-database queries using standard three-part names. This requires either SQL Server on Azure Virtual Machines or Azure SQL Managed Instance, as Azure SQL Database (single database or elastic pools) does not natively support these instance-scoped features.
Eliminate options that fail to support critical application capabilities.
2
Evaluate network isolation requirements.
The databases must be deployed with private IP addresses within a dedicated Azure Virtual Network. Both Azure SQL Managed Instance and SQL Server on Azure Virtual Machines natively support this configuration.
Ensure network security and routing policies are satisfied.
3
Apply the operational driver constraint to minimize administrative overhead.
SQL Server on Azure Virtual Machines is an IaaS service requiring the administrative management of OS patching, backups, and high availability clustering. Azure SQL Managed Instance is a fully managed PaaS service that automates these tasks, aligning with the primary goal.
Identify the solution that minimizes management overhead while meeting all technical requirements.

Anahtar Kavram

Selecting the appropriate Azure SQL relational database deployment option based on feature compatibility, networking requirements, and management overhead.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru