Examkin

Question

Difficulty: MediumMigration Assessment and Strategy

A logistics company plans to migrate its custom order dispatch system to Azure. The system runs on several physical Windows and Linux servers. The database runs on a Microsoft SQL Server instance that requires cross-database queries and utilizes SQL Server Agent jobs. The company wants to implement a hybrid identity model for users to access the migrated system using their on-premises credentials. Security policies require that authentication credentials must be validated on-premises without deploying any federated identity infrastructure.

You need to recommend the components and targets for the migration assessment and strategy.

Which two recommendations should you include? (Choose two.)

  1. Migrate the database to Azure SQL Managed InstanceAnswer
  2. Configure Microsoft Entra Pass-through Authentication (PTA) with Seamless Single Sign-On (SSO)Answer
  3. C
    Migrate the database to an Azure SQL Database single database
  4. D
    Deploy Active Directory Federation Services (AD FS) to authenticate users on-premises
  5. E
    Group the application servers for migration without performing a dependency assessment

Answer

Migrate the database to Azure SQL Managed Instance and configure Microsoft Entra Pass-through Authentication (PTA) with Seamless Single Sign-On (SSO).
The correct recommendations are to migrate the database to Azure SQL Managed Instance and configure Microsoft Entra Pass-through Authentication (PTA) with Seamless Single Sign-On (SSO). Azure SQL Managed Instance supports instance-scoped features such as cross-database queries and SQL Server Agent, which are necessary for this workload. Pass-through Authentication meets the requirement to validate credentials against the on-premises Active Directory without the administrative overhead and complexity of federated identity infrastructure.

Step-by-Step Solution

1
Analyze the database requirements for SQL Server Agent and cross-database queries.
Determine that Azure SQL Managed Instance is the appropriate destination because Azure SQL Database single databases do not support instance-scoped features.
Matching legacy SQL Server feature requirements to the correct relational database deployment option ensures application compatibility after migration.
2
Evaluate the security and identity constraints requiring on-premises credential validation without federation.
Select Microsoft Entra Pass-through Authentication (PTA) with Seamless SSO.
PTA validates passwords directly against the on-premises Active Directory using lightweight local agents, avoiding the administrative overhead of Active Directory Federation Services (AD FS).
3
Evaluate assessment tasks to ensure workload functionality.
Determine that dependency mapping is required to avoid breaking relationships between servers.
Running dependency discovery with Azure Migrate is critical for identifying active network communication and grouping related servers correctly.

Key Concept

Selecting target database tiers and hybrid identity authentication methods based on legacy dependencies and security policies.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic