How can you determine if NULL values are the result of aggregation thresholds or a natural occurrence within your report?
Choose an answer
Tap an option to check your answer.
Correct answer: Use the Append aggregation threshold columns option in the Query editor.
Why this is the answer
The "Append aggregation threshold columns" option in the Query editor is the correct method because it explicitly adds columns to your query output that indicate whether a NULL value is due to aggregation thresholds. If a NULL appears in a column where the threshold indicator is also NULL, it suggests a natural absence of data. If the threshold indicator shows a value (e.g., "Suppressed due to aggregation"), then the NULL is a result of data suppression for privacy. Running the report multiple times is inefficient and doesn't definitively distinguish between natural NULLs and suppressed NULLs. NULL values can occur naturally in reports (e.g., a customer didn't make a purchase), so stating they don't occur naturally unless the query is invalid is incorrect.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed