PL-900 Practice Question: Demonstrate the capabilities of Power Automate
Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.
Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because the 'Compose' action is used to create variables and does not check for duplicates. Option C is wrong because using 'Update a record' requires an existing record; it does not prevent creation of duplicates. Option D is wrong because using 'Delete a record' before creating a new one is not a standard method to handle duplicate detection and may cause data loss.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.
Why this is correct
Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates.
- ✗
Use the 'Compose' action to check for duplicates before creation.
Why it's wrong here
The 'Compose' action does not create records; it only outputs a value and cannot check for duplicates in the target system.
- ✗
Use the 'Update a record' action instead of 'Create a new record' to update existing records.
Why it's wrong here
Using 'Update a record' requires an existing record ID and is not designed to prevent duplicates; it only updates a known record.
- ✗
Use the 'Delete a record' action before creating a new one.
Why it's wrong here
'Delete a record' does not prevent duplicates; it deletes an existing record but does not handle duplicate detection before creation.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 904 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.