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 9 months, 1 week 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 8 months ago

Selected Answer: D

Option D. Materialized view

upvoted 1 times

...

Sofiia98

9 months ago

Selected Answer: D

materialized view

upvoted 1 times

...

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 310 discussion

Comments

AllenChen123

Shenbasekhar

Sofiia98

SY0-701