Salesforce Certified Platform App Builder — Question 432

Universal Containers (UC) utilizes two custom picklist fields called Sales_Organization__c and Pricing_Tier__c.

Which validation rule should an app builder use to ensure Pricing_Tier__c is required for customers with a Sales_Organization__c value of Canada?

Answer options

• A. AND(ISPICKVAL(Sales_Organization__c,‘Canada’),ISBLANK(TEXT(Pricing_Tier__c)))
• B. ISPICKVAL(Sales_Organization__c,‘Canada’) && ISNULL(Pricing_Tier__c)
• C. IF(ISNULL(Sales_Organization__c=‘Canada’,ISBLANK(TEXT(Pricing_Tier__c)),TRUE)
• D. OR(ISPICKVAL(Sales_Organization__c,‘Canada’),ISBLANK(TEXT(Pricing_Tier__c)))

Correct answer: A

Explanation

The correct answer, A, uses the AND function to check if Sales_Organization__c is 'Canada' and if Pricing_Tier__c is blank, enforcing the requirement accurately. Option B incorrectly uses ISNULL instead of ISBLANK, which does not work for picklists. Option C has syntax issues and does not properly validate the condition. Option D incorrectly allows for the scenario where Pricing_Tier__c can be blank if Sales_Organization__c is 'Canada', which is not the requirement.