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?

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

Callie

4 months ago

Wait, can you really nest like that in BigQuery? Sounds odd!

upvoted 0 times

...

Danica

4 months ago

Really? Nesting might complicate things more than help.

upvoted 0 times

...

Diane

4 months ago

I agree with C, it should speed up queries for authors.

upvoted 0 times

...

Alberto

4 months ago

Not sure about that, option B seems more straightforward.

upvoted 0 times

...

Marcelle

5 months ago

I think option C is the way to go! Nesting makes sense for BigQuery.

upvoted 0 times

...

Van

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...