Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 6 Question 35 Discussion

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?
C) Create a table that includes information about the books and authors, but nest the author fields inside the author column
A) Keep the schema the same, maintain the different tables for the book and each of the attributes, and query as you are doing today
B) Create a table that is wide and includes a column for each attribute, including the author's first name, last name, date of birth, etc
D) Keep the schema the same, create a view that joins all of the tables, and always query the view

Google Professional Data Engineer Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Callie
7 months ago
Wait, can you really nest like that in BigQuery? Sounds odd!
upvoted 0 times
...
Danica
7 months ago
Really? Nesting might complicate things more than help.
upvoted 0 times
...
Diane
8 months ago
I agree with C, it should speed up queries for authors.
upvoted 0 times
...
Alberto
8 months ago
Not sure about that, option B seems more straightforward.
upvoted 0 times
...
Marcelle
8 months ago
I think option C is the way to go! Nesting makes sense for BigQuery.
upvoted 0 times
...
Van
8 months ago
I feel like option D could work, but it seems like querying a view might not be as efficient as directly accessing a well-structured table. I need to think more about that.
upvoted 0 times
...
Mauricio
8 months ago
I’m a bit confused about whether creating a wide table is really the best practice. I thought denormalization was encouraged in BigQuery, but I’m not confident.
upvoted 0 times
...
German
8 months ago
I remember practicing a similar question, and I feel like keeping the schema the same might not be optimal for BigQuery. So, I would lean towards option B or C.
upvoted 0 times
...
Clay
8 months ago
I think option C makes sense because nesting the author fields could improve query performance, but I'm not entirely sure if it's the best approach.
upvoted 0 times
...
Anglea
8 months ago
This seems like a tricky one. I'll need to carefully review the details and think through the legal principles involved.
upvoted 0 times
...
Tiera
8 months ago
I'm pretty confident I know the right answer here. Based on the requirements, the consultant should recommend using Campaign Influence to track the impact of marketing campaigns on Opportunities and revenue.
upvoted 0 times
...
Trina
8 months ago
Hmm, I'm not sure about this one. The question is asking about making storage space available on a Windows Phone 8.1 device, but the options don't seem to match what I know about that.
upvoted 0 times
...
Helga
8 months ago
Binary reuse is all about consistency and efficiency, so I'm going to focus on the answers that highlight those advantages, like ensuring the same version is used and enabling a shorter cycle time.
upvoted 0 times
...

Save Cancel