Google Exam Professional Data Engineer Topic 6 Question 69 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 69
Topic #: 6

[All Professional Data Engineer Questions]

What are two of the benefits of using denormalized data structures in BigQuery?

AReduces the amount of data processed, reduces the amount of storage required

BIncreases query speed, makes queries simpler

CReduces the amount of storage required, increases query speed

DReduces the amount of data processed, increases query speed

Show Suggested Answer

Suggested Answer: C

by Tegan at Apr 19, 2023, 11:02 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

Roslyn

18 days ago

Wait, so denormalization is like the BigQuery version of a cheat code? Sign me up!

upvoted 0 times

...

Blossom

23 days ago

Option D is close, but I think C is the better answer. Reducing data processed and increasing speed - that's the sweet spot for denormalization.

upvoted 0 times

...

Hui

25 days ago

Hmm, I'm not sure I fully understand the benefits of denormalization. But hey, at least it's not as confusing as trying to figure out the optimal number of shards in a BigQuery table!

upvoted 0 times

...

Carin

1 months ago

I agree, C is the way to go. Denormalized data structures are all about trading off storage for speed, and that's exactly what this question is asking about.

upvoted 0 times

...