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 DP-300 Exam - 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:

0/2000 characters
Submit Cancel
Sunny
4 months ago
SQL Server on Azure VMs is an option too, but more overhead.
upvoted 0 times
...
Shawn
4 months ago
Azure SQL Database won't cut it for merge replication.
upvoted 0 times
...
Fatima
4 months ago
Wait, can you really use Managed Instance for that?
upvoted 0 times
...
Gilbert
4 months ago
Definitely agree, it supports merge replication!
upvoted 0 times
...
Moon
5 months ago
I think Azure SQL Managed Instance is the best fit for this.
upvoted 0 times
...
Jacinta
5 months ago
I recall that Azure SQL Edge is more for IoT scenarios, so it definitely wouldn't be the right choice here.
upvoted 0 times
...
Hermila
5 months ago
I practiced a similar question about migrating databases, and I think the answer might be SQL Server on Azure VMs, but I'm not completely confident.
upvoted 0 times
...
Dong
5 months ago
I'm a bit unsure, but I feel like Azure SQL Managed Instance could be a good fit since it supports more SQL Server features.
upvoted 0 times
...
Trinidad
5 months ago
I think I remember that Azure SQL Database might not support all replication features, so I'm leaning towards SQL Server on Azure VMs.
upvoted 0 times
...
Henriette
5 months ago
Based on the details provided, I think Azure SQL Managed Instance might be the way to go. It's designed to be a fully managed SQL Server instance in the cloud, which could be a good fit for migrating an on-premises database with merge replication.
upvoted 0 times
...
Renea
5 months ago
I'm a bit confused here. Azure SQL Edge is mentioned as an option, but I'm not sure if that's the right choice for a full database migration. I'll need to review the capabilities of each Azure SQL service to determine the best fit.
upvoted 0 times
...
Devorah
5 months ago
Okay, let's see. Since the question mentions "migrate SQL1 to Azure", I'm guessing we need an Azure SQL service that can handle the migration from the on-premises SQL Server 2019 database. Azure SQL Database or SQL Server on Azure VMs might be good options.
upvoted 0 times
...
Alline
6 months ago
Hmm, this looks like a tricky one. I'll need to think carefully about the differences between the Azure SQL services and which one would be best for migrating an on-premises database with merge replication.
upvoted 0 times
...
Kate
6 months ago
Hmm, the options seem to be describing different types of protection, but I'm not sure which one is the correct "Service Protection" that the question is referring to. I'll need to think this through carefully.
upvoted 0 times
...
Shawnta
6 months ago
I'm a bit unsure about this one. The question mentions a web application, but also talks about users accessing it from different locations. I'm not sure if Horizon View is the right solution here, or if there's a better option for a web app.
upvoted 0 times
...
Gianna
6 months ago
Okay, this seems straightforward. I'm pretty confident that the correct answer is A - loading bays are vulnerable areas, so minimizing traffic there is important for security.
upvoted 0 times
...
Kirk
6 months ago
This question seems pretty straightforward. I'll focus on identifying the exceptions to the authorization requirement under HIPAA.
upvoted 0 times
...
Hillary
2 years ago
That makes sense. Azure SQL Managed Instance is also a good option for a lift-and-shift migration.
upvoted 0 times
...
Stevie
2 years ago
That's true, but Azure SQL Database is a platform as a service offering with built-in high availability.
upvoted 0 times
...
Kati
2 years 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
2 years ago
I agree with Stevie. Azure SQL Database is a fully managed relational database service.
upvoted 0 times
...
Stevie
2 years ago
I think we should use Azure SQL Database for migrating the SQL Server 2019 database.
upvoted 0 times
...
Rocco
2 years ago
Actually, I think Azure SQL Managed Instance would be the best choice for easier migration and compatibility.
upvoted 0 times
...
Shawn
2 years ago
I agree with Basilia, SQL Server on Azure VMs would give us more flexibility.
upvoted 0 times
...
Basilia
2 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
2 years ago
I think we should use Azure SQL Database for migrating the database to Azure.
upvoted 0 times
...
Jordan
2 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
2 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
2 years ago
True, Azure SQL Managed instance offers more control and compatibility with SQL Server features.
upvoted 0 times
...
Isabelle
2 years ago
I think Azure SQL Managed instance might be the best option for handling merge replication.
upvoted 0 times
...
Jessenia
2 years ago
Azure SQL Database is a fully managed service, but it may not support merge replication.
upvoted 0 times
...
Theodora
2 years ago
B) Azure SQL Database
upvoted 0 times
...
Brynn
2 years ago
D) Azure SQL Managed instance
upvoted 0 times
...
Lawana
2 years ago
C) SQL Server on Azure Virtual Machines
upvoted 0 times
...
Jerry
2 years ago
A) Azure SQL Edge
upvoted 0 times
...
...
Mattie
2 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
2 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