exam questions

Exam PL-100 All Questions

View all questions & answers for the PL-100 exam

Exam PL-100 topic 3 question 57 discussion

Actual exam question from Microsoft's PL-100
Question #: 57
Topic #: 3
[All PL-100 Questions]

DRAG DROP -
A company has 500 products. Each product is referenced by a product ID. Each product belongs to one of eight product categories.
You are creating an app to manage requests for new products.
The product categories will never change. Categories are defined in the column itself, not in a separate table. The data must be structured in a way that does not allow for misspellings.
Only two new tables should be created in Microsoft Dataverse:
✑ Products: Holds the products that can be requested.
✑ Requests: Holds the requests for the product ID and quantity. The products are filtered by product category.
You need to identify the data types to use when building the table columns in Dataverse.
Which data type should you use? To answer, drag the appropriate data types to the correct requirements. Each data 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: Text -
Text columns can contain text characters. This column type has several format options that will change the presentation of the text.

Box 2: Lookup -
When you create a new lookup column you are creating a new Many-to-One (N:1) table relationship between the table you're working with and the Target Row
Type defined for the lookup.

Box 3: Choice -
You can customize forms (main, quick create, and quick view) and email templates by adding multi-select columns that are called Choices. When you add a choices column, you can specify multiple values that will be available for users to select. When users fill out the form, they can select one, multiple, or all the values displayed in a drop-down list.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/types-of-fields

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
CE_Team_Gold
Highly Voted 3 years, 5 months ago
Completly wrong, Choice, Text, Lookup
upvoted 53 times
...
petrovig89
Highly Voted 3 years, 4 months ago
1 - "Categories are defined in the column itself, not in a separate table" - so it will be a choice. We have 8 categories and it is not a table, it can be only choice in this case. 2 - ProductID column in the Product entity it is a Text column (Unique identifier for entity instances). 3 - For 1 Product we can have many Requests, so it is One-Many relationship, so it will be lookup column on the Request entity.
upvoted 10 times
...
4e8b388
Most Recent 1 year, 3 months ago
Choice, Text, Lookup
upvoted 1 times
...
dodo_ouf
1 year, 5 months ago
Choice, text and lookup
upvoted 1 times
...
banner330
1 year, 6 months ago
The answers are incorrect, it should be Choice, Text, Lookup. This totally is at odds with what I was trained and taught by Microsoft Learn Partners. Please update!
upvoted 1 times
...
Net_IT
1 year, 9 months ago
The answers are not correct. Should be: Choice Text Lookup
upvoted 1 times
...
W2S3
2 years, 5 months ago
Answers are correct
upvoted 1 times
...
AnitaR
2 years, 7 months ago
Choice, Text, Lookup
upvoted 2 times
...
RazielLycas
2 years, 7 months ago
who the hell is answering that questions?! admin correct all that wrong answers! I vote for Choice / Text / Lookup
upvoted 3 times
...
harinarayan
2 years, 8 months ago
1-Choice ------catagories are choce like mobile,laptop 2-text ---------is productID column to store id 3-Lookup------ to lookup of productID in table of "request table" ---select from 500 records And " its not good idea to make 500 products to be CHOICE field "
upvoted 4 times
...
xkqn2c
3 years, 4 months ago
I'd say Lookup, Text, Choice. You don't use a lookup to "select from a list of available products."
upvoted 2 times
...
SashM
3 years, 5 months ago
The answer looks right as this is mentioned in " Categories are defined in the column itself, not in a separate table. " so first one should be text, second should be lookup because it needs to create relationship with request entity and last one is choice because we are giving client choice. answer is correct imo.
upvoted 5 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 ...