Question

Difficulty: MediumMigration Assessment and Strategy

A retail company plans to migrate its legacy inventory management system from an on-premises datacenter to Azure. The system has the following components and requirements:

* Two database servers running SQL Server 2016 on physical hardware. The databases utilize SQL Server Agent jobs for nightly synchronization and perform cross-database queries.
* Four web servers running IIS on VMware ESXi virtual machines.
* An on-premises Active Directory Domain Services (AD DS) domain. The company wants to synchronize user identities to Microsoft Entra ID with minimal infrastructure overhead, and does not require federated authentication.

You need to design a migration assessment and target architecture strategy.

Which two actions should you include in the recommendation? (Choose two.)

  1. Recommend Azure SQL Managed Instance as the target migration tier for the SQL Server databases.Answer
  2. Configure agentless dependency analysis in Azure Migrate for the VMware ESXi virtual machines.Answer
  3. C
    Recommend Azure SQL Database single databases as the target migration tier for the SQL Server databases.
  4. D
    Deploy Active Directory Federation Services (AD FS) to establish hybrid identity authentication.
  5. E
    Group the virtual machines and schedule migrations based on server naming conventions without performing a dependency analysis.

Answer

Recommend Azure SQL Managed Instance as the target migration tier for the SQL Server databases, and configure agentless dependency analysis in Azure Migrate for the VMware ESXi virtual machines.
The correct recommendation includes choosing Azure SQL Managed Instance as the database target tier because it supports instance-level features like SQL Server Agent and cross-database queries, which are required by the legacy workload. Additionally, configuring agentless dependency analysis using Azure Migrate for the VMware ESXi VMs ensures that application network connections are mapped properly before migration without requiring agent installation overhead.

Step-by-Step Solution

1
Analyze the database requirements to determine the target tier.
The databases require SQL Server Agent and cross-database queries. Azure SQL Database single database does not support these, so Azure SQL Managed Instance must be selected.
Ensures application compatibility and minimizes code changes during migration.
2
Select the appropriate dependency mapping strategy.
Use Azure Migrate with agentless dependency analysis for the VMware ESXi web servers to identify application dependencies.
Allows mapping of server connections without operational overhead of installing agents, preventing broken links during migration.
3
Determine the identity synchronization mechanism.
Microsoft Entra Connect with Password Hash Synchronization (PHS) is sufficient, avoiding AD FS due to the requirement for minimal infrastructure overhead.
Meets the business constraint of lowest operational and infrastructure overhead.

Key Concept

Selecting target Azure relational database tiers based on feature compatibility (SQL Agent, cross-database queries) and planning migration dependencies with Azure Migrate.
Rate this question