Google Cloud Professional Data Engineer PDE — Topic 1 Question 310

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Create a materialized view based off of the query being run.

Google Cloud Professional Data Engineer PDE — Question 310