Exam DP-300 topic 1 question 55 discussion

Actual exam question from Microsoft's DP-300

Question #: 55
Topic #: 1

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.

You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.

What should you include in the recommendation?

A. Log Replay Service (LRS)
B. log shipping
C. transactional replication
D. SQL Data Sync

Show Suggested Answer

Suggested Answer: A 🗳️

by Surjit24 at July 13, 2023, 2:44 p.m.

Comments

Submit Cancel

bingomutant

8 months, 2 weeks ago

A - Log Replay Service is correct - Claude - While transactional replication is a solid, mature option, Log Replay Service (LRS) is becoming a popular choice for minimizing downtime and administrative effort when migrating large databases to Azure SQL Managed Instance, particularly when log-based migrations are desired. Since LRS is built specifically for this use case, it can indeed be the right choice for your scenario

upvoted 1 times

...

[Removed]

1 year, 7 months ago

A. Log Replay Service (LRS) Here's why LRS is suitable for your scenario: Log Replay Service: This service, also known as Azure Database Migration Service (DMS), supports online migrations with minimal downtime. It allows you to continuously replicate data (with active transaction log replay) from your on-premises SQL Server to an Azure SQL Managed Instance until you decide to perform the final cutover, thereby minimizing downtime.

upvoted 4 times

[Removed]

1 year, 7 months ago

B. Log shipping: While log shipping could be used for migration and would involve less administrative effort than some other methods, it typically incurs more downtime during the cutover to the new environment because it is not as seamless as LRS. C. Transactional replication: Transactional replication is generally used for keeping data synchronized across SQL Server instances. It is not designed for one-time database migrations and can be complex to set up for this purpose. D. SQL Data Sync: This service is used to synchronize data across multiple SQL databases and is not optimized for one-time migrations of large databases, as it can be slower and less reliable than LRS for this use case.

upvoted 3 times

...

Natali

10 months, 1 week ago

The answer is correct, however "Log Replay Service: This service, also known as Azure Database Migration Service (DMS), " this is not true, they are different tools

upvoted 1 times

...

zafara55

1 year, 10 months ago

Answer A. The Log Replay service LRS is only used with Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql-mi&tabs=sas-token

upvoted 4 times

...

jm2015

1 year, 10 months ago

Answer A. Less administrative effort compared to transactional replication https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql&tabs=sas-token

upvoted 3 times

...

Surjit24

1 year, 10 months ago

C seems right

upvoted 2 times

testdumps2017

1 year, 10 months ago

it is A, I've done this a couple of times.

upvoted 3 times

...