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?
To enforce that a trail record's Effort_Level__c field set to Rigorous requires the distance to be 10 miles or more and the time to complete to be 5 hours or more, the validation rule should trigger an error if either the distance is less than 10 miles or the time is less than 5 hours. The correct validation rule is 'AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), Distance__c < 10, Time_to_Complete__c < 5)' because this rule becomes true when the distance is less than 10 miles or the time to complete is less than 5 hours, thereby enforcing the required conditions.
The correct answer is D AND(ISPICKVAL(Effort_Level__c, ‘Rigorous’), Distance__c < 10, Time_to_Complete__c < 5) Validation will trigger when the formula validates to true! To make sure the distance is greater than 10 and time to complete more than 5 formula must check if values are less than these numbers and trigger the validation.
It's B, no? If one of the values is correct (Distance more than 10 or Time to complete > 5) the D option returns False, then the Validation Rule is not triggering. At B option when one of the 2 values is incorrect the VR returns true, so the error is triggering correctly.
If one of the values is correct (Distance more than 10 or Time to complete > 5) the D option returns False, then the Validation Rule is not triggering. At B option when one of the 2 values is incorrect the VR returns true, so the error is triggering correctly.
there will be error if one of those turn out to be true. Its Validation!
id rather go with D, the conditions are joined with AND