Practice More Questions From: BigQuery Architecture
Q:
What is denormalization?
Q:
True or False: BigQuery uses fast cached indexes to increase the performance of your queries
Q:
What are key advantages of storing data in column-oriented storage? (Choose TWO)
Q:
How are BigQuery tables ultimately stored?
Q:
What happens if you have two data analysts running large queries on your Google Cloud Platform account at the same time (assume on-demand tier and each query needs 500 workers)?
Q:
Which of these characteristics of BigQuery workers (slots) is true? (Select THREE)
Q:
How do workers (also known as “slots”) talk to each other to share data?
Q:
True or False: ARRAYs and STRUCTs are concepts unique to BigQuery
Q:
True or False: An ARRAY can have multiple different types of data stored inside of it (e.g. [string,integer,string])
Q:
True or False: An ARRAY can be of type STRUCT
Q:
True or False: A STRUCT can have ARRAYs as data type values
Q:
What does the statement “BigQuery in #standardsql mode implicitly flattens arrays” mean?
Q:
What is the SQL command to break apart an array’s elements into individual rows to operate over each row?
Q:
What is NOT a benefit of nested and repeated fields?
Q:
True or False: When writing your query, the CROSS JOIN syntax can actually be short handed by the comma ‘,’ instead
Subscribe
0 Comments