exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 1 question 64 discussion

Actual exam question from Microsoft's PL-200
Question #: 64
Topic #: 1
[All PL-200 Questions]

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 duplicate detection rule for the columns.

Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
webcreator
Highly Voted 11 months, 4 weeks ago
Selected Answer: B
A duplicate detection rule can check multiple columns within a table to see if duplicates exist. But it won't stop user from creating the record. Only Alternate Keys can do that.
upvoted 6 times
...
Smith_S
Most Recent 10 months, 2 weeks ago
The Duplicate detection rule won't work to restrict duplicate records it always creates a record whereas an alternate will give a business error if a duplicate exist
upvoted 2 times
...
61be873
1 year ago
No Doesn't work in canvas apps only in model driven https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Powerapps-canvas-app-does-not-respect-duplicate-detection-rules/td-p/2053503
upvoted 3 times
...
jmccolly
1 year ago
Selected Answer: A
I think it's A (Yes). A duplicate detection rule can check multiple columns within a table to see if duplicates exist. Base Record Type: Table A Matching Record Type: Table A Then, define the fields you want to check for duplicates with an AND operator.
upvoted 3 times
...
JohnChung
1 year, 1 month ago
Selected Answer: B
The answer for this question should be No. Though duplicate detection rule triggers before you save data to existing records, it needs 2 tables to make a duplicate detection rule, "Base record and Matching record". Base record is the table for checking whether the subject of the new record exist or not. Matching record is the table the new record is going to be added to. This question mentions only one table, so the answer must be "No". https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
upvoted 2 times
61be873
1 year ago
Base Record Type: Table A Matching Record Type: Table A
upvoted 2 times
...
...
MrEz
1 year, 2 months ago
A) Duplicate Detection Rule triggers before you save it. and suggests the existing records. You then can decide if it is a duplicate and you don't continue to save it. or maybe you decide it is NOT a duplicate because Name George Bush, both of them - senior and junior, happen to work for the same company, eg. Carlyle group, have e.g. a call on the same Date (we don't know if it is date only or date and time field, sheduled times could happen at same time, timestamp not but then it is almost never same) and maybe same time?! from this perspective it is even better as the alternate key
upvoted 1 times
...
DaanEp
1 year, 3 months ago
Selected Answer: B
Duplicate detection rules in Dataverse do not directly support creating rules based on multiple columns that form the key to a table. Duplicate detection rules typically allow you to define criteria for identifying duplicate records based on individual columns. So it can work in combination with an alternate key but not on it's own.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago