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

1 months ago

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

upvoted 0 times

Elizabeth

12 days ago

D) Reduces the amount of data processed, increases query speed

upvoted 0 times

...

Irma

14 days ago

C) Reduces the amount of storage required, increases query speed

upvoted 0 times

...

Micah

17 days ago

A) Reduces the amount of data processed, reduces the amount of storage required

upvoted 0 times

...

Blossom

1 months 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

1 months 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

Bok

23 hours ago

Yeah, denormalization can definitely help with reducing storage and speeding up queries.

upvoted 0 times

...

Diane

2 days ago

C) Reduces the amount of storage required, increases query speed

upvoted 0 times

...

Jamal

5 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

...

Jaime

6 days ago

A) Reduces the amount of data processed, reduces the amount of storage required

upvoted 0 times

...

Gayla

8 days ago

C) Reduces the amount of storage required, increases query speed

upvoted 0 times

...

Tula

15 days ago

A) Reduces the amount of data processed, reduces the amount of storage required

upvoted 0 times

...

Carin

2 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