Exam PL-600 topic 2 question 40 discussion

Actual exam question from Microsoft's PL-600

Question #: 40
Topic #: 2

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

Suggested Answer: DE 🗳️

by python123 at April 16, 2023, 7:18 p.m.

Comments

Submit Cancel

Acrious

Highly Voted 11 months, 3 weeks 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, 1 month 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

...

Hamed64

Most Recent 1 week ago

Selected Answer: DE

Why not the others? A. Webhook: Used for event-driven integrations, not for preventing duplicates during data import. B. Change tracking: Helps with incremental data sync but doesn’t prevent duplicates by itself. C. Duplicate detection rules: These are more for manual or interactive scenarios, not ideal for automated sync processes.

upvoted 1 times

...