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 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
10 months ago
That makes sense. Azure SQL Managed Instance is also a good option for a lift-and-shift migration.
upvoted 0 times
...
Stevie
10 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
10 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
11 months ago
Actually, I think Azure SQL Managed Instance would be the best choice for easier migration and compatibility.
upvoted 0 times
...
Shawn
11 months ago
I agree with Basilia, SQL Server on Azure VMs would give us more flexibility.
upvoted 0 times
...
Basilia
12 months ago
But wouldn't SQL Server on Azure Virtual Machines be a better option for more control over the environment?
upvoted 0 times
...
Silva
12 months 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
12 months ago
True, Azure SQL Managed instance offers more control and compatibility with SQL Server features.
upvoted 0 times
...
Isabelle
12 months ago
I think Azure SQL Managed instance might be the best option for handling merge replication.
upvoted 0 times
...
Jessenia
12 months ago
Azure SQL Database is a fully managed service, but it may not support merge replication.
upvoted 0 times
...
Theodora
12 months ago
B) Azure SQL Database
upvoted 0 times
...
Brynn
12 months ago
D) Azure SQL Managed instance
upvoted 0 times
...
Lawana
12 months 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