Examkin

Question

Difficulty: MediumMigration Assessment and Strategy

An organization plans to migrate an on-premises application suite to Azure. The workloads run on Hyper-V virtual machines (VMs). The application backend consists of a SQL Server instance that relies on SQL Server Agent jobs for daily maintenance tasks and requires cross-database queries. To plan the migration, you need to map network dependencies between the application and database VMs. The security team prohibits installing any new software, agents, or management utilities on the guest VMs during assessment, but they can provide local administrator credentials for guest OS analysis. Which combination of Azure SQL deployment option and Azure Migrate dependency mapping method should you recommend?

  1. Azure SQL Managed Instance for the database, and agentless dependency analysis using the Azure Migrate appliance.Answer
  2. B
    Azure SQL Database elastic pools for the database, and agentless dependency analysis using the Azure Migrate appliance.
  3. C
    Azure SQL Database single database for the database, and agent-based dependency analysis using Log Analytics and Dependency agents.
  4. D
    Azure SQL Managed Instance for the database, and agent-based dependency analysis using Log Analytics and Dependency agents.

Answer

Azure SQL Managed Instance for the database, and agentless dependency analysis using the Azure Migrate appliance.
The correct recommendation is Azure SQL Managed Instance combined with agentless dependency analysis. Azure SQL Managed Instance provides full SQL Server engine compatibility, supporting cross-database queries and SQL Server Agent jobs out of the box. For Hyper-V workloads, Azure Migrate agentless dependency mapping leverages the Azure Migrate appliance to connect to the VMs using local administrator credentials to gather dependency data without installing any management agents or software on the guest operating systems.

Step-by-Step Solution

1
Analyze the database requirements of the workload.
Identify that the database requires SQL Server Agent jobs and cross-database queries.
These features are supported in Azure SQL Managed Instance but are not supported in Azure SQL Database single database or elastic pools.
2
Analyze the security constraints and dependency mapping requirements.
Determine that dependency mapping must be executed without installing agents on the Hyper-V guest VMs.
Agentless dependency analysis using the Azure Migrate appliance uses guest OS credentials to run scripts and gather connection information, satisfying the constraint of not installing software on target VMs.
3
Combine the evaluations to select the optimal migration strategy.
Recommend Azure SQL Managed Instance combined with agentless dependency mapping.
This strategy satisfies the operational requirements of the database engine and respects the security limitations of the migration assessment phase.

Key Concept

Selecting the appropriate Azure SQL deployment option based on legacy features (SQL Server Agent and cross-database queries) and configuring agentless dependency analysis to satisfy guest VM security limitations.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic