Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 11 Question 65 Discussion

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?
D) Azure SQL Managed Instance
A) a single Azure SQL database
B) an Azure SQL Database elastic pool
C) SQL Server on Azure Virtual Machines

Microsoft DP-300 Exam - Topic 11 Question 65 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 65
Topic #: 11
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Van at Dec 06, 2022, 10:17 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Viki
10 months ago
Definitely go with option D, it minimizes admin effort too!
upvoted 0 times
...
Helga
10 months ago
A single Azure SQL database won't cut it for this scenario.
upvoted 0 times
...
Nydia
10 months ago
Wait, can you really use linked servers with Azure SQL Database?
upvoted 0 times
...
Shalon
10 months ago
I agree, it supports all SQL Server features.
upvoted 0 times
...
Vallie
10 months ago
Azure SQL Managed Instance is the best choice for linked servers.
upvoted 0 times
...
Valentine
11 months 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.
upvoted 0 times
...
Natalie
11 months 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.
upvoted 0 times
...
Jamika
11 months 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.
upvoted 0 times
...
Darci
11 months 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.
upvoted 0 times
...
Larue
11 months 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.
upvoted 0 times
...
Herman
11 months ago
Hmm, this looks like a data flow diagram for Experience Fragments in AEM. I'll carefully compare the network components and data paths.
upvoted 0 times
...

Save Cancel