exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 1 question 16 discussion

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

DRAG DROP -
You are designing an app for a bank.
You must create entities for the app and configure relationships between entities:

Which relationship types should you use? To answer, drag the appropriate relationship types to the correct requirements. Each relationship type 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: N:1 -
You add a lookup column with a many-to-one relationship.

Box 2: N:N -

Box 3: N:1 -
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-entity-lookup

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
ArezouDynamics
Highly Voted 3 years, 1 month ago
The provided answer is correct! So, a trick to identify the relationships: If table A has a look up field to table B : A to B relationship is : N:1. I suggest to do a quick test and it will be more clear.
upvoted 42 times
...
mecreative
Highly Voted 3 years, 3 months ago
Box 2: N:N makes sense in real life. There can be more than one applicant on a loan application.
upvoted 9 times
theTeknician
1 week, 1 day ago
I'm a little confused. Do we have to assume that one loan application can contain several applicants? Can anyone who has had this question confirm if N:N is the expected answer?
upvoted 1 times
...
...
isabelcha
Most Recent 3 weeks, 6 days ago
Do we have to assume one loan application can contain several applicants? I don't think its reasonable to expect the test taker to make such assumption. Or am I missing something?
upvoted 2 times
...
WikyWik
8 months, 3 weeks ago
I say the answer is: (1) N:1. Because the lookup column. (2) N:1. It is stated that the LoanApplicant Enitity represents A PERSON & applicants can have more than 1 application. One loan can't be connected to multiple applicants. (3) 1:N. Multiple loans "multiple people/applicants" can apply for the same house
upvoted 4 times
...
JazT365
9 months, 4 weeks ago
On Exam Feb 2024
upvoted 3 times
...
Sweden2022
1 year, 2 months ago
On test 14.09.2023
upvoted 4 times
...
nwmc
1 year, 5 months ago
on test 13.07.2023
upvoted 4 times
...
nicknamety
1 year, 6 months ago
LoanApplicant Table rows and columns example: FirstName | LastName | Email How can there be a many to many (N:N) relationship in box 2? That would only be possible if the LoanApplicant contained duplicates of the same person or the LoanApplicant table also contained the loan applied for. In that case it would be more like a FACT table but LoanApplicant seems to suggest it is a Dimension table.
upvoted 1 times
...
nicknamety
1 year, 6 months ago
There is missing context in my opinion. One could reasonably assume that the LoanApplicant table does not contain duplicates. If LoanApplicant only contains a person's name and email, then it is basically like a contact table. Therefore, there would be a 1:N relationship with the Loan table that has multiple loan applications of that applicant. Poorly worded question.
upvoted 2 times
...
charles879987
1 year, 7 months ago
Question do not state if a loan can have more than one applicants. I have to assume it to get Box 2 correct. Poorly stated question.
upvoted 3 times
charles879987
1 year, 7 months ago
Question only says applicant can apply for one type of loan. I have it wrong on actual exam because of wrong assumption
upvoted 1 times
...
...
charles879987
1 year, 7 months ago
This question was on Exam and whoever wrote it should have been more clear on what entities are involved in relationship
upvoted 5 times
gina_the_boss
11 months ago
whoever wrote it needs to be fired. so bad!
upvoted 4 times
...
...
nilakuma
1 year, 9 months ago
Question was on test 3/2023
upvoted 3 times
...
deepaliV
1 year, 11 months ago
true that! A good question to understand relationships
upvoted 1 times
...
ferdion
2 years ago
On Exam 04/12/2022
upvoted 1 times
...
abhigang51
2 years ago
this question is kept on 23/11/2022
upvoted 1 times
...
Anon12546
2 years, 1 month ago
Part of exam in Oct 2022
upvoted 4 times
...
OldHand1
2 years, 2 months ago
The bit I can't get my head around here is nothing to do with relationships, its how there can be many LoanApplicants, who represents a person who is applying for a loan to a single contact. So are we saying its a LoanApplicant with multiple personality disorder?
upvoted 7 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