exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 12 discussion

Actual exam question from Microsoft's DP-200
Question #: 12
Topic #: 1
[All DP-200 Questions]

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?

  • A. SQL Server Migration Assistant (SSMA)
  • B. Microsoft Assessment and Planning Toolkit
  • C. SQL Vulnerability Assessment (VA)
  • D. Azure SQL Data Sync
  • E. Data Migration Assistant (DMA)
Show Suggested Answer Hide 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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Debjit
Highly Voted 4 years, 7 months ago
Correct answer is DMA. Data Migration Assistant is a client-side tool that you can install on a Windows-compatible workstation or server. It has two major functions in the migration of the social database to the Azure SQL Database platform in this module. First, it assesses your existing database and identifies any incompatibilities between that database and Azure SQL Database. It then generates a report of the things you need to fix before you can migrate. As you make changes, you can rerun Data Migration Assistant to generate an updated report of changes that you need to make. This capability helps you to not only track your progress, but also catch any new issues that might have been introduced during your coding phase. Refrence: https://docs.microsoft.com/en-us/learn/modules/migrate-sql-server-relational-data/3-migration-overview
upvoted 24 times
memo43
3 years, 12 months ago
keyword is >> Assessment of db
upvoted 1 times
...
...
deepz8
Most Recent 4 years, 1 month ago
DMA is the correct answer. It is used for compatibility check prior to migration.
upvoted 3 times
...
JESUSBB
4 years, 2 months ago
Answer E Data Migration Assistant.
upvoted 1 times
...
Needium
4 years, 4 months ago
The correct answer is definitely the chosen answer E. The question is about assessement not the actual migration and/or synchronization. Azure Data Sync (E) addresses the actual migration and synchronization; however, the question is about assessment before migration
upvoted 2 times
...
syu31svc
4 years, 5 months ago
From link https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15: Assess on-premises SQL Server instance(s) migrating to Azure SQL database(s). The assessment workflow helps you to detect the following issues that can affect Azure SQL database migration and provides detailed guidance on how to resolve them.
upvoted 2 times
...
Egocentric
4 years, 5 months ago
"perform an assessment" is the keyword here not sync . Data Migration Assistant is the correct one
upvoted 2 times
...
abhinavkj
4 years, 9 months ago
I also feel it should be Azure Data Sync
upvoted 2 times
r8d1
4 years, 9 months ago
i think the question is about first migrating data, so we need to address this issue first. The sync comes later.
upvoted 6 times
...
...
SebK
4 years, 10 months ago
Should not be D: Azure Data Sync as it is said to synchronize data ? Data Migration Assistant should be used to migrate data from on-premise to Azure.
upvoted 2 times
cutebird
4 years, 10 months ago
It is mentioned that "perform an assessment of databases to determine whether data will move without compatibility issues".So E is correct Ref:https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15
upvoted 12 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago