Soru

Zorluk: OrtaMigration Assessment and Strategy

A company plans to migrate a legacy inventory application from their on-premises datacenter to Azure. The application consists of several physical Windows servers and a database tier running on SQL Server. The database tier relies on SQL Server Agent jobs for nightly processing and performs cross-database queries across two databases on the same server instance. The company's security policy strictly prohibits the installation of any monitoring agents or software on the production servers. Additionally, you must synchronize on-premises user identities to Microsoft Entra ID with minimal administrative effort and no extra on-premises infrastructure.

You need to design a migration assessment and target architecture strategy.

Which strategy should you recommend?

  1. Deploy the Azure Migrate appliance to perform agentless discovery and agentless dependency mapping, recommend Azure SQL Managed Instance as the target database tier, and use Microsoft Entra Connect with Password Hash Synchronization (PHS).Cevap
  2. B
    Deploy the Azure Migrate appliance to perform agentless discovery and agentless dependency mapping, recommend Azure SQL Database single databases as the target database tier, and use Microsoft Entra Connect with Password Hash Synchronization (PHS).
  3. C
    Plan the migration of the database tier directly to Azure SQL Managed Instance without performing a server dependency assessment, and use Microsoft Entra Connect with Password Hash Synchronization (PHS).
  4. D
    Deploy the Azure Migrate appliance to perform agentless discovery and agentless dependency mapping, recommend Azure SQL Managed Instance as the target database tier, and deploy Active Directory Federation Services (AD FS) for identity federation.

Cevap

Deploy the Azure Migrate appliance to perform agentless discovery and agentless dependency mapping, recommend Azure SQL Managed Instance as the target database tier, and use Microsoft Entra Connect with Password Hash Synchronization (PHS).
The correct strategy combines the Azure Migrate appliance for agentless discovery and dependency mapping, Azure SQL Managed Instance for SQL Server Agent and cross-database query support, and Password Hash Synchronization (PHS) for low-overhead identity synchronization. The Azure Migrate appliance uses credentials to perform agentless dependency mapping on physical servers, ensuring compliance with the policy of not installing agents. Azure SQL Managed Instance matches the legacy SQL Server features required. PHS synchronizes on-premises AD DS user accounts without requiring additional federation servers.

Adım Adım Çözüm

1
Evaluate the database tier requirements to determine the target Azure service.
Since the legacy SQL Server databases rely on SQL Server Agent jobs and cross-database queries, Azure SQL Managed Instance is identified as the correct target service because Azure SQL Database single database does not support these instance-scoped features.
Choosing the correct SQL deployment option ensures compatibility and avoids costly application refactoring.
2
Select the assessment and dependency mapping method based on organizational security policies.
Because security policies prohibit the installation of agents on production servers, agentless discovery and agentless dependency mapping via the Azure Migrate appliance must be selected.
This allows the collection of dependency data (such as network connections) using server credentials without deploying local agents on the target physical servers.
3
Determine the hybrid identity synchronization mechanism.
Password Hash Synchronization (PHS) is selected because it meets the requirement of minimal administrative effort and requires no additional on-premises servers.
Using Active Directory Federation Services (AD FS) would introduce unnecessary infrastructure complexity and administrative overhead.

Anahtar Kavram

Azure Migrate physical server assessment, SQL tier compatibility, and hybrid identity selection.
Bu soruyu puanla