Creating and customizing tables and data →hardMultiple ChoiceObjective-mapped

SNOW-CAD Creating and customizing tables and data Practice Question

A custom table 'u_asset' stores asset data. The developer wants to add a field that calculates the depreciation value based on acquisition date and cost. Which field type should be used?

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

A calculated field using a script (e.g., calculated value via business rule or calculated field attribute) can compute depreciation. Option A is wrong because Lookup select is for selection lists, not dynamic calculation. Option B is wrong because Currency is just a data type, not dynamic calculation. Option D is wrong because Condition string is for conditions.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Lookup select
Why it's wrong here
Lookup select allows picking from a list, not calculation.
✗
Currency
Why it's wrong here
Currency stores monetary values statically; it does not compute calculations.
✓
Calculated
Why this is correct
A calculated field can use a script to compute a value dynamically.
✗
Condition string
Why it's wrong here
Condition string is used for conditions in workflow or UI policies.

Go deeper

SNOW-CAD Creating and customizing tables and data Practice Question

Why each option matters

Option-by-option breakdown

Related to this question