BigQuery Partitioning and Clustering Quiz

1. What is the maximum number of partitions allowed in a BigQuery table?

1000

10000

100000

Unlimited

2. Which BigQuery feature allows you to specify which partitions to scan in a query?

Partition elimination

Cluster pruning

Partition specification

Query routing

3. True or False: Partition expiration can automatically delete old data based on partition age.

True

False

Submit

5. Which scenario best justifies using integer range partitioning?

Partitioning by user IDs in ranges (0-1M, 1M-2M)

Partitioning by date

Partitioning by string values

Partitioning by floating-point numbers

6. True or False: Partitioning and clustering can be used together on the same table.

True

False

Submit

8. Which approach is most cost-effective for a fact table with 50+ GB added daily?

No partitioning or clustering

Daily time-unit partitioning only

Clustering on 4 high-cardinality columns

Both daily partitioning and clustering

9. True or False: You can modify clustering columns on an existing table without recreating it.

True

False

Submit

11. Which partition type in BigQuery automatically splits data based on ingestion time?

Time-unit column partitioning

_PARTITIONTIME pseudo-column

Integer range partitioning

Custom partition pruning

12. Which data type is NOT supported for partitioning in BigQuery?

DATE

TIMESTAMP

ARRAY

INTEGER

13. True or False: Clustering columns must be selected from the partition key columns.

True

False

Submit

15. Which statement about partition pruning is correct?

It requires manual query rewriting

BigQuery automatically skips partitions that don't match the WHERE clause

It only works with integer partitions

It increases query costs

16. True or False: Clustering guarantees that all data is physically stored in sorted order across all nodes.

True

False

Submit

18. Which of the following is NOT a valid partition type in BigQuery?

Time-unit column partitioning

Integer range partitioning

Hash-based partitioning

Ingestion time partitioning

19. How many clustering columns can you define on a BigQuery table?

1

4

Up to 4

Unlimited

20. What is the primary benefit of clustering in BigQuery?

Reduces storage costs by 50%

Improves query performance by organizing data in sorted order

Automatically backs up all data

Eliminates the need for indexes

Google Data Engineer BigQuery Partitioning and Clustering Quiz

1. What is the maximum number of partitions allowed in a BigQuery table?

2.

What first name or nickname would you like us to use?

2. Which BigQuery feature allows you to specify which partitions to scan in a query?

3. True or False: Partition expiration can automatically delete old data based on partition age.

4. Clustering columns should be ordered by____cardinality for optimal performance.

5. Which scenario best justifies using integer range partitioning?

6. True or False: Partitioning and clustering can be used together on the same table.

7. The _____column is a pseudo-column that represents ingestion time in BigQuery.

8. Which approach is most cost-effective for a fact table with 50+ GB added daily?

9. True or False: You can modify clustering columns on an existing table without recreating it.

10. Clustering improves query performance by creating____blocks within each partition.

11. Which partition type in BigQuery automatically splits data based on ingestion time?

12. Which data type is NOT supported for partitioning in BigQuery?

13. True or False: Clustering columns must be selected from the partition key columns.

14. For a table with 100 GB of data partitioned daily, how many partitions exist over a 100-day period?

15. Which statement about partition pruning is correct?

16. True or False: Clustering guarantees that all data is physically stored in sorted order across all nodes.

17. Partitioning in BigQuery is useful for improving query performance and____.

18. Which of the following is NOT a valid partition type in BigQuery?

19. How many clustering columns can you define on a BigQuery table?

20. What is the primary benefit of clustering in BigQuery?