BigQuery quiz

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

What does the following query do? SELECT order_id FROM `my_project.sales.orders` WHERE order_date = CURRENT_DATE()

1. What does the following query do? SELECT order_id FROM `my_project.sales.orders` WHERE order_date = CURRENT_DATE()
2. What does a scheduled query in BigQuery do?
3. What does SELECT * cost more than a narrower SELECT in BigQuery?
4. What is a BigQuery dataset?
5. What is a BigQuery view?
6. What SQL data types does BigQuery provide for modeling nested, one-to-many relationships without a join?
7. Which of these is a valid reason to choose BigQuery over a traditional relational database for a workload?
8. What does the LOAD DATA statement (or a load job) do?
9. What kind of metadata does the INFORMATION_SCHEMA set of views expose in BigQuery?
10. What does the following query return? SELECT customer.name, li.sku FROM `sales.orders` AS o, UNNEST(o.line_items) AS li
11. What does querying a wildcard table like `FROM `my_project.logs.events_2026*`` do?
12. What does the bq CLI command `bq query --dry_run` do?

More quizzes