DP-200 Azure Data Integration and Migration

Question 1

Which Azure service is designed specifically to migrate on-premises databases to Azure with minimal downtime?

Accepted Answer

Azure Database Migration Service

Answer

Azure Database Migration Service (DMS) is purpose-built for migrating on-premises databases to Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VMs.

Question 2

Which tool should you run before migrating an on-premises SQL Server database to Azure SQL Database to identify compatibility issues?

Accepted Answer

Data Migration Assistant (DMA)

Answer

Data Migration Assistant (DMA) assesses SQL Server databases for compatibility issues and provides actionable recommendations before migration to Azure SQL Database.

Question 3

Which migration mode in Azure Database Migration Service keeps the source database operational throughout the migration process?

Accepted Answer

Online migration

Answer

Online migration uses continuous data synchronization so the source database remains available, minimizing downtime to a brief cutover window at the end.

Question 4

When migrating from MongoDB to Azure Cosmos DB for MongoDB API, which service provides managed migration with minimal downtime?

Accepted Answer

Azure Database Migration Service

Answer

Azure Database Migration Service supports online migration from MongoDB to Azure Cosmos DB for MongoDB API, handling continuous data sync until cutover.

Question 5

What is the primary function of the Copy Activity in Azure Data Factory?

Accepted Answer

To move data from a source data store to a destination data store

Answer

Copy Activity in Azure Data Factory is optimized for data movement, copying data from a supported source data store to a sink (destination) data store.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Integration and Migration