nerdexam
Microsoft

PL-600 · Question #164

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…

The correct answer is D. Upsert method E. Alternate key. 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 Use Alternate key - An alternate key is a unique identifier for a record that is…

Submitted by tunde_lagos· Apr 18, 2026Architect a solution

Question

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.

Options

  • AWebhook
  • BChange tracking
  • CDuplicate detection rules
  • DUpsert method
  • EAlternate key

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    4% (1)
  • D
    83% (20)

Explanation

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 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.

Topics

#Dataverse Integration#Data Synchronization#Alternate Keys#Upsert

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice