Exam PL-100 topic 2 question 32 discussion

Actual exam question from Microsoft's PL-100

Question #: 32
Topic #: 2

HOTSPOT -
A company is building a canvas app.
A user needs to understand which data they can make available for the 500 contacts that are present in the Contact table. All relevant data must be shown in the app. Single fields must show one record and grids must show multiple records. Only the primary fields for each related table should be shown for a contact.

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Use a single field for Contact table and a grid for the Connection table
The Contact table is on 1-side of the 1-to-many relation to the Connection table.
Box 2: Use a single field for Team table and a grid for the Connect table
The Team table is on 1-side of the 1-to-many relation to Contact.

by petrovig89 at Jan. 21, 2022, 3:43 p.m.

Comments

Submit Cancel

Edriska

1 year, 11 months ago

Correct : To display the Connection table information for each contact in the Contacts table, you should "use a single field for the Contact table and a grid for the Connection table" . This is because the relationship between Contact and Connection is one-to-many, meaning that one contact can have multiple connections, but one connection can only belong to one contact. Therefore, a single field can show the contact name, and a grid can show the related connections. To display the Team table information for each contact in the Contact table, you should use a "grid for the Contact table and a single field for the Team table". This is because the relationship between Contact and Team is many-to-one, meaning that one team can have multiple contacts, but one contact can only belong to one team. Therefore, a grid can show the contacts, and a single field can show the related team name.

upvoted 2 times

...

DSM_LM

2 years, 6 months ago

Correct. Contact and Connection table are in a 1*n relationship (1=contact, n= connections). So single field for Contact and Grid for Connections

upvoted 4 times

...

RazielLycas

2 years, 7 months ago

How do you infer that the Team table is on 1-side of the 1-to-many relation to Contact?

upvoted 2 times

Jajabink

2 years, 6 months ago

Team is singular (one) to Contacts is plural (many). Another English grammar question.

upvoted 1 times

...

[Removed]

2 years, 5 months ago

The way I see it, look at Related Table column and connection description. If we tell we have a connection from T1 to T2, Related Table indicates which is T2, you can then look at the description to see which is T1

upvoted 2 times

...

SashM

3 years, 5 months ago

correct 100%

upvoted 3 times

...

petrovig89

3 years, 5 months ago

Correct

upvoted 4 times

...