Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.
Choose an answer
Tap an option to check your answer.
Correct answer: WHERE filters with literal (static) values.
Why this is the answer
The correct answer is WHERE filters with literal (static) values because columns in the HIGH and VERY_HIGH aggregation threshold categories are typically derived from dynamic values or calculations that involve aggregation or other query functions. These columns cannot be used directly with WHERE filters that apply static, literal values because their values are not static and are calculated based on the context of the query. For example, a filter that attempts to use a literal value to restrict data based on dynamic aggregations would result in an error or incorrect results. Instead, such columns are intended to be used with more flexible query functions like aggregation or within calculations that adapt to the query context. The other options—aggregation functions, first-party insights, and UNION or JOIN functions—do not inherently conflict with the use of HIGH and VERY_HIGH threshold categories in the same way.
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