Power Fx Formula Column for 20% Adoption Deposit
Short answer
D Decimal('Adoption Fee') * 0.20 casts the currency column to a decimal and returns the 20% Deposit value for the Resident table.
Question
This is a case study. Case studies are not timed separately from other exam sections. You can use as much exam time as you would like to complete each case study. However, there might be additional case studies or other exam sections. Manage your time to ensure that you can complete all the exam sections in the time provided. Pay attention to the Exam Progress at the top of the screen so you have sufficient time to complete any exam sections that follow this case study. To answer the case study questions, you will need to reference information that is provided in the case. Case studies and associated questions might contain exhibits or other resources that provide more information about the scenario described in the case. Information provided in an individual question does not apply to the other questions in the case study. A Review Screen will appear at the end of this case study. From the Review Screen, you can review and change your answers before you move to the next exam section. After you leave this case study, you will NOT be able to return to it. To start the case study To display the first question in this case study, select the “Next” button. To the left of the question, a menu provides links to information such as business requirements, the existing environment, and problem statements. Please read through all this information before answering any questions. When you are ready to answer a question, select the “Question” button to return to the question. Background Contoso Suites is an animal shelter that specializes in finding homes for dogs that have been given up by their owners. The shelter can house up to 20 dogs. The shelter is implementing one model-driven Power Apps app to track the dogs and schedule meetings with potential adopters. No other apps will be created. The model-driven app uses Dataverse with out-of-the-box functionality when possible. Dataverse is set up with the following configuration: • The solution prefix “cs” is used for all new components. • Only the root business unit is used. • All tables are stored in Dataverse and do not require rapid scaling. • Exchange server-side sync is not configured. Adopters • Adopter information is stored in a Contact table. • Contacts are considered to be duplicates if they have the same email address and last name. • Adopters are often late to meetings, so a reminder email is sent to them two hours before their meeting. • The email reminders must not be tracked in the system. Dogs • Dog information is stored in a Dog table, which is organization owned. • Breed, size, and weight are fields in the table. Dog residency • A Resident table tracks the stay of each dog. • Each resident record has a lookup for the dog and its food. • The food type and amount are logged on each resident record. Auto-posting is not configured for changes to food type and amount. • A fee of $120 is in a currency column named Adoption Fee. This fee can be changed depending on the adoption circumstances. • A formula column named Deposit is automatically populated with 20% of the adoption fee. • A resident record is generated automatically when a dog record is created. This is the only way a resident record can be created. Exercise and feedings • Exercise for the dogs is tracked in an Exercise table. • Feedings are tracked in a Feeding table. • Exercise and feeding records appear in a resident record timeline. Care staff • The care staff must be able to view who changed the food type and the amount that was given, for up to three months ago. • The staff must be able to update the weight of a dog on the resident record. • The staff report that the buttons are too small on the touch screen they use to log exercise and feeding. • The staff must be able to view who the adopters are for upcoming meetings. The staff must not be able to update adopter information. Administrative staff • Administrative staff must receive a weekly list of duplicate contacts. Duplicate alerts must not appear when a staff member saves a new contact. • When an adopter wants to adopt a dog, the staff must perform a series of adoption duties in order. The following duty list must be displayed on the screen: o Commitment:
- Obtain adopter signature in a commitment document.
- Collect deposit.
- Document spay or neutering date.
- Perform spay or neutering.
- Document pickup date.
- Collect full payment.
- Verify dog is picked up.
Key Takeaways
The question tests Power Fx syntax for formula columns over currency data; the trap is assuming a bare multiplication or a literal 20% token will type-check and return the correct decimal result.
In Dataverse, a calculated formula column named Deposit must return 20% of the currency column Adoption Fee for Contoso Suites' Resident table. The correct Power Fx pattern is Decimal('Adoption Fee') * 0.20, which explicitly casts the currency value to a decimal before multiplying.
Common mistake: Learners most often pick 'Adoption Fee' * 0.20 (A), forgetting that the currency column reference should be explicitly cast with Decimal() so the formula column returns a properly typed numeric value.
Expert Analysis
Why the Answer Is Correct
Option D, Decimal('Adoption Fee') * 0.20, is correct because Adoption Fee is a currency column and Dataverse Power Fx formula columns require an explicit, well-typed numeric result. Wrapping the column in Decimal coerces the currency value to a decimal and multiplying by the decimal literal 0.20 yields exactly 20% of the fee as a numeric Deposit value. This is the documented pattern for currency-to-decimal arithmetic in Dataverse formula columns, and it keeps the calculation deterministic when the fee is later changed per adoption circumstances.Why the Other Options Are Wrong
Option A, 'Adoption Fee' 0.20, omits the Decimal cast, so the operation runs directly on a currency-typed value and can fail or return an unexpected type in a formula column. Option B, Decimal('Adoption Fee' 20%), multiplies inside the cast using the literal 20%, which computes 2,000% of the fee rather than 20% — a semantic error even if it appeared to parse. Option C, 'Adoption Fee' * 20%, multiplies by 20 instead of 0.20, returning twenty times the adoption fee rather than the 20% deposit, and also lacks the explicit Decimal typing.Community Comment Notes
The single community comment available for this item simply restated the verdict, answering "D. Decimal('Adoption Fee') * 0.20", with no additional reasoning or counterargument offered. Since no one challenged the cast-based syntax, the community consensus here aligns with the Power Fx documentation rather than adding independent evidence.Official Reference
Exam Strategy
When a Dataverse formula column references a currency or decimal column, look for the option that explicitly casts with Decimal() and uses a decimal multiplier such as 0.20. Percent literals like 20% in Power Fx mean 20 times the value, not 0.20 times, so treat any option containing % as a percentage-math trap.
Frequently Asked Questions
Why can't I just write 'Adoption Fee' * 0.20 for the Deposit formula column?
Adoption Fee is a currency column, so Power Fx formula columns need an explicit cast. Decimal('Adoption Fee') * 0.20 guarantees a correctly typed decimal result.
Why is using 20% as a literal wrong in this Power Fx formula?
In Power Fx, 20% is treated as the number 20, so 'Adoption Fee' * 20% returns 2,000% of the fee. Use 0.20 to represent twenty percent.
Discussion 1 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded.
From public community threads 1
-
exam_upskill 👍 2 Answered DD. Decimal(‘Adoption Fee’) * 0.20
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.