nerdexam
Microsoft

PL-200 · Question #303

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. The proposed solution, likely involving an insufficient uniqueness configuration, does not prevent duplicate rows if it fails to consider both 'Name' and 'Company' in combination.

Configure Microsoft Dataverse

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: - Name - Company - Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a business rule for the columns. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(40 responses)
  • A
    25% (10)
  • B
    75% (30)

Why each option

The proposed solution, likely involving an insufficient uniqueness configuration, does not prevent duplicate rows if it fails to consider both 'Name' and 'Company' in combination.

AYes
BNoCorrect

If the solution focused on a single column (e.g., 'Contacted On') or an incomplete combination for uniqueness enforcement (e.g., only 'Name'), it would not prevent duplicate entries for the same 'Name' and 'Company' if other fields differ, thereby failing the requirement to prevent duplicate rows.

Concept tested: Dataverse alternate key design for uniqueness

Source: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-reference-rows

Topics

#Dataverse#Business Rules#Data Validation#Duplicate Records

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice