Click on the arrows to vote for the correct answer
A.
B.
C.
D.
E.
F.
Correct Answers: D
The Dataverse has a list of column data types.
As a Solution Architect, you need to understand the differences between the types and select the appropriate one to store application data.
Because if you created a column, you could not change its data type.
The answer to the first question provides a list of the age categories that should not contain more than ten items.
Such a list is a perfect example of the Choice data type because it is a static list, stores only label and value, can be used for a long time (does not require values to retire), and, from the user interface point of view, contains less than 200 items.
You need to have an admin/customizer type access if you need to modify the Choice table.
The answer for the second question is also the type of choice, but with multiple selections.
The Dataverse provides the Choices data type for the columns required to select several items from a limited list.
And the answer to the last question is the Lookup data type.
The Lookup column (or reference data) references another table that stores data other than a label and pair, like a custom table for US zip codes.
Such a table can contain all the zip codes (or postal codes), counties, cities, states information.
If you search the table by provided zip code, the Dataverse returns the record with the name of the county and state that can be populated on the screen.
Modifications to the values in a lookup table do not require admin level - any user with read-write permissions for the table can add/modify records.
All other options are incorrect.
For more information about Dataverse data types, please visit the below URLs:
To design the survey form, you need to select appropriate column types for the three questions: age category, interests, and home zip code. Each column type will be used to capture the answer to the corresponding question.
Option A:
- Choices: This column type could be used for Question 1 to capture the age category as a dropdown list.
- Multiline text: This column type could be used for Question 2 to allow customers to select three interests from a list of 25 items. However, this column type is not the most appropriate choice because it allows for long-form text, which is not required for this question.
- Lookup: This column type could be used for Question 3 to populate the customer's county and state based on the home zip code provided by the customer. This is the most appropriate column type for this question.
Option B:
- Lookup: This column type could be used for Question 1 to capture the age category as a dropdown list.
- Choices: This column type could be used for Question 2 to allow customers to select three interests from a list of 25 items.
- Choice: This column type could be used for Question 3 to capture the customer's county and state based on the home zip code provided by the customer. However, this column type is not the most appropriate choice because it only allows for a single selection.
Option C:
- Choice: This column type could be used for Question 1 to capture the age category as a dropdown list.
- Lookup: This column type could be used for Question 2 to populate the customer's interests from a list of 25 items. However, this column type is not the most appropriate choice because it only allows for a single selection.
- Whole number: This column type could be used for Question 3 to capture the customer's home zip code. However, this column type is not the most appropriate choice because it only allows for numerical values and does not allow for the format of a zip code.
Option D:
- Choice: This column type could be used for Question 1 to capture the age category as a dropdown list.
- Choices: This column type could be used for Question 2 to allow customers to select three interests from a list of 25 items.
- Lookup: This column type could be used for Question 3 to populate the customer's county and state based on the home zip code provided by the customer. This is the most appropriate column type for this question.
Option E:
- Choice: This column type could be used for Question 1 to capture the age category as a dropdown list.
- Multiline text: This column type could be used for Question 2 to allow customers to select three interests from a list of 25 items. However, this column type is not the most appropriate choice because it allows for long-form text, which is not required for this question.
- Lookup: This column type could be used for Question 3 to populate the customer's county and state based on the home zip code provided by the customer. This is the most appropriate column type for this question.
Option F:
- Text: This column type could be used for Question 1 to capture the age category as a text input. However, this column type is not the most appropriate choice because it does not allow for the age category to be selected from a pre-defined list.
- Choices: This column type could be used for Question 2 to allow customers to select three interests from a list of 25 items.
- Whole number: This column type could be used for Question 3 to capture the customer's home zip code. However, this column type is not the most appropriate choice because it only allows for numerical values and does not allow for the format of a zip code.
In summary, Option D