Exam AB-410 Topic 1 Question 78 Discussion
Actual exam question for Microsoft's AB-410 exam
Question #: 78
Topic #: 1
Question #: 78
Topic #: 1
A company uses Dataverse to configure derived values for sales records.
The company requires the following functionality:
- Evaluate an expression by using numerical columns in the same row.
- Calculate the result dynamically when accessed.
- Ensure the result is NOT stored as part of the table data.
- The solution must minimize use of custom code.
You need to configure the app.
What should you do?
The company requires the following functionality:
- Evaluate an expression by using numerical columns in the same row.
- Calculate the result dynamically when accessed.
- Ensure the result is NOT stored as part of the table data.
- The solution must minimize use of custom code.
You need to configure the app.
What should you do?
Suggested Answer: D Vote an answer
The best option to use is a calculated column (or its modern equivalent, a formula column).
Why?
Evaluates expressions in the same row: Calculated and formula columns natively execute calculations using other numerical columns belonging to the exact same row.
Calculates dynamically when accessed: Calculations are performed on-the-fly and evaluated in real-time when the data is read or displayed.
Not stored in table data: Because the value is dynamically generated at the database or query level whenever requested, it does not permanently occupy physical table data storage.
Minimizes custom code: These are out-of-the-box, low-code configurations inside Microsoft Dataverse utilizing simple Excel-like or Power Fx formulas.
Reference:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields
Why?
Evaluates expressions in the same row: Calculated and formula columns natively execute calculations using other numerical columns belonging to the exact same row.
Calculates dynamically when accessed: Calculations are performed on-the-fly and evaluated in real-time when the data is read or displayed.
Not stored in table data: Because the value is dynamically generated at the database or query level whenever requested, it does not permanently occupy physical table data storage.
Minimizes custom code: These are out-of-the-box, low-code configurations inside Microsoft Dataverse utilizing simple Excel-like or Power Fx formulas.
Reference:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields
by Heather at Oct 12, 2026, 02:05 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).