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 is using a model-driven app to process orders. The company uses a custom integration to add orders to Microsoft Dataverse from two separate point-of-sale solutions.
Order numbers are stored in a column on an Order table named Number. The order numbers are prefixed with the value POS1- or POS2- depending on which point-of-sale system they originated from.
The company creates a calculated text column to store the clean order number. The clean order number must remove the point-of-sale system prefix.
You need to configure the action on the calculated column.
Which formula should you use?
Order numbers are stored in a column on an Order table named Number. The order numbers are prefixed with the value POS1- or POS2- depending on which point-of-sale system they originated from.
The company creates a calculated text column to store the clean order number. The clean order number must remove the point-of-sale system prefix.
You need to configure the action on the calculated column.
Which formula should you use?
Suggested Answer: C Vote an answer
Each prefix contains five characters: P, O, S, the system digit, and the hyphen. TRIMLEFT(Number, 5) removes those five leading characters and returns the remaining clean order number. For example, POS1-
78421 becomes 78421, and POS2-78421 produces the same clean value. Removing four characters would leave the hyphen, while TRIMRIGHT would remove characters from the actual order number rather than the source-system prefix. CONCAT adds text and cannot perform the required cleanup. Because the source integration already guarantees one of the two fixed prefixes, the calculated expression can apply the same length consistently. Production design should still consider null values, unexpected prefixes, and maximum output length so malformed integrations do not produce misleading results. The result is derived rather than manually maintained, which prevents divergence between Number and the clean-number column. The AB-
410 Study Guide explicitly includes "configure calculated, rollup, and formula columns." Option C applies the calculated-text function that matches the exact prefix structure.
Study Guide reference/topic: "Implement business and process logic - Configure calculated, rollup, and formula columns." AB-410 Study Guide | Microsoft Learn technical reference
78421 becomes 78421, and POS2-78421 produces the same clean value. Removing four characters would leave the hyphen, while TRIMRIGHT would remove characters from the actual order number rather than the source-system prefix. CONCAT adds text and cannot perform the required cleanup. Because the source integration already guarantees one of the two fixed prefixes, the calculated expression can apply the same length consistently. Production design should still consider null values, unexpected prefixes, and maximum output length so malformed integrations do not produce misleading results. The result is derived rather than manually maintained, which prevents divergence between Number and the clean-number column. The AB-
410 Study Guide explicitly includes "configure calculated, rollup, and formula columns." Option C applies the calculated-text function that matches the exact prefix structure.
Study Guide reference/topic: "Implement business and process logic - Configure calculated, rollup, and formula columns." AB-410 Study Guide | Microsoft Learn technical reference
by Nicholas at Sep 16, 2026, 07:08 AM
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).