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

Exam PL-600 All Questions

View all questions & answers for the PL-600 exam
Go to Exam

Exam PL-600 topic 2 question 40 discussion

Actual exam question from Microsoft's PL-600
Question #: 40
Topic #: 2
[All PL-600 Questions]

You design integration with an external data source that uses sequential integer values as primary keys for the records contained in it. Data synchronization will occur in Microsoft Dataverse so users can access data.

Data within Microsoft Dataverse must be accurate against the data in the external data source.

You need to ensure that the data from the external data source does not create duplicated rows in Microsoft Dataverse.

Which two features should you use?

Each correct answer presents part of the solution.

  • A. Webhook
  • B. Change tracking
  • C. Duplicate detection rules
  • D. Upsert method
  • E. Alternate key
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by python123 at April 16, 2023, 7:18 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
MEG_Florida
Highly Voted 10 months ago
While I agree 100% that technically D & E would do that, C and E would be correct. Since you dont know if you are using c# code or anything else that can actually trigger an upsert, the only way to guarantee no dups is C and E
upvoted 7 times
...
CESBCN
Highly Voted 1 year ago
Selected Answer: DE
Use the Upsert method - The Upsert method can be used to insert new records or update existing records based on the primary key of the record. This ensures that records are not duplicated in Dataverse. Use Alternate key - An alternate key is a unique identifier for a record that is defined by the user and can be used instead of the primary key to avoid duplicates. By defining an alternate key on the entity in Dataverse that will be used to store the data from the external data source, the integration can use the alternate key to check for existing records and avoid creating duplicates.
upvoted 5 times
...
ntxtraining
Most Recent 8 months, 2 weeks ago
correct
upvoted 1 times
...
Parth91
11 months, 4 weeks ago
Selected Answer: DE
Correct answer is D & E
upvoted 5 times
...
xanr4711
1 year ago
Should be AlternateKey and Upsert. An AlernateKey is aleady unique, so you don't need Duplicate Detection
upvoted 2 times
dlnuser
1 year ago
I agree, it says each answer is part of the solution. Using Upsert + alternate keys is a good way to ensure there's no duplicates.
upvoted 3 times
Alehn96
6 months, 4 weeks ago
Agree https://learn.microsoft.com/en-us/power-apps/developer/data-platform/data-synchronization
upvoted 1 times
...
...
...
python123
1 year ago
it is correct
upvoted 4 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