exam questions

Exam PL-400 All Questions

View all questions & answers for the PL-400 exam

Exam PL-400 topic 2 question 10 discussion

Actual exam question from Microsoft's PL-400
Question #: 10
Topic #: 2
[All PL-400 Questions]

DRAG DROP -
A company is creating a new system based on Microsoft Dataverse.
You need to select the features that meet the company's requirements.
Which options should you use? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: one-to-many relationship -
Only one (1:N) self-referential relationship per table can be set as hierarchical. In a self-referential relationship the primary table and the related table must be of the same type.

Box 2: one-to-many relationship -
1:N (One-to-Many) - A table relationship where one table row for the Primary table can be associated to many other Related table rows because of a lookup column on the related table.
Note: The N:1 (many-to-one) relationship type exists in the user interface because the designer shows you a view grouped by tables. 1:N relationships actually exist between tables and refer to each table as either a Primary/Current table or Related table. The related table, sometimes called the child table, has a lookup column that allows storing a reference to a row from the primary table, sometimes called the parent table. A N:1 relationship is just a 1:N relationship viewed from the related table.
Box 3: many-to-many relationship
N:N (Many-to-Many) - A table relationship that depends on a special Relationship table, sometimes called an Intersect table, so that many rows of one table can be related to many rows of another table.
When viewing rows of either table in a N:N relationship you can see a list of any rows of the other table that are related to it.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-entity-relationships https://docs.microsoft.com/en-us/power-apps/maker/data-platform/visualize-hierarchical-data

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
Vivinator1
Highly Voted 3 years, 2 months ago
Correct, for the self-referential URL: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/visualize-hierarchical-data When a table is configured to have a hierarchical self-referential relationship you can configure visualizations using that hierarchy.
upvoted 18 times
...
jkaur
Highly Voted 1 year, 2 months ago
self-referential one-to-many many-to-many
upvoted 6 times
...
ciotbinhnguyen
Most Recent 7 months, 1 week ago
self-referential (When a table is configured to have a hierarchical self-referential relationship you can configure visualizations using that hierarchy https://learn.microsoft.com/en-us/power-apps/maker/data-platform/visualize-hierarchical-data) One-to-many Many-to-many
upvoted 1 times
...
Mrbrownn
10 months, 2 weeks ago
On exam 12-19-2023
upvoted 3 times
...
ziggy1117
1 year, 3 months ago
a. self-referential b. 1 to many c. many to many
upvoted 4 times
...
700157a
1 year, 3 months ago
self-referential relationship one-to-many many-to-many
upvoted 3 times
...
Sauradj
1 year, 5 months ago
First one should be self-referential, it even says that in the comment also "Only one (1:N) self-referential relationship per table can be set as hierarchical. In a self-referential relationship the primary table and the related table must be of the same type."
upvoted 4 times
...
justin_s
1 year, 9 months ago
Why NN relationship, not connection?
upvoted 1 times
...
TheExamMaster2020
2 years ago
Why can't 1 be self-referential? I feel like the question doesn't give enough information to choose between self-referential and one-to-many for the first question. But if you'd go with one-to-many, you'd only be able to have 2 different levels of hierarchy, right?
upvoted 2 times
V05
1 year, 9 months ago
I agree, ideally the option should be "self-referential one-to-many (1:N) relationship" Link: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-query-hierarchical-data
upvoted 1 times
...
...
Muzera
2 years, 3 months ago
"Records in one entity must be able to reference a single record in another entity" It's one-to-one, not one-to-many, am I wrong?
upvoted 1 times
sindyvaness
1 year, 4 months ago
Records (in plural) in one entity must be able to reference a single record in another entity
upvoted 1 times
...
Muzera
2 years, 3 months ago
Forget this comment, given answers are correct
upvoted 1 times
...
...
ppguru
2 years, 9 months ago
Correct
upvoted 3 times
...
MarlyB
2 years, 10 months ago
In exam 17/12
upvoted 1 times
...
Hugolini
3 years, 2 months ago
Correct
upvoted 3 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