Google
PROFESSIONAL-DATA-ENGINEER · Question #262
You are migrating an application that tracks library books and information about each book, such as author or year published, from an on-premises data warehouse to BigQuery. In your current relational
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #262. The question stem and answer options stay visible for context.
Submitted by fatima_kr· Mar 30, 2026Designing data processing systems
Question
You are migrating an application that tracks library books and information about each book, such as author or year published, from an on-premises data warehouse to BigQuery. In your current relational database, the author information is kept in a separate table and joined to the book information on a common key. Based on Google's recommended practice for schema design, how would you structure the data to ensure optimal speed of queries about the author of each book that has been borrowed?
Options
- AKeep the schema the same, maintain the different tables for the book and each of the attributes, and query as you are doing today
- BCreate a table that is wide and includes a column for each attribute, including the author's first name, last name, date of birth, etc
- CCreate a table that includes information about the books and authors, but nest the author fields inside the author column
- DKeep the schema the same, create a view that joins all of the tables, and always query the view
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery Schema Design#Denormalization#Nested Data Types#Query Optimization