Salesforce Certified Platform App Builder — Question 402
Northern Trail Outfitters wants to ensure that if a trail record’s Effort_Level__c field is set to Rigorous, then the distance of the trail is 10 miles or more and the time to complete is 5 hours or more.
Which validation rule should enforce this criteria?
Answer options
- A. AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), OR(Distance__c > 10, Time_to_Complete__c > 5))
- B. AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), OR(Distance__c < 10, Time_to_Complete__c < 5))
- C. AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), Distance__c > 10, Time_to_Complete__c > 5)
- D. AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), Distance__c < 10, Time_to_Complete__c < 5)
Correct answer: D
Explanation
The correct option is C, which correctly checks that if the Effort_Level__c is Rigorous, then both Distance__c must be greater than 10 and Time_to_Complete__c must be greater than 5. Options A and B incorrectly use OR conditions that do not meet the requirement, while option D incorrectly states that both Distance__c and Time_to_Complete__c should be less than the specified values.