Intermediate Google BigQuery test (Intermediate)
30 questions · 35 minutes · Free
Partitioning, clustering, nested data and scheduled queries in BigQuery.
Take the Intermediate Google BigQuery test
What it covers
- Partitioned tables
- Clustered tables
- Nested and repeated fields (STRUCT, ARRAY)
- Views, materialized views and scheduled queries
- Streaming inserts and the Storage Write API
Interview format
- Questions: 30 questions — 18 multiple choice, 9 multi-answer, 3 predict-the-output
- Time: 35 minutes, timed from the first question
- Difficulty: Intermediate
- Skill area: Data
- Price: Free
Earn a certificate
The Intermediate Google BigQuery test is one of the 8 tests of the Cloud Data Engineer: Intermediate learning path. Pass it and the other 7 tests at 70% or more and readyforhires issues you a verifiable certificate in your name, with its own code and verify link to share or add to LinkedIn.
Frequently asked questions
- How many questions are in the Intermediate Google BigQuery test?
- 30 questions (18 multiple choice, 9 multi-answer, 3 predict-the-output), with 35 minutes to answer them.
- What does the Intermediate Google BigQuery test cover?
- Partitioned tables, Clustered tables, Nested and repeated fields (STRUCT, ARRAY), Views, materialized views and scheduled queries, Streaming inserts and the Storage Write API.
- Is the Intermediate Google BigQuery test free?
- Yes. It is free to take with a readyforhires account.
- What level is the Intermediate Google BigQuery test?
- Intermediate, in Data.