What Should be the Type of the New Column?
Question
You need to create a new column in your custom Branches Dataverse table.
The table contains the current financial information for every division in the company.
The new column should store the total revenue from outstanding contracts per division.
Related to Branches, the Contracts table stores details for each contract.
What should be the type of the new column?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: E
Microsoft Dataverse provides special column types for calculations and data aggregation.
These types are Calculation and Rollup.
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.
The Rollup column is like the Calculated type.
They operate 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 is smaller compared to the Calculated columns.
It 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.
Options A, B, C and D are incorrect because the Whole number, Choices, and Decimal number are the data types but not the column types.
For more information about The Dataverse Calculated and Rollup columns, please visit the below URLs:
Based on the requirements mentioned in the question, we need to create a new column in the custom Branches Dataverse table that will store the total revenue from outstanding contracts per division. To determine the appropriate type for this new column, we need to consider the nature of the data that will be stored in the column and the calculations that will be performed on it.
Here are some considerations for each of the answer options:
A. Whole number: This data type represents integers without decimal places. Since revenue values are often represented as decimal numbers, using a whole number data type would not be appropriate.
B. Choices: This data type represents a list of predefined values that users can choose from. This would not be appropriate for storing revenue values, as the revenue values will need to be calculated based on data from the Contracts table.
C. Calculation: This data type represents a column that is calculated based on other columns in the same table or related tables. This data type could be a good fit for the new column we need to create, as we will need to calculate the total revenue from outstanding contracts per division based on data from the Contracts table.
D. Decimal number: This data type represents numbers with decimal places. Since revenue values are often represented as decimal numbers, this data type could be appropriate for the new column.
E. Rollup: This data type represents a column that aggregates data from related records. This data type could be a good fit for the new column we need to create, as we will need to aggregate revenue data from the Contracts table based on division.
Based on the above considerations, the most appropriate answer for the type of the new column would be either C. Calculation or D. Decimal number. However, without more information about the specifics of the data and calculations required, it is difficult to determine which of these options would be the best fit.
