Examkin

Question

Difficulty: MediumMigration Assessment and Strategy

An organization is planning to migrate a legacy enterprise resource planning (ERP) application from an on-premises Hyper-V environment to Azure. The application consists of three web servers and two SQL Server database servers. The database tier relies on SQL Server Agent jobs and performs cross-database queries. The network connection dependencies between the web servers and external payment gateways are not documented. The organization wants to synchronize their on-premises Active Directory to Microsoft Entra ID with single sign-on (SSO) while minimizing administrative and infrastructure overhead.

Which assessment strategy and target architecture should you recommend?

  1. A
    Group the virtual machines based on on-premises host locations instead of performing dependency analysis, use Microsoft Entra Connect with Password Hash Synchronization (PHS) for identity, and migrate the databases to Azure SQL Managed Instance.
  2. B
    Perform agentless dependency analysis using Azure Migrate, use Microsoft Entra Connect with Password Hash Synchronization (PHS) for identity, and migrate the databases to Azure SQL Database single databases.
  3. Perform agentless dependency analysis using Azure Migrate, use Microsoft Entra Connect with Password Hash Synchronization (PHS) for identity, and migrate the databases to Azure SQL Managed Instance.Answer
  4. D
    Perform agentless dependency analysis using Azure Migrate, use Active Directory Federation Services (AD FS) for identity authentication, and migrate the databases to Azure SQL Managed Instance.

Answer

Perform agentless dependency analysis using Azure Migrate, use Microsoft Entra Connect with Password Hash Synchronization (PHS) for identity, and migrate the databases to Azure SQL Managed Instance.
The correct strategy utilizes Azure Migrate agentless dependency analysis to discover undocumented external connections, minimizing the risk of post-migration communication issues. Using Azure SQL Managed Instance preserves legacy SQL Server features like SQL Server Agent and cross-database queries with minimal refactoring. Finally, Microsoft Entra Connect with Password Hash Synchronization (PHS) satisfies the single sign-on requirement with the lowest possible administrative and infrastructure footprint.

Step-by-Step Solution

1
Analyze application requirements and technical constraints.
Identify the need for SQL Server Agent, cross-database queries, and undocumented network dependency discovery.
Ensures the selected target architecture supports all application dependencies.
2
Evaluate the migration assessment tool strategy.
Recommend Azure Migrate agentless dependency analysis.
Allows automatic discovery of connections between web servers and external payment gateways without installing agents on every virtual machine.
3
Select the target database platform and identity synchronization method.
Recommend Azure SQL Managed Instance and Microsoft Entra Connect with Password Hash Synchronization (PHS).
Managed Instance supports legacy SQL Server features, while PHS provides SSO with minimal administrative overhead.

Key Concept

Selecting target migration services and assessment strategies based on application features, database dependencies, and organizational constraints.
Estimated Time:2m 0s
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic