Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A company is planning to migrate a legacy on-premises SQL Server application to Azure. The application has the following database requirements:

* Must run scheduled maintenance jobs using SQL Server Agent.
* Requires database-level integration with the Common Language Runtime (CLR).
* Must restrict all database network traffic to a private virtual network.
* Must minimize database administration effort, including operating system updates and database engine patching.

Which two components should you include in the relational database solution design?

  1. Azure SQL Managed InstanceCevap
  2. A delegated subnet in an Azure Virtual NetworkCevap
  3. C
    Azure SQL Database elastic pool
  4. D
    SQL Server on Azure Virtual Machines
  5. E
    Azure SQL Database serverless tier

Cevap

Azure SQL Managed Instance and a delegated subnet in an Azure Virtual Network
Azure SQL Managed Instance is the recommended deployment option because it supports SQL Server Agent and CLR integration while operating as a fully managed PaaS service that automates database patching and operating system updates. To deploy Azure SQL Managed Instance, you must place it within a delegated subnet in an Azure Virtual Network, which satisfies the requirement for private network isolation.

Adım Adım Çözüm

1
Analyze compatibility requirements
SQL Server Agent and CLR integration are legacy features supported by Azure SQL Managed Instance and SQL Server on Azure Virtual Machines, but not by Azure SQL Database (single database or elastic pools).
This narrows down the database deployment options based on feature requirements.
2
Evaluate administrative overhead requirements
Azure SQL Managed Instance is a PaaS option that automates OS updates and database engine patching. SQL Server on Azure Virtual Machines is IaaS and requires manual patching.
This filters out the virtual machine option to satisfy the administrative minimization requirement.
3
Determine network integration requirements
Azure SQL Managed Instance is deployed natively into a delegated subnet within an Azure Virtual Network to secure traffic privately.
This identifies the required networking component for the chosen database tier.

Anahtar Kavram

Selecting and configuring the correct Azure SQL deployment tier based on legacy feature support, network requirements, and administrative overhead.

Alternatif Yöntem

Instead of migrating to Azure SQL Managed Instance, a hybrid migration using Azure Data Factory could be used to orchestrate data movement, but Managed Instance remains the primary database target satisfying the legacy requirements directly.
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru