nerdexam
Microsoft

PL-200 · Question #288

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 A. Yes. To prevent duplicate rows based on 'Name' and 'Company' in a Dataverse table, implementing an alternate key on these columns is the effective solution.

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 an alternate key for the columns. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(33 responses)
  • A
    88% (29)
  • B
    12% (4)

Why each option

To prevent duplicate rows based on 'Name' and 'Company' in a Dataverse table, implementing an alternate key on these columns is the effective solution.

AYesCorrect

Configuring an alternate key on the 'Name' and 'Company' columns in Dataverse ensures data uniqueness at the database level. This mechanism strictly prevents the creation of new records with the same combined values for these fields, directly fulfilling the requirement to not contain any duplicate rows.

BNo

Concept tested: Dataverse alternate keys for uniqueness

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

Topics

#Dataverse#Alternate Keys#Data Integrity#Duplicate Prevention

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice