Examkin

Question

Difficulty: HardMigration Assessment and Strategy

A manufacturing company is planning to migrate its on-premises supply chain management (SCM) system from a physical server environment to Azure. The SCM system consists of three physical servers: a database server running SQL Server 2016, an application server running a background Windows service, and a reporting server.

The SCM system has the following requirements and technical constraints:
* The database utilizes SQL Server Agent jobs for nightly inventory reconciliation, cross-database queries, and Service Broker.
* The application server requires sub-millisecond network latency to the database server.
* On-premises users must access the migrated application using single sign-on (SSO).
* The identity solution must minimize operational complexity and administrative overhead. The company's security policy permits storing password hashes in the cloud.

You need to design the migration assessment and target architecture.

Which recommendation meets the requirements?

  1. Assess dependencies by installing the Azure Migrate dependency agent on the physical servers. Migrate the SQL Server database to Azure SQL Managed Instance. Implement hybrid identity by configuring Microsoft Entra Connect with Password Hash Synchronization (PHS) and Seamless SSO.Answer
  2. B
    Assess dependencies by using the agentless discovery feature of Azure Migrate. Migrate the SQL Server database to Azure SQL Database. Implement hybrid identity by configuring Microsoft Entra Connect with Password Hash Synchronization (PHS) and Seamless SSO.
  3. C
    Migrate the SQL Server database to Azure SQL Managed Instance immediately without performing dependency analysis to accelerate the transition. Implement hybrid identity by deploying Active Directory Federation Services (AD FS) on Azure Virtual Machines to provide federated authentication.
  4. D
    Assess dependencies by installing the Azure Migrate dependency agent on the physical servers. Migrate the SQL Server database to Azure SQL Database. Implement hybrid identity by deploying Active Directory Federation Services (AD FS) on Azure Virtual Machines.

Answer

Assess dependencies by installing the Azure Migrate dependency agent on the physical servers. Migrate the SQL Server database to Azure SQL Managed Instance. Implement hybrid identity by configuring Microsoft Entra Connect with Password Hash Synchronization (PHS) and Seamless SSO.
The correct recommendation is to install the Azure Migrate dependency agent on the physical servers, migrate the database to Azure SQL Managed Instance, and configure Microsoft Entra Connect with Password Hash Synchronization (PHS) and Seamless SSO. Agent-based dependency mapping is required for physical servers to analyze network connections and ensure sub-millisecond latency dependencies are met. Azure SQL Managed Instance is the appropriate database target since it supports SQL Server Agent, cross-database queries, and Service Broker. PHS with Seamless SSO provides SSO functionality with the lowest operational complexity.

Step-by-Step Solution

1
Determine database migration target based on feature requirements.
Select Azure SQL Managed Instance.
The on-premises database utilizes SQL Server Agent, cross-database queries, and Service Broker, which are not supported in Azure SQL Database but are fully supported in Azure SQL Managed Instance.
2
Select the correct dependency assessment tool and method for physical servers.
Use Azure Migrate with agent-based dependency mapping.
Agent-based mapping is required for physical servers to discover network dependencies and ensure components requiring sub-millisecond latency are grouped appropriately. Agentless dependency analysis is not supported for physical servers.
3
Select hybrid identity synchronization method to meet SSO and complexity requirements.
Configure Microsoft Entra Connect with Password Hash Synchronization (PHS) and Seamless SSO.
This configuration provides a single sign-on experience for on-premises users while keeping administrative and infrastructure overhead to a minimum, as permitted by the security policy.

Key Concept

Designing migration strategies, database target selection, and identity synchronization for physical workloads.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic