Microsoft
AZ-305 · Question #269
You have an on-premises application that consumes data from multiple databases. The application code references database tables by using a combination of the server, database, and table name. You…
The correct answer is B. SQL Server on an Azure virtual machine D. Azure SQL Managed Instance. Cross-database queries are supported by SQL Server, for example on an Azure virtual machine, and also supported by an Azure SQL Managed Instance. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started- vertical?view=azuresql
Submitted by stefanr· Mar 6, 2026Design data storage solutions
Question
You have an on-premises application that consumes data from multiple databases. The application code references database tables by using a combination of the server, database, and table name. You need to migrate the application data to Azure. To which two services can you migrate the application data to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- ASQL Server Stretch Database
- BSQL Server on an Azure virtual machine
- CAzure SQL Database
- DAzure SQL Managed Instance
How the community answered
(23 responses)- A9% (2)
- B74% (17)
- C17% (4)
Explanation
Cross-database queries are supported by SQL Server, for example on an Azure virtual machine, and also supported by an Azure SQL Managed Instance. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started- vertical?view=azuresql
Community Discussion
No community discussion yet for this question.