Examkin

Question

Difficulty: HardMigration Assessment and Strategy

A financial services company is planning the migration of its portfolio management system from an on-premises VMware vSphere environment to Azure. The system consists of three web servers, four application servers, and a backend SQL Server 2019 instance. The SQL Server instance hosts three databases that perform cross-database queries and run several SQL Server Agent jobs. The application servers connect to external financial data feeds over non-standard TCP ports, but the port numbers and destinations are undocumented.

You need to recommend a migration assessment and target architecture design that minimizes operational effort and ensures application dependencies are fully mapped before migration.

Which combination of Azure Migrate dependency analysis and Azure SQL deployment option should you recommend?

  1. Azure Migrate agentless dependency analysis for the virtual machines, and Azure SQL Managed Instance for the database tier.Answer
  2. B
    Azure Migrate agent-based dependency analysis for the virtual machines, and Azure SQL Managed Instance for the database tier.
  3. C
    Azure Migrate agentless dependency analysis for the virtual machines, and Azure SQL Database Elastic Pools for the database tier.
  4. D
    Azure Migrate agent-based dependency analysis for the virtual machines, and Azure SQL Database single database with elastic queries for the database tier.

Answer

Azure Migrate agentless dependency analysis for the virtual machines, and Azure SQL Managed Instance for the database tier.
The correct recommendation is agentless dependency analysis for the VMware VMs combined with Azure SQL Managed Instance for the databases. Agentless dependency analysis allows mapping TCP connections directly through the Azure Migrate appliance without deploying software agents to the guest operating systems, meeting the requirement to minimize operational overhead. Azure SQL Managed Instance natively supports SQL Server Agent jobs and cross-database queries, which are critical requirements for the backend database tier.

Step-by-Step Solution

1
Analyze database requirements
Identified requirements for cross-database queries and SQL Server Agent jobs.
These are instance-level SQL Server features not supported by default in Azure SQL Database, pointing to Azure SQL Managed Instance as the correct target.
2
Analyze dependency assessment requirements
Identified the need to map undocumented TCP connections while minimizing operational effort on VMware VMs.
Azure Migrate agentless dependency analysis allows connection mapping without installing guest agents, matching the operational efficiency goal.
3
Combine the optimal components
Select agentless dependency analysis paired with Azure SQL Managed Instance.
This combination successfully meets all application requirements and administrative constraints.

Key Concept

Selecting appropriate database migration targets and dependency assessment methods based on features and operational constraints.
Rate this question

Topics

Migration Assessment and Strategy

More questions from this topic