Microsoft Exam DP-300 Topic 2 Question 84 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 84
Topic #: 2

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?

AAzure SQL Edge

BAzure SQL Database

CSQL Server on Azure Virtual Machines

DAzure SQL Managed instance

Show Suggested 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

7 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

8 months ago

I think Azure SQL Managed instance might be the best option for handling merge replication.

upvoted 0 times

...

Jessenia

8 months ago

Azure SQL Database is a fully managed service, but it may not support merge replication.

upvoted 0 times

...

Theodora

8 months ago

B) Azure SQL Database

upvoted 0 times

...

Brynn

8 months ago

D) Azure SQL Managed instance

upvoted 0 times

...

Lawana

8 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

...

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

...

Microsoft Exam DP-300 Topic 2 Question 84 Discussion

Contribute your Thoughts:

Hillary

Stevie

Kati

Hillary

Stevie

Rocco

Shawn

Basilia

Silva

Jordan

Crissy

Jaclyn

Isabelle

Jessenia

Theodora

Brynn

Lawana

Jerry

Mattie

Taryn