exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 1 question 58 discussion

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

HOTSPOT
-

A company is implementing a data model by using Dataverse.

The company requires the following columns in a new custom table:



You need to choose the column type that uses the least amount of database storage for each column.

Which column types should you choose? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
Keeno74
Highly Voted 1 year, 10 months ago
Given answers seem correct to me on research https://www.codingninjas.com/codestudio/library/working-with-columns-in-microsoft-dataverse
upvoted 17 times
killionb12
3 months, 3 weeks ago
To meet the company's requirements for the new custom table in Dataverse, you should configure the following column types: String data, up to 100 characters, rendered as a multiline control: Single Line of Text with a maximum length of 100 characters. String data, up to 8,000 characters, rendered as a multiline control: Multiple Lines of Text (also known as Memo) which can store up to 8,000 characters. Reference to an account or contact using a drop-down list: Lookup column, specifically a Customer type, which can reference an account or contact. List of predefined options, allowing users to select only one option: Choice (also known as Option Set) column.
upvoted 1 times
...
...
JohnChung
Highly Voted 1 year, 5 months ago
It should be a lookup column for student, i've never seen a column type called 'customer'
upvoted 6 times
EWLearn
1 year, 5 months ago
When you're creating a new lookup column, under type, you can choose lookup or customer. Customer references accounts and contacts only.
upvoted 2 times
MrEz
1 year, 3 months ago
it is confusing because when you create a new field, Data Type: Lookup, then select between lookup or customer. once you have selected customer. This data type changes to Customer. But first, it looks like Customer is a sub type of Lookup. but afterwards it seems like a separate data type (same in the fields overview ...).
upvoted 1 times
...
...
...
itenginerd
Most Recent 10 months, 3 weeks ago
On my test yesterday
upvoted 2 times
...
Swa_Pitale
11 months, 2 weeks ago
Answer for Student column from copilot When comparing the Customer and Lookup column types in terms of database storage, the Lookup type generally uses less storage. Here’s why: Customer (CustomerType): This type is specifically designed for referencing accounts or contacts. It may have some additional overhead due to its association with these specific entities. The storage requirements might be slightly higher. Lookup (LookupType): The Lookup type is more versatile; it allows you to reference various entities, not just accounts or contacts. While it provides more flexibility, it tends to have slightly less overhead compared to the Customer type. It’s a better choice if you anticipate needing to link the column to other entities in the future. Therefore, if minimizing database storage is your primary concern, I recommend using the Lookup type for the “Student” column.
upvoted 1 times
...
user861243
1 year ago
correct
upvoted 1 times
...
jkaur
1 year ago
correct
upvoted 1 times
...
61be873
1 year ago
correct never heared of some before. https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields
upvoted 1 times
...
fcc68ed
1 year, 3 months ago
on test 1/4/2024
upvoted 1 times
...
9722f34
1 year, 3 months ago
Answers given are correct. Just checked it.
upvoted 1 times
...
hismail
1 year, 4 months ago
1- Special notes: C- Multiline text This column type allows you to store up to 100 characters and render them as a multiline control. It uses less storage than text or text area, which have a higher limit of characters. 2- Specification: C- Multiline text This column type allows you to store up to 8,000 characters and render them as a multiline control. It uses less storage than text or text area, which have a higher limit of characters. 3- Student: A- Choices This column type allows you to store a reference to an account or contact in the system using a drop-down list. It uses less storage than customer or lookup, which are more complex column types that require additional tables. 4- Course type: A- Choice This column type allows you to store a list of predefined options and let users select only one option. It uses less storage than choices or lookup, which are more complex column types that allow multiple selections or references.
upvoted 1 times
...
APGoel
1 year, 5 months ago
Customer is not a column type. It must be Lookup
upvoted 3 times
Inkubit_team
1 year, 5 months ago
customer allows account or contact. Its correct.
upvoted 3 times
...
...
ttien
1 year, 7 months ago
on exam 20/9/2023
upvoted 2 times
...
LuckyTZ
1 year, 8 months ago
I chose multi text, text area, lookup,choice on Aug 2023 not sure if they are correct. Score 837
upvoted 4 times
...
wsjones
1 year, 8 months ago
on exam - 8/1/2023
upvoted 2 times
...
Patrikk2110
1 year, 9 months ago
This was in the exam in June 2023
upvoted 2 times
...
Ceddy
1 year, 9 months ago
this was on exam 7-4-23
upvoted 2 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