A company is migrating a 5-TB SQL Server database to Azure SQL Database. The business requires minimal downtime but has a limited budget. The source database has a high transaction rate and uses several features not supported in Azure SQL Database. What should the migration team do first?

Run the Data Migration Assistant to assess compatibility

Migrate to Azure SQL Managed Instance instead

Start an online migration with Azure Database Migration Service

Choose an offline migration to avoid downtime

A company currently runs a 500-GB database on Azure SQL Managed Instance and wants to move it to Azure SQL Database in the same region. The application can tolerate a few hours of downtime. What is the most efficient way to perform this migration?

Use Azure Database Migration Service with online mode

Use the COPY_MOVE option in Azure SQL Managed Instance

Export the database to a BACPAC file and import it into Azure SQL Database

Take a native backup and restore it to Azure SQL Database

Which common issue might cause a migration to fail with a 'login failed' error?

The target service tier is too low

The network latency is too high

The source database is too large

The login used for migration does not have sufficient permissions on the target database

When migrating a database from Azure SQL Database to Azure SQL Managed Instance, which tool can be used?

SQL Server Management Studio (SSMS) with Import/Export Wizard

Azure Database Migration Service

Your company is migrating a 2-TB SQL Server 2016 database to Azure SQL Database. The business can tolerate no more than 15 minutes of downtime, and the migration must be completed within a 48-hour window. The source database is actively used by a line-of-business application. You need to select a migration approach that meets the downtime requirement. What should you choose?

Perform an online migration using the Database Migration Service (DMS) with continuous sync.

Use the Azure SQL Database copy feature to create a copy of the source database.

Export the database to a BACPAC file and import it into Azure SQL Database.

Perform an offline migration using the Database Migration Service (DMS) with a backup and restore.

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

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

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 16–20

16expert · hard
A company is migrating a 5-TB SQL Server database to Azure SQL Database. The business requires minimal downtime but has a limited budget. The source database has a high transaction rate and uses several features not supported in Azure SQL Database. What should the migration team do first?
Select an answer first
17application · medium
A company currently runs a 500-GB database on Azure SQL Managed Instance and wants to move it to Azure SQL Database in the same region. The application can tolerate a few hours of downtime. What is the most efficient way to perform this migration?
Select an answer first
18foundation · easy
Which common issue might cause a migration to fail with a 'login failed' error?
Select an answer first
19foundation · easy
When migrating a database from Azure SQL Database to Azure SQL Managed Instance, which tool can be used?
Select an answer first
20application · medium
Your company is migrating a 2-TB SQL Server 2016 database to Azure SQL Database. The business can tolerate no more than 15 minutes of downtime, and the migration must be completed within a 48-hour window. The source database is actively used by a line-of-business application. You need to select a migration approach that meets the downtime requirement. What should you choose?
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.