Microsoft Azure Architect Design (2020, legacy) — Question 44

You manage an application instance. The application consumes data from multiple databases. Application code references database tables using a combination of the server, database, and table name.
You need to migrate the application data to Azure.
To which two Azure services could you migrate the application to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Azure SQL Managed Instance
• B. Azure SQL Database
• C. SQL Server in an Azure virtual machine
• D. SQL Server Stretch Database

Correct answer: A, C

Explanation

Azure SQL Managed Instance and SQL Server in an Azure virtual machine can both support the required database configurations and applications that rely on specific server and table references. Azure SQL Database, while a viable option for cloud databases, may not fully support all SQL Server features necessary for this migration, and SQL Server Stretch Database is designed for different scenarios involving data tiering, not for direct application migrations.