Salesforce Certified Advanced Administrator — Question 26

Universal Containers has a Positions object that represents Job Positions and a Job Applications object that represent people that have applied to the Position.
The Job Application object has a lookup to Position. They want to run a report that shows all Positions that do NOT have any child Job Applications.
Which solution would meet the requirements?

Answer options

• A. Use the standard Job Applications with Position report type.
• B. Use a custom report type that only displays Job Applications without Positions.
• C. Use the standard Position without Job Applications report type.
• D. Use the standard Position report type with a cross filter.

Correct answer: D

Explanation

The correct answer is D, as using a standard Position report type with a cross filter allows you to specifically filter out Positions that do not have any related Job Applications. Option A includes Job Applications, which is not what is needed. Option B focuses on Job Applications and would not show the Positions correctly. Option C does not utilize the necessary filtering to identify Positions without applications.