DP-300 Certification Practice Question #35

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?

Accepted Answer

The requirement is dual: (1) support linked server connections to SQL2, and (2) minimize administrative effort. Only Azure SQL Managed Instance and SQL Server on VM support linked servers. Between those two, Azure SQL Managed Instance is a fully managed PaaS service requiring far less administrative overhead than managing a SQL Server VM. All 8 community votes and the suggested answer unanimously agree on C.

More DP-300 practice questions