AZ-305 · Question #269
AZ-305 Question #269: Real Exam Question with Answer & Explanation
The correct answer is B: SQL Server on an Azure virtual machine. 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
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
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.