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 return? SELECT customer.name, li.sku FROM `sales.orders` AS o, UNNEST(o.line_items) AS li

1. What does the following query return? SELECT customer.name, li.sku FROM `sales.orders` AS o, UNNEST(o.line_items) AS li
2. What is BigQuery?
3. What is the main difference between a BigQuery table and a BigQuery view?
4. What does the LOAD DATA statement (or a load job) do?
5. What SQL data types does BigQuery provide for modeling nested, one-to-many relationships without a join?
6. What does BigQuery's automatic query results cache do?
7. How does on-demand BigQuery pricing primarily work?
8. What is the purpose of a materialized view in BigQuery?
9. What does the bq CLI command `bq query --dry_run` do?
10. What does SELECT * cost more than a narrower SELECT in BigQuery?
11. What is the purpose of BigQuery ML's CREATE MODEL statement?
12. Which of these query patterns will generally reduce the bytes scanned (and cost) of a query on a large table?

More quizzes