Exam PL-100 topic 2 question 14 discussion

Actual exam question from Microsoft's PL-100

Question #: 14
Topic #: 2

DRAG DROP -
You are creating entities in a Microsoft Dataverse database to capture sales data.
You create an entity named Sales that includes the following fields:

You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.
You need to configure the fields for the entities.
Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field 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

Suggested Answer:

Box 1: Calculated -
Calculated columns are calculated in real-time when they are retrieved. Calculated columns can be composed using different data types. For example, an Integer calculated column may reference values from Decimal or Currency columns.

Box 2: Simple -
A simple column isn't defined as a calculated or rollup column.

Box 3: Rollup -
Because rollup columns persist in the database, they can be used for filtering or sorting just like regular columns.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes

by et_learner at Sept. 9, 2022, 6:25 a.m.

Comments

Submit Cancel

et_learner

Highly Voted 2 years, 9 months ago

Agree with the answers

upvoted 10 times

...

Jkaay

Most Recent 1 year, 7 months ago

the given solution is correct

upvoted 1 times

...

anasben

1 year, 9 months ago

Simple Simple Rollup

upvoted 1 times

...

Edriska

1 year, 11 months ago

GrossAmount: Calculated Calculated: This field type allows you to define a formula that calculates a value based on other fields, such as the gross amount or the net amount. You can use this to display values that are derived from other fields without storing them in the database. TotalSales: Rollup Rollup: This field type allows you to aggregate data from related entities, such as the total sales for each salesperson. You can use this to display summary information that is calculated periodically based on a schedule. DiscountAmount : im not sure The simple field type is not a valid option for Microsoft Dataverse. It is a term used in some other database systems to indicate a basic data type that does not have any special properties or constraints. In Microsoft Dataverse, you need to choose a specific data type and format for each column, such as text, number, date, etc. You can see the list of available data types and formats in this article https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields

upvoted 2 times

...

AP2020

2 years, 5 months ago

Correct

upvoted 4 times

...