Google Exam Professional Data Engineer Topic 6 Question 35 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 35
Topic #: 6

[All Professional Data Engineer Questions]

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?

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

Show Suggested Answer

Suggested Answer: C

by Mariann at May 04, 2022, 02:54 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!