BigQuery quiz

Test your BigQuery knowledge with a free interactive quiz — 50 questions with answers and explanations. No signup needed to play.

What does BigQuery's automatic query results cache do?

1. What does BigQuery's automatic query results cache do?
2. What does UNNEST() do in a BigQuery query?
3. What does the bq CLI command `bq query --dry_run` do?
4. What is a BigQuery external table?
5. What kind of metadata does the INFORMATION_SCHEMA set of views expose in BigQuery?
6. What is BigQuery?
7. What does querying a wildcard table like `FROM `my_project.logs.events_2026*`` do?
8. What is the purpose of a materialized view in BigQuery?
9. What is the organizational hierarchy in BigQuery?
10. What is the purpose of BigQuery ML's CREATE MODEL statement?
11. What does SELECT * cost more than a narrower SELECT in BigQuery?
12. What SQL data types does BigQuery provide for modeling nested, one-to-many relationships without a join?

More quizzes