PL-900 Demonstrate the capabilities of Power Apps Practice Question
You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?
⚠ Common exam trap
PL-900 often confuses Calculated fields with Rollup fields; candidates may pick Rollup because it also 'calculates', but Rollup aggregates related records, not fields on the same row.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Calculated field
A Calculated field in Dataverse computes its value at runtime using a formula that references other columns in the same table, such as quantity * unit price. It is read-only and automatically updates when the referenced fields change. This matches the requirement for a field that derives its value from other fields.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Calculated field
Why this is correct
A calculated field derives its value at read time from other columns using a defined formula, so quantity multiplied by unit price updates automatically whenever either source field changes, with no workflow or plug-in required.
- ✗
Text field
Why it's wrong here
A text field stores alphanumeric characters and performs no arithmetic, so quantity * unit price cannot be evaluated. It is tempting because it can display a pre-computed result typed in manually, and would be correct for storing free-form data such as a product description or reference code.
- ✗
Choice field
Why it's wrong here
A Choice field restricts input to a predefined list of options and holds no numeric expression, so it cannot derive total price. It is tempting because it constrains data entry, and would be correct for capturing a fixed status or category, such as order priority or payment method.
- ✗
Rollup field
Why it's wrong here
Rollup fields aggregate related child records (sum, count, min, max) across a one-to-many relationship, so they cannot multiply two columns on the same row. They are tempting because they also produce calculated-looking totals, and would be correct for summing line items on a parent order.
Go deeper
Related to this question
About these practice questions
One of 701 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.