Answer-first summary for fast verification
Answer: Construct a table with book and author information, nesting author details within an author column.
Best practice suggests using nested and repeated fields for denormalizing data storage to enhance query performance. This approach is particularly effective for hierarchical relationships that are often queried together, such as parent-child relationships. Denormalization is a recommended strategy for improving read performance in previously normalized relational datasets. Reference: [Google Cloud BigQuery Documentation](https://cloud.google.com/bigquery/docs/best-practices-performance-nested).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When migrating an application that tracks library books and their details (like author or publication year) from an on-premises data warehouse to BigQuery, what schema design should you adopt to optimize query speed for author information of borrowed books, adhering to Google's best practices?
A
Maintain the current schema with separate tables for books and attributes, querying as usual.
B
Design a wide table with a column for each attribute, including detailed author information.
C
Construct a table with book and author information, nesting author details within an author column.
D
Retain the existing schema but create a view that joins all tables, and consistently query this view.
No comments yet.