Exam PL-400 topic 1 question 39 discussion

Actual exam question from Microsoft's PL-400

Question #: 39
Topic #: 1

DRAG DROP
-

A company is implementing business logic in a model-driven app. Employees import records from Microsoft Excel to create lead records.

The company has the following requirements:

• An existing phone number column must be formatted to only display numbers and periods.
• Three existing columns must be calculated to display the sum based on a percentage.
• The solution must not use custom development when possible.

You need to implement the business logic solution.

Which method should you use? To answer, move the appropriate solutions to the correct requirements. You may use each solution once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Afsjoaquim at Nov. 13, 2024, 10:22 a.m.

Comments

Submit Cancel

Afsjoaquim

Highly Voted 8 months, 4 weeks ago

Formula column on both

upvoted 7 times

...

5f14337

Most Recent 1 month ago

Phone number formatting: While formatting is typically handled at the UI level, business rules can be used to enforce simple formatting logic or trigger warnings if the format is incorrect. This satisfies the requirement without custom code. Percentage calculation: Formula columns are ideal for performing calculations like summing values based on a percentage. They are declarative, require no code, and are evaluated in real-time.

upvoted 1 times

...

itmaxuser

3 months, 3 weeks ago

Requirements and Matching Solutions: Phone number formatting ✅ Solution: Plug-in Reason: Formatting logic like removing characters or restructuring strings requires more advanced processing than business rules or formula columns can provide. This is best handled using a plug-in (server-side logic). Percentage calculation ✅ Solution: Formula column Reason: Formula columns are designed specifically for calculations and can handle percentage-based logic without needing custom code. This satisfies the “no custom development” requirement.

upvoted 2 times

...

kgchuene

4 months, 2 weeks ago

The requirements are to use out of the box functionality so the plugin is out and thus the given answer is correct.

upvoted 1 times

...

Juan0414

5 months, 1 week ago

You would need some workarounds but you could use a Formula column (Which uses PowerFx expressions) to format a text phone number "to only display numbers and periods". So I think it should be Formula column on both (Although it would be more straightforward to create the logic for the phone number using a plug-in but the requirement says "The solution must not use custom development when possible")

upvoted 1 times

...

SKIPSKIPPERSON

5 months, 1 week ago

Business rules do not support complex string manipulation. Formula columns to not support regex Even though business insists on minimizing customizations, a plugin is required Therefore correct answer is Plug-in Formula Column (Calculated Column)

upvoted 4 times

...