Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have data in PostgreSQL that was designed to reduce redundancy. You are transferring this data to BigQuery for analytics. The source data is hierarchical and frequently queried together. You need to design a BigQuery schema that is performant.
A
Use nested and repeated fields.
B
Retain the data in normalized form always.
C
Copy the primary tables and use federated queries for secondary tables.
D
Copy the normalized data into partitions.
