ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam MB-400 All Questions

View all questions & answers for the MB-400 exam
Go to Exam

Exam MB-400 topic 7 question 3 discussion

Actual exam question from Microsoft's MB-400
Question #: 3
Topic #: 7
[All MB-400 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
An organization has an Azure SQL Database instance that must be synchronized daily with data from Dynamics 365 Sales. A large amount of data might need to be synchronized on some days.
You need to reduce the time required to synchronize data.
Solution:
✑ Write a SSIS package to connect to the source and target.
✑ Develop the SSIS package to find the records by the Modified on field.
✑ Create or update the records in the database instance based on results.
Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Instead enable change tracking for entities that will be synchronized, and use the Data Export Service to sync data between the database and Dynamics 365
Sales.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/enable-change-tracking-control-data-synchronization https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database
by Kainite at July 20, 2020, 4:35 p.m.

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
Submit Cancel
Pires
4 years, 5 months ago
correct
upvoted 2 times
...
Gdynam
4 years, 9 months ago
The "You need to reduce the time required to synchronize data." is pretty open for interpertation, when is the time reduced enough for it to be solution that meets the goal? This can be used for syncing data and you can control the interval. Question is not "are there better solutions out there?" So I would say A but can be wrong cause maybe it does not reduce the time enought to be a valid solution.
upvoted 2 times
Druey
4 years, 7 months ago
The fact that we SSIS you can control the interval is irrilevant. The question says "on some days". So maybe the synchronisation happens once a month, by SSIS or by the DES. I am not an expert, but considering this I doubt that SSIS is faster than a tailored for Azure SQL Server solution as DES. So I would say NO
upvoted 1 times
Baldus602
4 years, 4 months ago
In an integration scenario you should also delete records removed from the original system, if you only create and update the solution is not complete
upvoted 1 times
...
...
...
Kainite
4 years, 9 months ago
Correct - need to use https://blog.crgroup.com/dynamics-365-latest-feature-the-data-export-service/
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago