Salesforce Certified Advanced Administrator — Question 142

The VP of Marketing is launching campaigns in each region to target accounts that do NOT have open opportunities.
Which reporting solution can an administrator set up to assist with this?

Answer options

• A. Standard filter
• B. Cross filter
• C. Joined report
• D. Reporting snapshot

Correct answer: B

Explanation

A Cross filter allows users to refine their report by specifying conditions on related objects, which is essential for isolating accounts without open opportunities. The other options, while useful in different contexts, do not provide the same level of specificity needed to filter out accounts lacking open opportunities.