A small business is migrating a 50-GB SQL Server database to Azure SQL Database. The business can tolerate up to 4 hours of downtime. The migration must be completed over the weekend. The source database is not heavily used. Which migration strategy is most appropriate?

Online migration using the Azure Database Migration Service.

Use the Azure SQL Database auto-failover group to migrate.

Offline migration using backup and restore.

Transactional replication to Azure SQL Database.

You are using the Azure Database Migration Service for an online migration from SQL Server to Azure SQL Database. The migration has been running for several hours, and the initial load is complete. However, the continuous sync is failing with a 'duplicate key' error. You need to resolve the issue without causing downtime. What should you do?

Disable the primary key constraint on the target database.

Identify and remove duplicate rows from the source database.

Increase the service tier of the target database.

Restart the migration from the beginning.

A company is performing an offline migration of a 500-GB SQL Server database to Azure SQL Managed Instance. The migration uses Azure Database Migration Service. After the initial load, the team attempts to start the application but receives login errors. What is the most likely cause?

The target database is not in the same region

The database compatibility level is too low

The logins were not migrated to the target instance

The source database was not backed up in full recovery mode

What is the purpose of the CREATE DATABASE ... AS COPY OF command in Azure SQL Managed Instance?

To upgrade the database compatibility level

To create a read-only replica of the database

To move a database to a different managed instance

To create a new database that is a transactionally consistent copy of an existing database on the same instance

A retail company must migrate a 5-TB SQL Server database to Azure SQL Managed Instance with less than 15 minutes of downtime. The source database uses SQL Server authentication and has a high transaction rate. The migration must not require changes to the application connection strings. What should the migration team use?

Export and import using a BACPAC file

Azure Database Migration Service with online mode and a cutover at the end

Backup and restore with a maintenance window of 30 minutes

Transactional replication with the target as the publisher

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

Plan and Implement a Migration Strategy DP-300 Practice Questions (Page 1)

Part of the Plan and implement data platform resources domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 40 practice questions to prepare you well beyond it. (estimate)

40questions here

8free pages

9concepts

15–20%of the exam

Questions 1–5

1application · medium
A small business is migrating a 50-GB SQL Server database to Azure SQL Database. The business can tolerate up to 4 hours of downtime. The migration must be completed over the weekend. The source database is not heavily used. Which migration strategy is most appropriate?
Select an answer first
2expert · medium
You are using the Azure Database Migration Service for an online migration from SQL Server to Azure SQL Database. The migration has been running for several hours, and the initial load is complete. However, the continuous sync is failing with a 'duplicate key' error. You need to resolve the issue without causing downtime. What should you do?
Select an answer first
3application · medium
A company is performing an offline migration of a 500-GB SQL Server database to Azure SQL Managed Instance. The migration uses Azure Database Migration Service. After the initial load, the team attempts to start the application but receives login errors. What is the most likely cause?
Select an answer first
4foundation · easy
What is the purpose of the CREATE DATABASE ... AS COPY OF command in Azure SQL Managed Instance?
Select an answer first
5application · medium
A retail company must migrate a 5-TB SQL Server database to Azure SQL Managed Instance with less than 15 minutes of downtime. The source database uses SQL Server authentication and has a high transaction rate. The migration must not require changes to the application connection strings. What should the migration team use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Plan and Implement a Migration Strategy DP-300 Practice Questions (Page 1)

Questions 1–5

A small business is migrating a 50-GB SQL Server database to Azure SQL Database. The business can tolerate up to 4 hours of downtime. The migration must be completed over the weekend. The source database is not heavily used. Which migration strategy is most appropriate?

A company is performing an offline migration of a 500-GB SQL Server database to Azure SQL Managed Instance. The migration uses Azure Database Migration Service. After the initial load, the team attempts to start the application but receives login errors. What is the most likely cause?

What is the purpose of the CREATE DATABASE ... AS COPY OF command in Azure SQL Managed Instance?

Keep studying — Plan and implement data platform resources