Microsoft PL-200 Practice Test 10
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.
- Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
- Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
- Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
- Compare team type and membership, record sharing, role privileges, column security enablement and controlled employee-field access attempts.
- 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.
Question 91
A Dataverse and business-apps implementation review finds: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.
- Inspect table ownership metadata, required per-record confidentiality, role access levels and sample users in each business unit.
- Compare team type and membership, record sharing, role privileges, column security enablement and controlled employee-field access attempts.
- Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
- 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 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 record ownership and table security model, rather than directly to Dataverse column choices formulas and rollups: Inspect table ownership metadata, required per-record confidentiality, role access levels and sample users in each business unit.. 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.
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: 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.
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 92
During user acceptance testing for a Power Platform solution: A warranty policy calculates expiry from purchase date but the team relies on a user-maintained text column with no formula. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.
- Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.
- The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.
- The app retrieves current authorized source records with known limitations and without creating unintended competing master copies.
- 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: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 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 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 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 Virtual Dataverse tables for external records, rather than directly to Dataverse column choices formulas and rollups: The app retrieves current authorized source records with known limitations and without creating unintended competing master copies.. 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 93
An organization asks its low-code implementation team to resolve the following: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. Which implementation action BEST meets the requirement? Select ONE best answer.
- Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
- Choose column types appropriately and evaluate supported choice, formula and rollup semantics for derived or aggregated information.
- Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records.
- 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.
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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 cascading relationship behavior, rather than directly to Dataverse column choices formulas and rollups: Configure relationship behavior and individual cascade actions to match retention, assignment, share and delete requirements; test them on sample records.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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: 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 94
A Microsoft Power Platform deployment team observes: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. Which platform principle BEST explains the correct design decision? Select ONE best answer.
- Table ownership influences available record-level security semantics and is selected when the Dataverse table is created, rather than being an ordinary later property change.
- Owner teams can own records and carry roles, access teams grant shared record access, and column security adds protection only after underlying record access exists.
- Choices standardize enumerated values; formula columns calculate supported expressions; rollups aggregate related records with update behavior that differs from immediate manual recalculation.
- 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 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 record ownership and table security model, rather than directly to Dataverse column choices formulas and rollups: Table ownership influences available record-level security semantics and is selected when the Dataverse table is created, rather than being an ordinary later property change.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 Dataverse owner teams access teams and column protection, rather than directly to Dataverse column choices formulas and rollups: Owner teams can own records and carry roles, access teams grant shared record access, and column security adds protection only after underlying record access exists.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 95
A business process owner describes this situation: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.
- Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
- Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up.
- Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
- Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.
Explanation
Correct Answer
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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 search scope and indexing, rather than directly to Dataverse column choices formulas and rollups: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 Alternate keys and Dataverse migration integrity, rather than directly to Dataverse column choices formulas and rollups: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 96
A Power Platform functional consultant receives this requirement: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.
- Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.
- Team access and sensitive-column visibility match least-privilege test personas even as authorized group memberships change.
- Use an ordinary free-text field for every computed or enumerated value and assume users will keep formulas and naming consistent.
- The requested statuses and calculations are consistent, within supported feature limits, and match expected values after appropriate refresh.
Explanation
Correct Answer
D: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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 cascading relationship behavior, rather than directly to Dataverse column choices formulas and rollups: Child records are retained, restricted, reassigned or deleted exactly as the approved lifecycle and audit policy specifies.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 Dataverse owner teams access teams and column protection, rather than directly to Dataverse column choices formulas and rollups: Team access and sensitive-column visibility match least-privilege test personas even as authorized group memberships change.. In this scenario: A service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 service desk needs fixed statuses for triage and uses uncontrolled free-text values that differ across reports. 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 97
A Dataverse and business-apps implementation review finds: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. Which implementation action BEST meets the requirement? Select ONE best answer.
- Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
- Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- Select the appropriate organization-owned or user/team-owned table model during design and align security roles with the intended record-access scope.
Explanation
Correct Answer
A:The required configuration response is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Incorrect Answers
B:This response applies to the different subject of Dataverse auditing configuration and traceability, rather than directly to Alternate keys and Dataverse migration integrity: Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
C:This is an unsafe or unsupported shortcut: Match legacy records only by a nonunique display label and insert a new row on every scheduled retry. It fails to address Alternate keys and Dataverse migration integrity. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
D:This response applies to the different subject of Dataverse record ownership and table security model, rather than directly to Alternate keys and Dataverse migration integrity: Select the appropriate organization-owned or user/team-owned table model during design and align security roles with the intended record-access scope.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Question 98
During user acceptance testing for a Power Platform solution: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. Which platform principle BEST explains the correct design decision? Select ONE best answer.
- Dataverse activity records have specialized activity semantics that can support interaction histories and timeline experiences across related business records.
- Virtual tables can surface externally stored data through provider capabilities; their data is not automatically stored or supported exactly like normal Dataverse rows.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key.
Explanation
Correct Answer
D:The platform behavior that governs this design is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Incorrect Answers
A:This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Alternate keys and Dataverse migration integrity: Dataverse activity records have specialized activity semantics that can support interaction histories and timeline experiences across related business records.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
B:This response applies to the different subject of Virtual Dataverse tables for external records, rather than directly to Alternate keys and Dataverse migration integrity: 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 legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
C:This is an unsafe or unsupported shortcut: Match legacy records only by a nonunique display label and insert a new row on every scheduled retry. It fails to address Alternate keys and Dataverse migration integrity. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Question 99
An organization asks its low-code implementation team to resolve the following: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.
- Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.
- Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests.
- Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
Explanation
Correct Answer
A:The most direct evidence is: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Incorrect Answers
B:This response applies to the different subject of Dataverse cascading relationship behavior, rather than directly to Alternate keys and Dataverse migration integrity: Inspect relationship cascade settings and compare before-and-after parent and child records during controlled assign and delete tests.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
C:This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Alternate keys and Dataverse migration integrity: Inspect activity table metadata, regarding relationships, timeline settings and test appointment or task records on target forms.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
D:This is an unsafe or unsupported shortcut: Match legacy records only by a nonunique display label and insert a new row on every scheduled retry. It fails to address Alternate keys and Dataverse migration integrity. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Question 100
A Microsoft Power Platform deployment team observes: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. Which THREE elements together describe the correct configuration action, decisive diagnostic evidence and verified successful outcome? Select THREE answers.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.
- Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
- Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.
- A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
- Inspect table ownership metadata, required per-record confidentiality, role access levels and sample users in each business unit.
Explanation
Correct Answers
C:The required configuration response is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
D:The most direct evidence is: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
E:This is the observable acceptance result: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Incorrect Answers
A:This is an unsafe or unsupported shortcut: Match legacy records only by a nonunique display label and insert a new row on every scheduled retry. It fails to address Alternate keys and Dataverse migration integrity. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
B:This response applies to the different subject of Dataverse auditing configuration and traceability, rather than directly to Alternate keys and Dataverse migration integrity: Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
F:This response applies to the different subject of Dataverse record ownership and table security model, rather than directly to Alternate keys and Dataverse migration integrity: Inspect table ownership metadata, required per-record confidentiality, role access levels and sample users in each business unit.. In this scenario: A legacy CRM import includes stable external customer identifiers, but rerunning the migration creates duplicate rows. The relevant technical behavior is: Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key. The appropriate implementation is: Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling. Independent validation: Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration. Accept only when: A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.