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

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

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

by samkslee at Aug. 22, 2021, 12:51 p.m.

Comments

Submit Cancel

ArezouDynamics

Highly Voted 3 years, 7 months 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 43 times

...

mecreative

Highly Voted 3 years, 10 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

6 months, 3 weeks 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 2 times

...

Christoz

Most Recent 4 weeks ago

1. N : 1 - A many-to-one (N:1) relationship from LoanApplicant to Contact (or similar entity) allows multiple applicants to reference the same email/contact. 2. 1 : N - A one-to-many (1:N) relationship from LoanApplicant to Loan means one applicant can have multiple loan applications. 3. N : 1 - A many-to-one (N:1) relationship from Loan to Property ensures that multiple loans can reference a single property.

upvoted 1 times

...

isabelcha

7 months, 2 weeks 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 4 times

...

WikyWik

1 year, 3 months 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 7 times

...

JazT365

1 year, 4 months ago

On Exam Feb 2024

upvoted 3 times

...

Sweden2022

1 year, 9 months ago

On test 14.09.2023

upvoted 4 times

...

nwmc

1 year, 11 months ago

on test 13.07.2023

upvoted 4 times

...

nicknamety

2 years, 1 month 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

2 years, 1 month 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

...