MENU
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL 1 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?
Suggested Answer: D
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
VI
Viki
11 months ago
Definitely go with option D, it minimizes admin effort too!
HE
Helga
11 months ago
A single Azure SQL database won't cut it for this scenario.
NY
Nydia
12 months ago
Wait, can you really use linked servers with Azure SQL Database?
SH
Shalon
12 months ago
I agree, it supports all SQL Server features.
VA
Vallie
1 year ago
Azure SQL Managed Instance is the best choice for linked servers.
VA
Valentine
1 year ago
I’m leaning towards the elastic pool option, but I’m not confident it meets the linked server requirement. I need to double-check that.
NA
Natalie
1 year ago
I practiced a question like this, and I feel like SQL Server on Azure VMs could work, but it might require more administrative effort than we want.
JA
Jamika
1 year ago
I'm not entirely sure, but I remember something about Azure SQL Database not supporting linked servers, so that might rule out option A.
DA
Darci
1 year ago
I think Azure SQL Managed Instance might be the right choice since it supports linked servers and has a similar environment to on-premises SQL Server.
LA
Larue
1 year ago
I'm leaning towards option C on this one. The question states that the person who files the charge cannot remain anonymous, so I don't think it would be legal for Beth to have a lawyer file the charge for her to protect her identity.
HE
Herman
1 year ago
Hmm, this looks like a data flow diagram for Experience Fragments in AEM. I'll carefully compare the network components and data paths.