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 PL
Mob_nav_barsMENU

Microsoft Exam DP-300 Topic 2 Question 84 Discussion

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

You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Weldon at Feb 10, 2024, 12:05 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Hillary
11 months ago
That makes sense. Azure SQL Managed Instance is also a good option for a lift-and-shift migration.
upvoted 0 times
...
Stevie
11 months ago
That's true, but Azure SQL Database is a platform as a service offering with built-in high availability.
upvoted 0 times
...
Kati
11 months ago
I'm not sure, but I heard that SQL Server on Azure Virtual Machines could also be an option for migration.
upvoted 0 times
...
Hillary
11 months ago
I agree with Stevie. Azure SQL Database is a fully managed relational database service.
upvoted 0 times
...
Stevie
11 months ago
I think we should use Azure SQL Database for migrating the SQL Server 2019 database.
upvoted 0 times
...
Rocco
12 months ago
Actually, I think Azure SQL Managed Instance would be the best choice for easier migration and compatibility.
upvoted 0 times
...
Shawn
12 months ago
I agree with Basilia, SQL Server on Azure VMs would give us more flexibility.
upvoted 0 times
...
Basilia
1 years ago
But wouldn't SQL Server on Azure Virtual Machines be a better option for more control over the environment?
upvoted 0 times
...
Silva
1 years ago
I think we should use Azure SQL Database for migrating the database to Azure.
upvoted 0 times
...
Jordan
1 years ago
Ah, I see what you mean. Azure SQL Edge is probably not the right choice here since it's more for IoT scenarios, not enterprise-level database migrations.
upvoted 0 times
...
Crissy
1 years ago
But what about Azure SQL Database? Wouldn't that be a simpler option since it's a fully managed service? I'm not sure if it can handle the merge replication though.
upvoted 0 times
Jaclyn
1 years ago
True, Azure SQL Managed instance offers more control and compatibility with SQL Server features.
upvoted 0 times
...
Isabelle
1 years ago
I think Azure SQL Managed instance might be the best option for handling merge replication.
upvoted 0 times
...
Jessenia
1 years ago
Azure SQL Database is a fully managed service, but it may not support merge replication.
upvoted 0 times
...
Theodora
1 years ago
B) Azure SQL Database
upvoted 0 times
...
Brynn
1 years ago
D) Azure SQL Managed instance
upvoted 0 times
...
Lawana
1 years ago
C) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Jerry
1 years ago
A) Azure SQL Edge
upvoted 0 times
...
...
Mattie
1 years ago
You make a good point. Azure SQL Database is simpler, but I'm not sure if it supports merge replication. We'd need to do some more research on that.
upvoted 0 times
...
Taryn
1 years ago
This is a tricky question. We need to consider the replication requirements as well as the cloud hosting options. I'm leaning towards Azure SQL Managed Instance since it seems to be the most suitable for migrating an on-premises SQL Server with merge replication.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77