Salesforce Certified Advanced Administrator — Question 44

The administrator at Universal Containers wants to improve data quality by ensuring that all accounts have a Billing State/Province based upon the Billing Postal
Code for that account.
Which two solutions can meet the requirement? (Choose two.)

Answer options

• A. Use a trigger that populates Billing State/Province based on a custom object that maps postal codes to states/provinces
• B. Use a validation rule to do a VLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces
• C. Use a workflow that populates Billing State/Province based on a custom object that maps postal codes to states/provinces
• D. Use a validation rule to do an HLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces

Correct answer: A, B

Explanation

Option A is correct because a trigger can automate the process of populating the Billing State/Province based on a mapping of postal codes, ensuring data consistency. Option B is also correct as a validation rule using VLOOKUP can validate and enforce the correct state/province based on the postal code. Options C and D are incorrect because workflows cannot update fields based on criteria in the same way triggers can, and HLOOKUP is not applicable in this scenario compared to VLOOKUP.