Salesforce Certified Advanced Administrator — Question 10

Universal Containers wants to ensure that the following opportunity fields are present on each record at the negotiation/review or won stages:
* Amount (Currency) is populated.
* The Ready to Close (Checkbox) must also be true.
Which validation rule error condition should the administrator configure to meet these requirements?

Answer options

• A. AND(OR(StageName = "Negotiation/Review", StageName = "Closed Won"),OR(ISBLANK( Amount ),Ready_to_Close__c = FALSE))
• B. AND(OR(StageName = "Negotiation/Review", StageName = "Closed Won"),OR(ISBLANK( Amount ),Ready_to_Close__c = TRUE))
• C. AND(OR(ISPICKVAL(StageName, "Negotiation/Review"), ISPICKVAL(StageName, "Closed Won")),OR(ISBLANK( Amount ),Ready_to_Close__c = FALSE))
• D. AND(OR(ISPICKVAL(StageName, "Negotiation/Review"), ISPICKVAL(StageName, "Closed Won")),OR(NOT(ISBLANK( Amount )),Ready_to_Close__c = TRUE))

Correct answer: C

Explanation

Option C is correct because it checks if the stage is either 'Negotiation/Review' or 'Closed Won' and ensures that the Amount field is blank or the 'Ready to Close' checkbox is false, which meets the requirement. Options A and B incorrectly evaluate the checkbox condition, while option D fails to check the Amount field correctly as it allows non-blank amounts when it should enforce that it must be filled.