Question 254 of 307
Single answerYou 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 dally.
BUse a cached query to accelerate time to results.
CLimit the query columns being pulled in the final result.
✓DCreate a materialized view based off of the query being run.
✓
Correct Answer: D
Create a materialized view based off of the query being run.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.