What are two methods that can be used to denormalize tables in BigQuery?
A) 1) Split table into multiple tables; 2) Use a partitioned table
B) 1) Join tables into one table; 2) Use nested repeated fields
C) 1) Use a partitioned table; 2) Join tables into one table
D) 1) Use nested repeated fields; 2) Use a partitioned table

Question

Quizplus · Accepted Answer

Denormalization in BigQuery can be achieved by joining tables into one table to reduce the number of joins needed during queries, and by using nested repeated fields to store related data together in a single table.

What Are Two Methods That Can Be Used to Denormalize