Google Exam Professional-Data-Engineer Topic 6 Question 77 Discussion

Actual exam question for Google's Google Cloud Certified Professional Data Engineer exam

Question #: 77
Topic #: 6

[All Google Cloud Certified Professional Data Engineer Questions]

You need to look at BigQuery data from a specific table multiple times a day. The underlying table you are querying is several petabytes in size, but you want to filter your data and provide simple aggregations to downstream users. You want to run queries faster and get up-to-date insights quicker. What should you do?

ARun a scheduled query to pull the necessary data at specific intervals daily.

BCreate a materialized view based off of the query being run.

CUse a cached query to accelerate time to results.

DLimit the query columns being pulled in the final result.

Show Suggested Answer

Suggested Answer: B

Materialized views are precomputed views that periodically cache the results of a query for increased performance and efficiency. BigQuery leverages precomputed results from materialized views and whenever possible reads only changes from the base tables to compute up-to-date results. Materialized views can significantly improve the performance of workloads that have the characteristic of common and repeated queries. Materialized views can also optimize queries with high computation cost and small dataset results, such as filtering and aggregating large tables. Materialized views are refreshed automatically when the base tables change, so they always return fresh data. Materialized views can also be used by the BigQuery optimizer to process queries to the base tables, if any part of the query can be resolved by querying the materialized view.Reference:

Introduction to materialized views

Create materialized views

BigQuery Materialized View Simplified: Steps to Create and 3 Best Practices

Materialized view in Bigquery

by Jani at Feb 07, 2024, 06:56 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nina

8 days ago

You know, I was about to suggest the column limiting option, but after hearing you all, I think the materialized view is the way to go. It's like having a personal assistant for your data - they do all the heavy lifting so you can just sit back and enjoy the results.

upvoted 0 times

...

Asha

9 days ago

Ooh, good point. I was thinking about the cached query option, but a materialized view is probably more robust. Plus, it'll free up our time to focus on other important tasks instead of waiting for those massive queries to run.

upvoted 0 times

...

Buffy

10 days ago

I agree, a materialized view seems like the way to go. With a table that size, we need to be proactive about optimizing our queries. And B gives us the added benefit of keeping the data fresh without having to run a full query every time.

upvoted 0 times

...

Kerry

11 days ago

Hmm, this is a tricky one. The table is massive, so we need to be smart about how we access the data. A scheduled query could work, but it might not give us the most up-to-date insights. I'm leaning towards option B - creating a materialized view. That way, we can preload the data we need and get faster results.

upvoted 0 times

...