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 7 Question 25 Discussion

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.You plan to migrate DB1 to an Azure SQL Database managed instance.What should you use to minimize downtime and data loss during the migration?D18912E1457D5D1DDCBD40AB3BF70D5D
A) distributed availability groups
B) database mirroring
C) log shipping
D) Database Migration Assistant

Microsoft DP-300 Exam - Topic 7 Question 25 Discussion

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

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.

You plan to migrate DB1 to an Azure SQL Database managed instance.

What should you use to minimize downtime and data loss during the migration?

D18912E1457D5D1DDCBD40AB3BF70D5D

Show Suggested Answer Hide Answer
Suggested Answer: A

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

Note: SQL Managed Instance supports the following database migration options (currently these are the only supported migration methods):

Azure Database Migration Service - migration with near-zero downtime.

Native RESTORE DATABASE FROM URL - uses native backups from SQL Server and requires some downtime.


https://docs.microsoft.com/en-us/sql/dma/dma-overview

by Loreta at May 07, 2022, 09:27 PM

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
Paris
10 months ago
Mirroring is outdated, I wouldn't recommend it for this migration.
upvoted 0 times
...
Casie
10 months ago
Wait, can you really use distributed availability groups for Azure SQL? Sounds tricky!
upvoted 0 times
...
Catherin
11 months ago
Database Migration Assistant is great for assessment, but not for minimizing downtime.
upvoted 0 times
...
Franchesca
11 months ago
I disagree, log shipping might be simpler for this size.
upvoted 0 times
...
Paris
11 months ago
I think distributed availability groups are the best option here.
upvoted 0 times
...
Brandee
11 months ago
Database mirroring sounds familiar, but I’m uncertain if it’s the right fit for migrating to Azure SQL Database. I need to double-check that.
upvoted 0 times
...
Winfred
11 months ago
I feel like distributed availability groups could be a good option, but I can't recall all the details about how they work in this context.
upvoted 0 times
...
Jacinta
11 months ago
I remember practicing with log shipping in a similar question, but it seems like it might not be the best choice for minimizing downtime during a migration.
upvoted 0 times
...
Florinda
11 months ago
I think we might need to consider the Database Migration Assistant for this one, but I'm not entirely sure if it minimizes downtime effectively.
upvoted 0 times
...
Josephine
11 months ago
Okay, I think I've got a good handle on this. The key is finding a solution that can handle the email volume and provide the necessary tracking capabilities.
upvoted 0 times
...
Dorinda
11 months ago
Hmm, I'm not entirely sure about this. I'll have to review the ASSUMETARGETDEFS documentation again.
upvoted 0 times
...

Save Cancel