QuestionQ47

VerifiedBuild business application logic and automation

A company uses a model-driven app to track order-processing duration.

The company needs a system with the following functionality:

  • The order age, calculated from the created date, must appear on forms and views.
  • The value must update dynamically when it is viewed, without storing the result.
  • The value must not be stored in the database.

You need to configure the column types.

Which two column types should you use? Each correct answer provides part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
Explanation

The requirements — a value computed dynamically each time the record is viewed and never persisted to the database — point to Dataverse's two computed column types. A formula column uses a Power Fx expression (for example, DateDiff(createdon, UTCNow())) that is evaluated at query time, so the order age is always current and no value is stored. A calculated column likewise performs its calculation in real time when the record is retrieved, can reference the created-on date, and displays the result on forms and views without persisting it. BigInt is a physical whole-number column whose value is stored in the database, and a prompt column produces AI-generated output rather than deterministic date arithmetic, so neither meets the requirements.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!