nerdexam
Microsoft

PL-200 · Question #289

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 h

The correct answer is B. No. The proposed solution, likely involving Dataverse business rules, does not fully prevent duplicate rows because business rules primarily validate data and do not enforce database-level uniqueness.

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 Microsoft Power Fx formula for the columns. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(28 responses)
  • A
    18% (5)
  • B
    82% (23)

Why each option

The proposed solution, likely involving Dataverse business rules, does not fully prevent duplicate rows because business rules primarily validate data and do not enforce database-level uniqueness.

AYes
BNoCorrect

Business rules in Dataverse can display warnings or error messages, but they do not provide the same transactional uniqueness guarantee as alternate keys. Users might still be able to bypass business rule warnings or create duplicates through bulk operations, meaning they do not inherently prevent duplicate records from being saved.

Concept tested: Dataverse business rules vs. uniqueness enforcement

Source: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-business-rules-recommendations-validate-data

Topics

#Dataverse uniqueness#Power Fx scope#Duplicate detection#Data integrity

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice