Microsoft Exam DP-200 Topic 4 Question 2 Discussion

Actual exam question for Microsoft's DP-200 exam

Question #: 2
Topic #: 4

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database.

You must perform an assessment of databases to determine whether data will move without compatibility issues.

You need to perform the assessment.

Which tool should you use?

AAzure SQL Data Sync

BSQL Vulnerability Assessment (VA)

CSQL Server Migration Assistant (SSMA)

DMicrosoft Assessment and Planning Toolkit

EData Migration Assistant (DMA)

Show Suggested Answer

Suggested Answer: E

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

References:

https://docs.microsoft.com/en-us/sql/dma/dma-overview

by Arminda at May 07, 2022, 12:30 AM

Limited Time Offer

25%

Off

Get Premium DP-200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!