Topic 1 Question 310
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?
Run a scheduled query to pull the necessary data at specific intervals dally.
Use a cached query to accelerate time to results.
Limit the query columns being pulled in the final result.
Create a materialized view based off of the query being run.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: 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.
👍 7AllenChen1232024/07/25 - 正解だと思う選択肢: D
materialized view
👍 1Sofiia982024/08/02 - 正解だと思う選択肢: D
Option D. Materialized view
👍 1Shenbasekhar2024/08/28
シャッフルモード