Examkin

Question

Difficulty: HardMigration Assessment and Strategy

An organization plans to migrate an on-premises payroll application hosted on VMware vSphere. The application comprises three web servers and a backend database server running SQL Server 2016. The database uses SQL Server Agent for scheduled maintenance and performs cross-database queries. Users authenticate via an on-premises Active Directory Domain Services (AD DS) domain. The application interacts with external services, but the specific network connections are undocumented.

You need to design a migration assessment and transition strategy that meets the following requirements:
- Identify all application network dependencies before migration to prevent service disruptions.
- Minimize administrative overhead and infrastructure complexity for both the database tier and identity synchronization.
- Maintain support for the legacy database features.

Which migration strategy should you recommend?

  1. A
    Establish migration groups based on server names without performing dependency mapping; migrate the database to Azure SQL Managed Instance; and implement Microsoft Entra Connect with Password Hash Synchronization (PHS).
  2. B
    Perform agentless dependency analysis using Azure Migrate; migrate the database to Azure SQL Database; and implement Microsoft Entra Connect with Password Hash Synchronization (PHS).
  3. Perform agentless dependency analysis using Azure Migrate; migrate the database to Azure SQL Managed Instance; and implement Microsoft Entra Connect with Password Hash Synchronization (PHS).Answer
  4. D
    Perform agentless dependency analysis using Azure Migrate; migrate the database to Azure SQL Managed Instance; and implement Microsoft Entra Connect with Active Directory Federation Services (AD FS).

Answer

Perform agentless dependency analysis using Azure Migrate; migrate the database to Azure SQL Managed Instance; and implement Microsoft Entra Connect with Password Hash Synchronization (PHS).
The correct strategy uses agentless dependency analysis to map undocumented connections prior to migration. It deploys Azure SQL Managed Instance to preserve legacy features like SQL Server Agent and cross-database queries. It also configures Password Hash Synchronization (PHS) to keep the identity model simple and low-overhead.

Step-by-Step Solution

1
Determine dependency assessment requirements.
Since the network connections to external services are undocumented, performing dependency analysis is required to prevent post-migration connection failures.
This satisfies the requirement to identify all application dependencies before migration.
2
Evaluate the database tier compatible with SQL Server Agent and cross-database queries.
Azure SQL Managed Instance is chosen because it offers near-complete compatibility with SQL Server, supporting SQL Server Agent and cross-database queries natively.
Azure SQL Database single database does not support these features natively.
3
Evaluate hybrid identity options based on administrative and infrastructure overhead.
Password Hash Synchronization (PHS) is selected as it meets the synchronization requirement while requiring the least on-premises infrastructure and administrative effort.
Active Directory Federation Services (AD FS) requires deploying and maintaining federation servers and web application proxies, increasing complexity without a stated business justification.

Key Concept

Selecting target service tiers and assessment methods based on dependency requirements, database compatibility, and overhead constraints.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic