Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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, how should you structure the data to optimize query speed about the authors of borrowed books, adhering to Google's schema design best practices?
A
Maintain the current schema with separate tables for books and their attributes, continuing to query as before.
B
Design a wide table with columns for each attribute, such as the author's first name, last name, and date of birth.
C
Construct a table that combines 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.