Microsoft
DP-300 · Question #242
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements: - The…
The correct answer is D. Azure SQL Managed Instance. Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. They are not enabled in Azure SQL Database singleton and elastic pools. https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database…
Submitted by deeparc· Mar 6, 2026Plan and implement data platform resources
Question
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements: - The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. - Administrative effort must be minimized. What should you use to host the databases?
Options
- Aa single Azure SQL database
- Ban Azure SQL Database elastic pool
- CSQL Server on Azure Virtual Machines
- DAzure SQL Managed Instance
How the community answered
(31 responses)- A3% (1)
- B13% (4)
- C3% (1)
- D81% (25)
Explanation
Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. They are not enabled in Azure SQL Database singleton and elastic pools. https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database- engine?view=sql-server-2017
Topics
#linked servers#SQL Managed Instance#migration planning#feature compatibility
Community Discussion
No community discussion yet for this question.