Cyber Monday 2024! 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
6 months ago
That makes sense. Azure SQL Managed Instance is also a good option for a lift-and-shift migration.
upvoted 0 times
...
Stevie
6 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
6 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
6 months ago
I agree with Stevie. Azure SQL Database is a fully managed relational database service.
upvoted 0 times
...
Stevie
6 months ago
I think we should use Azure SQL Database for migrating the SQL Server 2019 database.
upvoted 0 times
...
Rocco
7 months ago
Actually, I think Azure SQL Managed Instance would be the best choice for easier migration and compatibility.
upvoted 0 times
...
Shawn
7 months ago
I agree with Basilia, SQL Server on Azure VMs would give us more flexibility.
upvoted 0 times
...
Basilia
7 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
7 months ago
I think we should use Azure SQL Database for migrating the database to Azure.
upvoted 0 times
...
Jordan
8 months 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
8 months 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
7 months ago
True, Azure SQL Managed instance offers more control and compatibility with SQL Server features.
upvoted 0 times
...
Isabelle
7 months ago
I think Azure SQL Managed instance might be the best option for handling merge replication.
upvoted 0 times
...
Jessenia
7 months ago
Azure SQL Database is a fully managed service, but it may not support merge replication.
upvoted 0 times
...
Theodora
7 months ago
B) Azure SQL Database
upvoted 0 times
...
Brynn
7 months ago
D) Azure SQL Managed instance
upvoted 0 times
...
Lawana
7 months ago
C) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Jerry
8 months ago
A) Azure SQL Edge
upvoted 0 times
...
...
Mattie
8 months 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
8 months 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