Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 19 Topic 2 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 19 Topic 2 Discussion

Professional-Data-Engineer Exam Topic 2 Question 19 Discussion:
Question #: 19
Topic #: 2

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?


A.

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


B.

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


C.

Use a cached query to accelerate time to results.


D.

Limit the query columns being pulled in the final result.


Get Premium Professional-Data-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.