ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 1 question 46 discussion

Actual exam question from Microsoft's DP-300
Question #: 46
Topic #: 1
[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 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?

  • A. a single Azure SQL database
  • B. SQL Server on Azure Virtual Machines
  • C. Azure SQL Managed Instance
  • D. an Azure SQL Database elastic pool
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Pranava_GCP at April 21, 2023, 6:42 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pranava_GCP
Highly Voted 2 years, 1 month ago
Selected Answer: C
C is correct, 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-engine?view=sql-server-2017
upvoted 7 times
...
Davidjsanchez
Most Recent 7 months, 1 week ago
managed instance
upvoted 1 times
...
bingomutant
8 months, 2 weeks ago
Agree C is obvious and other answers are not suitable for reasons stated by others
upvoted 1 times
...
yyc585
1 year, 5 months ago
Selected Answer: C
1. Linked servers are NOT available in Azure SQL Database. 2. Also Less Administration.
upvoted 1 times
...
adz07
1 year, 9 months ago
i think C is correct because Administrative effort must be minimized.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel