A company is planning to migrate its on-premises SQL Server databases to Azure SQL Database. During the requirements evaluation phase, which two categories of requirements must be assessed to define the migration strategy?

Only the licensing costs and the choice of cloud provider

The number of database administrators and the physical server location

Technical requirements (such as database size, compatibility level, and network latency) and business requirements (such as downtime tolerance and budget)

Only the database size and the number of concurrent users

A company is migrating a 1-TB database from Azure SQL Managed Instance to Azure SQL Database. The application requires a specific compatibility level that is supported by both services. The migration must minimize downtime, but the company has a limited budget and cannot afford a long-running online migration. What is the best approach?

Use the COPY_MOVE command in Azure SQL Managed Instance

Use Azure Database Migration Service online mode

Use a BACPAC export and import during a planned maintenance window

Take a native backup and restore it to Azure SQL Database

Which scenario is best suited for an offline database migration strategy?

The source and target databases must be synchronized in real time

The application must remain available with zero downtime during the migration

The database is very large and the network bandwidth is limited

The application can tolerate a few hours of downtime during the migration window

A manufacturing company is migrating a 10-TB data warehouse to Azure SQL Database. The business has approved a 12-hour downtime window over the weekend. The network link to Azure is 100 Mbps. What is the most important consideration when planning the offline migration?

The number of tables in the database

The compatibility level of the source database

The authentication method used by the source database

The time required to transfer the backup over the network

What is the primary benefit of an online migration strategy compared to an offline migration?

It is always faster than offline migration

It does not require any network connectivity between source and target

It allows the source database to remain operational during the migration, minimizing downtime

It eliminates the need for any database schema changes

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 3

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

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 31–35

31foundation · easy
A company is planning to migrate its on-premises SQL Server databases to Azure SQL Database. During the requirements evaluation phase, which two categories of requirements must be assessed to define the migration strategy?
Select an answer first
32expert · hard
A company is migrating a 1-TB database from Azure SQL Managed Instance to Azure SQL Database. The application requires a specific compatibility level that is supported by both services. The migration must minimize downtime, but the company has a limited budget and cannot afford a long-running online migration. What is the best approach?
Select an answer first
33foundation · easy
Which scenario is best suited for an offline database migration strategy?
Select an answer first
34application · medium
A manufacturing company is migrating a 10-TB data warehouse to Azure SQL Database. The business has approved a 12-hour downtime window over the weekend. The network link to Azure is 100 Mbps. What is the most important consideration when planning the offline migration?
Select an answer first
35foundation · easy
What is the primary benefit of an online migration strategy compared to an offline migration?
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.