A company wants to see the current financial information for every division in one place. It considers using the existing custom Division table. The company asks you to help design the new column to store the total revenue from each division`s outstanding contracts. You can find the details of the contracts in the Contracts table that is related to the Division. 
What column type would you use in your design?

Answer options:

A.Calculation
B.Lookup
C.Choices
D.Rollup
E.Decimal number

Correct Answer: D 
If you want to see the total revenue from each division’s outstanding contracts, you need to use the Rollup column type. Microsoft Dataverse provides special column types for calculations and data aggregation. These types are Calculation and Rollup. 
The Rollup column is similar to the Calculated type. It operates only with the numeric (Whole Number, Decimal Number, and Currency) and date-time datatypes. The Rollup type includes columns from the same table and related child tables in a one-to-many relationship. The list of built-in functions for the Rollup column includes sum, min, max, and count. Rollup columns are read-only. By default, the calculations for the Rollup column run once per hour. Users can change the frequency in Customization settings for the table. It is an asynchronous operation. 
The Calculation column allows users to define a formula based on the column value. This type includes columns from the same table and related parent table in a many-to-one relationship. Calculated columns are read-only. Users benefit from a list of built-in functions for the calculated values and operate on the different data types like text, numeric, and date-time. The calculations run synchronously when a record is saved. Option C is incorrect because you need to use the Rollup column for data aggregation but not a Calculated type.
Options A, B, and E are incorrect because the Lookup, Choices, and Decimal number are the data types but not the column types.
For more information about the Dataverse Rollup and Calculated and columns, please visit the below URLs: 

https://docs.microsoft.com/en-us/learn/modules/data-modeling/5-dataverse
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields
https://docs.microsoft.com/en-us/learn/modules/create-define-calculation-rollup-fields/3-calculation