Exam Professional Data Engineer topic 1 question 310 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 310
Topic #: 1

[All 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?

A. Run a scheduled query to pull the necessary data at specific intervals dally.
B. Use a cached query to accelerate time to results.
C. Limit the query columns being pulled in the final result.
D. Create a materialized view based off of the query being run.

Show Suggested Answer

Suggested Answer: D 🗳️

by AllenChen123 at Jan. 26, 2024, 12:53 a.m.

Comments

Submit Cancel

AllenChen123

Highly Voted 10 months, 3 weeks ago

Selected Answer: D

Create a materialized view as query source. Materialized views are precomputed views that periodically cache the results of a query for increased performance and efficiency.

upvoted 7 times

...

Shenbasekhar

Most Recent 9 months, 3 weeks ago

Selected Answer: D

Option D. Materialized view

upvoted 1 times

...

Sofiia98

10 months, 2 weeks ago

Selected Answer: D

materialized view

upvoted 1 times

...