Power Platform Functional Consultant

Sample PL-200 practice questions

5 of the 61 original questions in our PL-200 bank, written to match the real exam's style and difficulty. Every question includes a full explanation — expand each answer to check your reasoning.

1. Question 1medium

   You need to ensure that when a parent Account record is deleted, all related Contact records are also deleted automatically. What should you configure?

   • AA business rule on the Contact table
   • BThe cascade behavior on the Account-to-Contact relationship
   • CA calculated column on the Account table
   • DA security role restriction
   Show answer & explanation

   Correct: B

   Relationship behavior (cascade rules) controls what happens to related rows when an action occurs on the parent. Setting the delete behavior to "Cascade All" (or "Remove Link" / "Restrict" depending on intent) governs whether child Contacts are deleted, unlinked, or block the delete. Business rules enforce field-level logic on forms, calculated columns derive values, and security roles control access — none of them define cross-table delete cascades.

2. Question 2hard

   A functional consultant needs a guided, multi-stage experience that walks sales reps through a lead-to-opportunity process inside a model-driven app, enforcing required fields at each stage. Which feature should they use?

   • AA cloud flow triggered on record creation
   • BA business process flow
   • CA canvas app embedded in the form
   • DA Power BI drillthrough page
   Show answer & explanation

   Correct: B

   A business process flow (BPF) provides exactly this: a visual, stage-based guide rendered at the top of a model-driven form that defines the steps and required fields a user must complete to advance. Cloud flows automate background logic but do not render a guided stage bar, embedded canvas apps add custom UI but not native stage enforcement, and Power BI is analytics. The keywords "guided," "multi-stage," and "enforcing required fields at each stage" are the signature of a BPF.

3. Question 3medium

   You need a Dataverse table that stores time-stamped interactions such as phone calls and tasks, appearing in the activities timeline. Which table type should you create?

   • AStandard table
   • BActivity table
   • CVirtual table
   • DElastic table
   Show answer & explanation

   Correct: B

   Activity tables store time-stamped interactions (calls, tasks, emails) that appear in timelines. Standard tables are general-purpose; virtual tables surface external data; elastic tables handle high-volume/sparse data.

4. Question 4medium

   A column must show the total value of all related child records (for example, the sum of order line amounts on an order). Which column type is most appropriate?

   • ALookup column
   • BRollup column
   • CFormula column (real-time)
   • DChoice column
   Show answer & explanation

   Correct: B

   Rollup columns aggregate values (sum/count/min/max) over related records. Formula columns compute per-row; lookups reference a single related row.

5. Question 5medium

   You want a 1:N relationship where deleting a parent record automatically deletes its child records. Which relationship behavior achieves this?

   • AReferential, Restrict Delete
   • BParental / Cascade All
   • CReferential (Remove Link)
   • DConfigurable cascading set to "Cascade None"
   Show answer & explanation

   Correct: B

   A parental relationship with Cascade All deletes children when the parent is deleted. Restrict prevents deletion; Remove Link just clears the reference.