Which action can be used to determine if NULL values are a natural occurrence within your report or the result of aggregation thresholds?
Choose an answer
Tap an option to check your answer.
Correct answer: Using 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 adds specific columns to your query results that indicate whether a row's data was suppressed due to aggregation thresholds. This allows you to directly identify if NULL values are due to data suppression rather than naturally missing data. Running the report multiple times might show variance, but it doesn't definitively explain the cause of NULLs. Checking aggregation thresholds in the Schema explorer only shows the settings for thresholds, not their impact on a specific query's output.
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