GCP-ADP Data Analysis And Presentation Practice Question
When optimizing a Looker model, you want to prevent users from accidentally running very expensive queries. Which parameter should you use in LookML?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
sql_always_where
The 'sql_always_where' parameter forces a filter on every query, which is an effective guardrail for cost and performance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
query_limit
Why it's wrong here
While query_limit sets a limit on results, it is a less robust tool for forcing specific filter conditions.
- ✗
access_filter
Why it's wrong here
Access filters are for data security (limiting rows per user), not specifically for preventing expensive queries.
- ✗
always_filter
Why it's wrong here
This prompts the user to apply a filter but doesn't force a hard restriction like sql_always_where.
- ✓
sql_always_where
Why this is correct
This ensures a filter is applied to every query generated by the Explore.
About these practice questions
Courseiva writes every GCP-ADP question from scratch — 205 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Google Cloud exam blueprint
This GCP-ADP practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the GCP-ADP exam.