Which data type should you use?

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.

View Answer

Answer:

Explanation:

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.