A company is performing an online migration to Azure SQL Managed Instance. The migration has been running for hours, and the target is nearly caught up. The team needs to cut over during a 30-minute maintenance window. The source database has a high transaction rate. What should the team do to ensure a successful cutover?

Stop all writes to the source, wait for the target to catch up, and then perform the cutover

Increase the target service tier to speed up synchronization

Restart the migration to ensure a clean state

Perform the cutover immediately without stopping writes

A financial services company is migrating a 3-TB SQL Server 2019 database to Azure SQL Managed Instance. The migration must occur over a weekend with a 6-hour downtime window. The source database is in a different region and the network link is 500 Mbps. The team has already taken a full backup. What should they do to ensure the migration completes within the window?

Use the Azure portal to create a new database and then copy data manually

Perform a log-shipping setup and then switch over

Use Azure Database Migration Service offline mode with the existing full backup

Use Azure Data Factory to copy the backup file to Azure Blob Storage

Your company is migrating a 3-TB SQL Server database to Azure SQL Database. The migration must have near-zero downtime. The source database is used by a global application that cannot be offline. You need to select a migration approach that supports continuous availability. What should you use?

Use the SQL Server Import and Export Wizard.

Offline migration using the Azure Database Migration Service.

Backup and restore to Azure SQL Database.

Online migration using the Azure Database Migration Service.

What is a key consideration when migrating from Azure SQL Database to Azure SQL Managed Instance?

The requirement to use Azure Data Factory for the migration

The need to change the application connection strings to use a different port

Compatibility of features such as CLR and Service Broker

The need to use a different authentication method

You are performing an online migration from SQL Server to Azure SQL Database using DMS. The initial load completes, but the continuous sync is failing with a 'login' error. You need to resolve the issue so the migration can proceed. What should you do?

Recreate the login on the target Azure SQL Database with the same SID as the source.

Increase the service tier of the target database.

Restart the migration from the beginning.

Disable the firewall on the target Azure SQL Database.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

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

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 11–15

11expert · hard
A company is performing an online migration to Azure SQL Managed Instance. The migration has been running for hours, and the target is nearly caught up. The team needs to cut over during a 30-minute maintenance window. The source database has a high transaction rate. What should the team do to ensure a successful cutover?
Select an answer first
12application · medium
A financial services company is migrating a 3-TB SQL Server 2019 database to Azure SQL Managed Instance. The migration must occur over a weekend with a 6-hour downtime window. The source database is in a different region and the network link is 500 Mbps. The team has already taken a full backup. What should they do to ensure the migration completes within the window?
Select an answer first
13application · medium
Your company is migrating a 3-TB SQL Server database to Azure SQL Database. The migration must have near-zero downtime. The source database is used by a global application that cannot be offline. You need to select a migration approach that supports continuous availability. What should you use?
Select an answer first
14foundation · easy
What is a key consideration when migrating from Azure SQL Database to Azure SQL Managed Instance?
Select an answer first
15expert · medium
You are performing an online migration from SQL Server to Azure SQL Database using DMS. The initial load completes, but the continuous sync is failing with a 'login' error. You need to resolve the issue so the migration can proceed. What should you do?
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 3)

Questions 11–15

Your company is migrating a 3-TB SQL Server database to Azure SQL Database. The migration must have near-zero downtime. The source database is used by a global application that cannot be offline. You need to select a migration approach that supports continuous availability. What should you use?

What is a key consideration when migrating from Azure SQL Database to Azure SQL Managed Instance?

You are performing an online migration from SQL Server to Azure SQL Database using DMS. The initial load completes, but the continuous sync is failing with a 'login' error. You need to resolve the issue so the migration can proceed. What should you do?

Keep studying — Plan and implement data platform resources