Examkin

Question

Difficulty: MediumMigration Assessment and Strategy

A company plans to migrate a line-of-business (LOB) application from an on-premises Hyper-V environment to Azure. The application consists of three web servers running on Windows Server virtual machines and a database backend running on SQL Server 2022. The database backend requires SQL Server Agent jobs to schedule nightly maintenance and cross-database queries to pull data from a separate legacy HR database. The on-premises environment uses Active Directory Domain Services (AD DS) for authentication. The hybrid identity solution only requires user authentication without federated authentication. You need to design the migration assessment and target architecture while minimizing administrative overhead, complexity, and the risk of service disruption. Which two actions should you recommend? (Choose two)

  1. A
    Target Azure SQL Database (single database) for the database backend migration.
  2. B
    Deploy Active Directory Federation Services (AD FS) on-premises and in Azure to federate identity with Microsoft Entra ID.
  3. C
    Proceed with migration planning without performing dependency analysis to minimize the duration of the assessment phase.
  4. Configure Azure Migrate to perform dependency analysis for the on-premises virtual machines.Answer
  5. Target Azure SQL Managed Instance for the database backend migration.Answer

Answer

To successfully migrate the workload while meeting all technical requirements and minimizing overhead, you must configure Azure Migrate to perform dependency analysis for the on-premises virtual machines and target Azure SQL Managed Instance for the database backend.
The correct recommendations are to configure Azure Migrate to perform dependency analysis for the on-premises virtual machines and to target Azure SQL Managed Instance for the database backend. Dependency analysis is critical to map out network communication dependencies between servers, ensuring that the migration does not break connections to other on-premises systems like the legacy HR database. Azure SQL Managed Instance is the most appropriate database tier because it supports required legacy SQL Server features, such as SQL Server Agent and cross-database queries, while providing a fully managed service that minimizes administrative overhead.

Step-by-Step Solution

1
Analyze database requirements.
Identify the need for SQL Server Agent and cross-database queries.
These requirements eliminate Azure SQL Database (single database) from consideration since it does not support these features.
2
Analyze identity and migration dependency requirements.
Identify the need to map connections to the legacy HR database and establish simple user authentication.
A dependency analysis is required to prevent broken connections, and Active Directory Federation Services (AD FS) should be avoided to prevent unnecessary complexity since federation is not required.
3
Select the migration tools and target tiers.
Select Azure SQL Managed Instance for the database and Azure Migrate dependency analysis for the virtual machines.
Azure SQL Managed Instance provides the necessary SQL Server compatibility with managed service benefits, and Azure Migrate dependency analysis ensures all service connections are discovered.

Key Concept

Selecting appropriate database migration targets and planning dependency assessments to ensure application compatibility and connectivity during Azure migrations.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic