Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes. Which two actions should Cloud Kicks take to improve data quality? (Choose two.)
A.
Change each address field to required on the Page Layout.
B.
Write an Apex Trigger to require all fields to be populated.
C.
Utilize a Validation Rule with a REGEX operator on Postal Code.
D.
Utilize a Validation Rule with a CONTAINS operator on address fields.
C.
Utilize a Validation Rule with a REGEX operator on Postal Code.
D.
Utilize a Validation Rule with a CONTAINS operator on address fields.
Explanation:
REGEX (C) enforces postal code formatting (e.g., \d{5} for US ZIPs).
CONTAINS (D) ensures critical fields (e.g., State) are populated by checking for blanks.
Why not others?
A (Required fields): Forces input but doesn’t validate formatting.
B (Apex trigger): Overkill; declarative tools suffice.
Validation rules block invalid data at entry:
REGEX(Postal_Code__c, '[0-9]{5}') // Validates 5-digit ZIP
CONTAINS(State__c, "CA|NY|TX") // Ensures valid state