Microsoft PL-200 Practice Test 11
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.
Question 101
A business process owner describes this situation: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. Which implementation action BEST meets the requirement? Select ONE best answer.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.
- Reuse the appropriate standard Dataverse table where its semantics fit; otherwise create a custom table with a deliberate schema and relationships.
- Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
Explanation
Correct Answer
D: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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 search scope and indexing, rather than directly to Alternate keys and Dataverse migration integrity: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 Standard versus custom Dataverse table selection, rather than directly to Alternate keys and Dataverse migration integrity: Reuse the appropriate standard Dataverse table where its semantics fit; otherwise create a custom table with a deliberate schema and relationships.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 102
A Power Platform functional consultant receives this requirement: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. Which platform principle BEST explains the correct design decision? Select ONE best answer.
- Virtual tables can surface externally stored data through provider capabilities; their data is not automatically stored or supported exactly like normal Dataverse rows.
- Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate.
- Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
Explanation
Correct Answer
C: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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 cascading relationship behavior, rather than directly to Alternate keys and Dataverse migration integrity: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 103
A Dataverse and business-apps implementation review finds: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. Which evidence is MOST useful to verify the root issue rather than an unrelated feature? Select ONE best answer.
- Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up.
- Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.
- Review key status, source key uniqueness, upsert mappings and row counts before and after a repeated sample migration.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
Explanation
Correct Answer
C: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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 search scope and indexing, rather than directly to Alternate keys and Dataverse migration integrity: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 column choices formulas and rollups, rather than directly to Alternate keys and Dataverse migration integrity: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 104
During user acceptance testing for a Power Platform solution: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.
- Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
- The modeled tables represent each real-world entity once, preserve supported standard capabilities and satisfy the documented data relationships.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Explanation
Correct Answer
D: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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 search scope and indexing, rather than directly to Alternate keys and Dataverse migration integrity: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 Standard versus custom Dataverse table selection, rather than directly to Alternate keys and Dataverse migration integrity: The modeled tables represent each real-world entity once, preserve supported standard capabilities and satisfy the documented data relationships.. In this scenario: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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: An integration receives source-system asset codes and must match existing Dataverse records without relying on display names. 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 105
An organization asks its low-code implementation team to resolve the following: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. Which implementation action BEST meets the requirement? Select ONE best answer.
- Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.
- Reuse the appropriate standard Dataverse table where its semantics fit; otherwise create a custom table with a deliberate schema and relationships.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- Define suitable alternate keys for stable business identifiers and use key-aware import or upsert with tested collision handling.
Explanation
Correct Answer
D: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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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: Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 Standard versus custom Dataverse table selection, rather than directly to Alternate keys and Dataverse migration integrity: 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 106
A Microsoft Power Platform deployment team observes: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. Which platform principle BEST explains the correct design decision? Select ONE best answer.
- Alternate keys support uniqueness and identification for integration scenarios where the Dataverse row ID is not the source system key.
- Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways.
- Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
Explanation
Correct Answer
A: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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 search scope and indexing, rather than directly to Alternate keys and Dataverse migration integrity: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 cascading relationship behavior, rather than directly to Alternate keys and Dataverse migration integrity: Dataverse relationship cascading rules can propagate defined operations to related rows, so deletion and reassignment policies must be deliberate.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 107
A business process owner describes this situation: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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.
- 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.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
Explanation
Correct Answer
B: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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 column choices formulas and rollups, rather than directly to Alternate keys and Dataverse migration integrity: Inspect the column type, expression or rollup definition, refresh behavior, related records and displayed values after sample changes.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 108
A Power Platform functional consultant receives this requirement: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. Which observable result BEST demonstrates that the requirement has been implemented successfully? Select ONE best answer.
- The modeled tables represent each real-world entity once, preserve supported standard capabilities and satisfy the documented data relationships.
- Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.
- Match legacy records only by a nonunique display label and insert a new row on every scheduled retry.
- A repeated import updates the intended rows without creating additional duplicates or merging unrelated business records.
Explanation
Correct Answer
D: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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 Standard versus custom Dataverse table selection, rather than directly to Alternate keys and Dataverse migration integrity: The modeled tables represent each real-world entity once, preserve supported standard capabilities and satisfy the documented data relationships.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 activity tables and timeline records, rather than directly to Alternate keys and Dataverse migration integrity: Users see appropriately related interaction history with expected activity fields and filtering on the relevant model-driven form.. In this scenario: A nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 nightly import upserts the same invoice twice because the mapping never identifies a unique external key. 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 109
A Dataverse and business-apps implementation review finds: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. Which implementation action BEST meets the requirement? Select ONE best answer.
- Assess a supported virtual table provider and configure external data access, identity mapping and supported operations before choosing replication.
- Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.
- Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.
- Assume adding any new column instantly makes its contents searchable in every Power Platform search experience without configuration.
Explanation
Correct Answer
C:The required configuration response is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
Incorrect Answers
A:This response applies to the different subject of Virtual Dataverse tables for external records, rather than directly to Dataverse search scope and indexing: Assess a supported virtual table provider and configure external data access, identity mapping and supported operations before choosing replication.. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
B:This response applies to the different subject of Dataverse auditing configuration and traceability, rather than directly to Dataverse search scope and indexing: Enable appropriate environment, table and column auditing and review authorized access, retention and storage effects.. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
D:This is an unsafe or unsupported shortcut: Assume adding any new column instantly makes its contents searchable in every Power Platform search experience without configuration. It fails to address Dataverse search scope and indexing. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
Question 110
During user acceptance testing for a Power Platform solution: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. Which TWO complementary steps are appropriate: the recommended configuration action and its most direct independent verification evidence? Select TWO answers.
- Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up.
- Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries.
- Inspect audit settings at each required scope, generate a controlled update and review the audit history with an authorized role.
- Assume adding any new column instantly makes its contents searchable in every Power Platform search experience without configuration.
- Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.
Explanation
Correct Answers
A:The most direct evidence is: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
B:The required configuration response is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
Incorrect Answers
C:This response applies to the different subject of Dataverse auditing configuration and traceability, rather than directly to Dataverse search scope and indexing: Inspect audit settings at each required scope, generate a controlled update and review the audit history with an authorized role.. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
D:This is an unsafe or unsupported shortcut: Assume adding any new column instantly makes its contents searchable in every Power Platform search experience without configuration. It fails to address Dataverse search scope and indexing. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.
E:This response applies to the different subject of Dataverse activity tables and timeline records, rather than directly to Dataverse search scope and indexing: Choose supported activity tables and activity relationships for time-based interactions, and configure the timeline to surface relevant activities.. In this scenario: Users cannot find a newly added searchable customer identifier because it was never configured in the relevant search setup. The relevant technical behavior is: Dataverse search uses configured search metadata and indexing rather than automatically querying every table column in arbitrary ways. The appropriate implementation is: Configure Dataverse search and approved searchable columns or tables, then account for index updates and test representative queries. Independent validation: Inspect search availability, table search settings, searchable field configuration and query outcomes after indexing has caught up. Accept only when: Authorized users find relevant records through supported search with intended table scope and acceptable index freshness.