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

Questions 26–30

1. 26foundation · easy

   Which Azure service provides a fully managed platform for migrating SQL Server databases to Azure with minimal manual effort?

   • AAzure Data Factory
   • BAzure Database Migration Service
   • CAzure Kubernetes Service
   • DAzure Logic Apps
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   Which Azure service is designed to perform online migrations of SQL Server databases to Azure SQL Database with minimal downtime?

   • AAzure Data Factory
   • BAzure Import/Export Service
   • CAzure Site Recovery
   • DAzure Database Migration Service
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   You are migrating a 500-GB SQL Server database to Azure SQL Database using an online migration with the Azure Database Migration Service. The initial full load completes, but the continuous sync is failing with a 'schema mismatch' error. You need to resolve the issue so the migration can proceed. What should you do first?

   • AIncrease the service tier of the target database to improve performance.
   • BCompare the source and target schemas and update the target to match the source.
   • CDisable all foreign keys and triggers on the target database.
   • DRestart the migration from the beginning after dropping all objects in the target.
   Reveal Solution Discussion Select an answer first
5. 29expert · hard

   A company is migrating a 2-TB database from Azure SQL Managed Instance to Azure SQL Database. The application uses a feature that is only available in Azure SQL Managed Instance. The business requires minimal downtime and has a moderate budget. What is the best course of action?

   • AStay on Azure SQL Managed Instance and copy the database to a new instance
   • BMigrate to Azure SQL Database using online migration and ignore the unsupported feature
   • CRefactor the application to remove the unsupported feature, then migrate using BACPAC
   • DUse Azure SQL Database with a higher service tier to enable the feature
   Reveal Solution Discussion Select an answer first
6. 30expert · medium

   Your company is migrating a 2-TB SQL Server database to Azure SQL Database. The migration must be completed with minimal downtime. You plan to use DMS online mode. However, you discover that the source database has a table with a column that uses the SQL_VARIANT data type, which is not supported by Azure SQL Database. You need to ensure the migration succeeds. What should you do?

   • AUse a BACPAC export/import instead of DMS.
   • BModify the source table to use a supported data type before starting the migration.
   • CProceed with the migration and let DMS automatically convert the data type.
   • DUse Azure Data Factory to copy the data, bypassing the schema.
   Reveal Solution Discussion Select an answer first