Salesforce Certified Advanced Administrator — Question 162

The finance director at Cloud Kicks asks the administrator for an exception report that shows all B2C accounts that are missing the credit card number. The credit card number is a classic encrypted field.

What action should the administrator take to meet this requirement?

Answer options

• A. Add 'View Encrypted Fields' to a permission set assigned to Finance and system administrators and a summary report filtered by credit card number.
• B. Create a summary report that includes a cross-filter to the Account object with a sub-filter for credit card number equal to null.
• C. Build a custom checkbox called 'Has Credit Card' that Finance checks when a credit card is recorded and a tabular report filtered on the checkbox equal to false.
• D. Unmask the encrypted credit card number field to make it available and add a custom filter to a report where credit card number is blank.

Correct answer: C

Explanation

The correct answer, C, allows the finance team to track whether a credit card has been recorded using a checkbox, making it easy to filter for accounts without a credit card. Options A, B, and D are not suitable because they either attempt to access the encrypted field directly or do not provide a straightforward method for identifying accounts missing credit card information.