272 questions with instant explanations, domain breakdown, and wrong-answer analysis. Built for the real exam.
This is exactly what you see during practice — question, options, and a full explanation after you answer.
You are building a Looker dashboard and need to calculate the year-over-year growth rate. Which feature should you use to perform this without modifying the underlying SQL?
Looker Table Calculations allow you to create calculations (such as year-over-year growth) directly in the Explore or dashboard using Looker's expression language, without modifying the underlying SQL or LookML. They operate on the query results already returned, so you can compu…Read full explanation
You are analyzing query performance in BigQuery. You notice that your queries are spilling to disk. What is the most likely cause?
Spilling to disk in BigQuery occurs when a query's intermediate results exceed the memory available to the execution stage. This typically happens due to inefficient JOINs or GROUP BY operations that produce large intermediate datasets, forcing BigQuery to write data to disk (shu…Read full explanation
You are identifying trends in a large dataset using BigQuery. Which SQL function is best suited to identify the top 5 products sold per region?
RANK() OVER (PARTITION BY region ORDER BY sales DESC) assigns a rank to each product within each region based on sales, so filtering for rank <= 5 yields the top 5 products per region. This is the standard SQL window-function pattern for per-group top-N queries.
Questions are tagged by exam domain. Practice a specific domain or mix them all.
Answer at your own pace. Explanation and domain tag shown immediately after each answer.
Countdown timer starts immediately. Results and domain scores shown at the end — just like the real exam.
Full explanations on every question
Not just the right answer — you get exactly why each wrong option is wrong, so you learn the concept, not the answer.
Domain score breakdown
After each session see your score by exam domain so you know exactly where to focus study time.
100% free, forever
No subscription, no trial, no email wall. Start a session in under 10 seconds.
Exam-style questions
Scenario-based, precise wording, realistic distractors — written to match what you actually see on exam day.