Which Azure tool can be used to assess compatibility of an on-premises SQL Server database before migrating to Azure SQL Database?

Azure Data Migration Assistant (DMA)

Which step is essential in an offline migration to ensure data integrity?

Stopping all writes to the source database before the migration

Using Azure Site Recovery to replicate the database

Keeping the application running during the entire migration

Setting up continuous replication between source and target

You administer an Azure SQL Managed Instance. You need to move a database from one managed instance to another managed instance in a different region. The move must be completed with minimal downtime. What should you do?

Use the Azure portal's 'Move' feature to move the database.

Use the Azure Database Migration Service to migrate between managed instances.

Export the database to a BACPAC and import it into the target instance.

Use the CREATE DATABASE ... AS COPY OF statement with the target instance as the source.

A healthcare company is migrating a mission-critical SQL Server database to Azure SQL Database using an online migration. The migration is in the continuous sync phase, and the application is still writing to the source. The team notices that the target database is lagging behind the source by several minutes. What should they do first?

Increase the source database compatibility level

Restart the migration from the beginning

Stop the application and perform a cutover immediately

Check the migration activity details for throttling or network issues

A company is migrating a 2-TB SQL Server database to Azure SQL Database. The migration must be completed within a 4-hour downtime window. The source database is in a datacenter with a 200 Mbps connection to Azure. The team has already taken a full backup. What should they do to ensure the migration completes within the window?

Use SQL Server Management Studio to generate scripts and run them on Azure

Use Azure Data Factory to copy the database

Use Azure Site Recovery to replicate the database

Use Azure Database Migration Service offline mode

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

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

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 21–25

21foundation · easy
Which Azure tool can be used to assess compatibility of an on-premises SQL Server database before migrating to Azure SQL Database?
Select an answer first
22foundation · easy
Which step is essential in an offline migration to ensure data integrity?
Select an answer first
23application · medium
You administer an Azure SQL Managed Instance. You need to move a database from one managed instance to another managed instance in a different region. The move must be completed with minimal downtime. What should you do?
Select an answer first
24application · medium
A healthcare company is migrating a mission-critical SQL Server database to Azure SQL Database using an online migration. The migration is in the continuous sync phase, and the application is still writing to the source. The team notices that the target database is lagging behind the source by several minutes. What should they do first?
Select an answer first
25application · medium
A company is migrating a 2-TB SQL Server database to Azure SQL Database. The migration must be completed within a 4-hour downtime window. The source database is in a datacenter with a 200 Mbps connection to Azure. The team has already taken a full backup. What should they do 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.

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

Questions 21–25

Which Azure tool can be used to assess compatibility of an on-premises SQL Server database before migrating to Azure SQL Database?

Which step is essential in an offline migration to ensure data integrity?

You administer an Azure SQL Managed Instance. You need to move a database from one managed instance to another managed instance in a different region. The move must be completed with minimal downtime. What should you do?

Keep studying — Plan and implement data platform resources