A company is planning an online migration to Azure SQL Managed Instance. The source database is 8 TB and has a high transaction rate. The team is concerned about the initial load time and the impact on the source server. What should they do to minimize the impact on the source?

Perform the initial load using a backup taken during off-peak hours

Use Azure Data Factory to copy the data

Use a BACPAC file for the initial load

Increase the source server's resources during migration

During an online migration using Azure Database Migration Service, what is the purpose of the continuous sync phase?

To transfer the initial snapshot of the database

To replicate ongoing changes from the source to the target until cutover

To back up the source database to Azure Blob Storage

To validate the schema compatibility between source and target

During an online migration to Azure SQL Managed Instance, the migration fails with an error stating that the source database has a table without a primary key. The migration is using Azure Database Migration Service. What should the migration team do to resolve this issue?

Add a primary key to the table on the source database and restart the migration

Disable change tracking on the source database

Use an offline migration instead

Ignore the error and proceed with the cutover

Which condition is necessary for an online migration to be feasible?

The source database must be read-only during the migration

Continuous replication between the source and target must be possible

The source and target databases must be on the same version of SQL Server

The target database must be created before the migration starts

A company is migrating a 20-TB database to Azure SQL Managed Instance. The business can tolerate a 24-hour downtime window, but the network link is only 50 Mbps. The team has a full backup. What is the best way to ensure the migration completes within the window?

Use Azure ExpressRoute to increase bandwidth

Use Azure Database Migration Service offline mode over the network

Use an online migration to avoid the transfer bottleneck

Use Azure Data Box to ship the backup to Azure, then restore it

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

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

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 6–10

6expert · hard
A company is planning an online migration to Azure SQL Managed Instance. The source database is 8 TB and has a high transaction rate. The team is concerned about the initial load time and the impact on the source server. What should they do to minimize the impact on the source?
Select an answer first
7foundation · easy
During an online migration using Azure Database Migration Service, what is the purpose of the continuous sync phase?
Select an answer first
8application · medium
During an online migration to Azure SQL Managed Instance, the migration fails with an error stating that the source database has a table without a primary key. The migration is using Azure Database Migration Service. What should the migration team do to resolve this issue?
Select an answer first
9foundation · easy
Which condition is necessary for an online migration to be feasible?
Select an answer first
10expert · hard
A company is migrating a 20-TB database to Azure SQL Managed Instance. The business can tolerate a 24-hour downtime window, but the network link is only 50 Mbps. The team has a full backup. What is the best way to ensure the migration completes within the window?
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.