cert
cert-1
cert-2

Pass Microsoft PL-200 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
PL-200 Exam - Verified By Experts
PL-200 Premium Bundle
$29.98

PL-200 Premium Bundle

$79.99
$109.97
  • Premium File 328 Questions & Answers. Last update: Nov 02, 2026
  • Training Course 94 Video Lectures
  • Study Guide 800 Pages
 
$109.97
$79.99
accept 10 downloads in last 7 days
block-screenshots
Purchase Microsoft PL-200 Exam Training Products Individually
Microsoft PL-200 Premium File
Premium File 328 Q&A
$76.99$69.99
Microsoft PL-200 Video Training Course
Training Course 94 Lectures
$21.99 $19.99
Microsoft PL-200 PDF Study Guide
Study Guide 800 Pages
$21.99 $19.99
Microsoft PL-200 Practice Test 9

Question 80

During user acceptance testing for a Power Platform solution: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. Which TWO complementary steps are appropriate: the recommended configuration action and its most direct independent verification evidence? Select TWO answers.

  1. Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact.
  2. Model the one-to-many relationship using an appropriate lookup on the many-side table and enforce required references where business rules demand them.
  3. Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.
  4. Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records.
  5. Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests.

Explanation

Correct Answers

D:

The required configuration response is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. In this scenario: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

E:

The most direct evidence is: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. In this scenario: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Incorrect Answers

A:

This is an unsafe or unsupported shortcut: Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact. It fails to address Dataverse cascading relationship behavior. In this scenario: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

B:

This response applies to the different subject of One-to-many lookup relationship design, rather than directly to Dataverse cascading relationship behavior: Model the one-to-many relationship using an appropriate lookup on the many-side table and enforce required references where business rules demand them.. In this scenario: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

C:

This response applies to the different subject of Alternate keys and Dataverse migration integrity, rather than directly to Dataverse cascading relationship behavior: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.. In this scenario: When an assigned account owner changes, associated records should follow a defined reassignment policy but remain on the old owner. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Question 81

An organization asks its low-code implementation team to resolve the following: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. Which implementation action BEST meets the requirement? Select ONE best answer.

  1. Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact.
  2. Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.
  3. Reuse the appropriate standard Dataverse table where its semantics fit; otherwise create a custom table with a deliberate schema and relationships.
  4. Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records.

Explanation

Correct Answer

D:

The required configuration response is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Incorrect Answers

A:

This is an unsafe or unsupported shortcut: Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact. It fails to address Dataverse cascading relationship behavior. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

B:

This response applies to the different subject of Dataverse column choices formulas and rollups, rather than directly to Dataverse cascading relationship behavior: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

C:

This response applies to the different subject of Standard versus custom Dataverse table selection, rather than directly to Dataverse cascading relationship behavior: Reuse the appropriate standard Dataverse table where its semantics fit; otherwise create a custom table with a deliberate schema and relationships.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Question 82

A Microsoft Power Platform deployment team observes: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. Which platform principle BEST explains the correct design decision? Select ONE best answer.

  1. Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate.
  2. A lookup creates a structured relationship between a child row and its referenced parent, supporting referential navigation beyond duplicated strings.
  3. Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation.
  4. Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact.

Explanation

Correct Answer

A:

The platform behavior that governs this design is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Incorrect Answers

B:

This response applies to the different subject of One-to-many lookup relationship design, rather than directly to Dataverse cascading relationship behavior: A lookup creates a structured relationship between a child row and its referenced parent, supporting referential navigation beyond duplicated strings.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

C:

This response applies to the different subject of Dataverse column choices formulas and rollups, rather than directly to Dataverse cascading relationship behavior: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

D:

This is an unsafe or unsupported shortcut: Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact. It fails to address Dataverse cascading relationship behavior. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Question 83

A business process owner describes this situation: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.

  1. Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact.
  2. Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests.
  3. Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.
  4. Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.

Explanation

Correct Answer

B:

The most direct evidence is: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Incorrect Answers

A:

This is an unsafe or unsupported shortcut: Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact. It fails to address Dataverse cascading relationship behavior. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

C:

This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse cascading relationship behavior: Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

D:

This response applies to the different subject of Alternate keys and Dataverse migration integrity, rather than directly to Dataverse cascading relationship behavior: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Question 84

A Power Platform functional consultant receives this requirement: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.

  1. The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.
  2. Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact.
  3. Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.
  4. Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.

Explanation

Correct Answer

C:

This is the observable acceptance result: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Incorrect Answers

A:

This response applies to the different subject of Dataverse column choices formulas and rollups, rather than directly to Dataverse cascading relationship behavior: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

B:

This is an unsafe or unsupported shortcut: Enable broad cascade delete on every relationship to keep the database tidy without evaluating retention and business impact. It fails to address Dataverse cascading relationship behavior. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

D:

This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse cascading relationship behavior: Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.. In this scenario: A child record must remain for audit retention even after its parent is removed and the developer selects cascade delete. The relevant technical behavior is: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate. The appropriate implementation is: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records. Independent validation: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests. Accept only when: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.

Question 85

A Dataverse and business-apps implementation review finds: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. Which implementation action BEST meets the requirement? Select ONE best answer.

  1. Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.
  2. Choose an owner team, access team or Entra group team as appropriate, and apply column security profiles on eligible sensitive fields in addition to row access.
  3. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
  4. Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.

Explanation

Correct Answer

A:

The required configuration response is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

B:

This response applies to the different subject of Dataverse owner teams access teams and column protection, rather than directly to Dataverse column choices formulas and rollups: Choose an owner team, access team or Entra group team as appropriate, and apply column security profiles on eligible sensitive fields in addition to row access.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

C:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

D:

This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse column choices formulas and rollups: Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Question 86

During user acceptance testing for a Power Platform solution: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. Which platform principle BEST explains the correct design decision? Select ONE best answer.

  1. Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key.
  2. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
  3. Virtual tables can surface externally stored data through provider capabilities; their data is not automatically stored or supported exactly like normal Dataverse rows.
  4. Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation.

Explanation

Correct Answer

D:

The platform behavior that governs this design is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

A:

This response applies to the different subject of Alternate keys and Dataverse migration integrity, rather than directly to Dataverse column choices formulas and rollups: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

B:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

C:

This response applies to the different subject of Virtual Dataverse tables for external records, rather than directly to Dataverse column choices formulas and rollups: Virtual tables can surface externally stored data through provider capabilities; their data is not automatically stored or supported exactly like normal Dataverse rows.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Question 87

An organization asks its low-code implementation team to resolve the following: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.

  1. Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.
  2. Check provider support, external identifiers, authentication, supported CRUD and querying operations and a representative application read.
  3. Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
  4. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.

Explanation

Correct Answer

C:

The most direct evidence is: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

A:

This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse column choices formulas and rollups: Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

B:

This response applies to the different subject of Virtual Dataverse tables for external records, rather than directly to Dataverse column choices formulas and rollups: Check provider support, external identifiers, authentication, supported CRUD and querying operations and a representative application read.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

D:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Question 88

A Microsoft Power Platform deployment team observes: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.

  1. Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.
  2. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
  3. The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.
  4. Representative users can read and edit only the intended records while the table ownership model matches the requirements.

Explanation

Correct Answer

C:

This is the observable acceptance result: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

A:

This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse column choices formulas and rollups: Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

B:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

D:

This response applies to the different subject of Dataverse record ownership and table security model, rather than directly to Dataverse column choices formulas and rollups: Representative users can read and edit only the intended records while the table ownership model matches the requirements.. In this scenario: A manager wants an order total aggregated from related line items but the maker manually enters the amount on each order. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Question 89

A business process owner describes this situation: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. Which implementation action BEST meets the requirement? Select ONE best answer.

  1. Choose an owner team, access team or Entra group team as appropriate, and apply column security profiles on eligible sensitive fields in addition to row access.
  2. Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.
  3. Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.
  4. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.

Explanation

Correct Answer

B:

The required configuration response is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

A:

This response applies to the different subject of Dataverse owner teams access teams and column protection, rather than directly to Dataverse column choices formulas and rollups: Choose an owner team, access team or Entra group team as appropriate, and apply column security profiles on eligible sensitive fields in addition to row access.. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

C:

This response applies to the different subject of Dataverse search scope and indexing, rather than directly to Dataverse column choices formulas and rollups: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

D:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Question 90

A Power Platform functional consultant receives this requirement: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. Which TWO complementary steps are appropriate: the recommended configuration action and its most direct independent verification evidence? Select TWO answers.

  1. Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
  2. Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
  3. Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
  4. Compare team type and membership, record sharing, role privileges, column security enablement and controlled employee-field access attempts.
  5. Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.

Explanation

Correct Answers

A:

The most direct evidence is: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

E:

The required configuration response is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Incorrect Answers

B:

This is an unsafe or unsupported shortcut: Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent. It fails to address Dataverse column choices formulas and rollups. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

C:

This response applies to the different subject of Alternate keys and Dataverse migration integrity, rather than directly to Dataverse column choices formulas and rollups: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

D:

This response applies to the different subject of Dataverse owner teams access teams and column protection, rather than directly to Dataverse column choices formulas and rollups: Compare team type and membership, record sharing, role privileges, column security enablement and controlled employee-field access attempts.. In this scenario: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. The relevant technical behavior is: Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation. The appropriate implementation is: Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information. Independent validation: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes. Accept only when: The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.

Microsoft Power Platform Functional Consultant (PL-200) Practice Tests