Answer-first summary for fast verification
Answer: How often the materialized views are refreshed, The overall volume of data stored in the materialized views
The frequency of refresh operations and the total data volume stored in materialized views are key factors that can drive up BigQuery costs. Data types used in the views do not influence costs, and while the number of users with read access doesn't directly affect costs, the amount of data scanned by queries does. For more details, refer to [BigQuery Materialized Views Documentation](https://cloud.google.com/bigquery/docs/materialized-views-intro).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When using materialized views in BigQuery, you notice higher than expected charges. Which characteristics of materialized views could be contributing to these increased costs? (Select two)
A
The data types utilized within the materialized views
B
How often the materialized views are refreshed
C
The overall volume of data stored in the materialized views
D
The count of users who have read access to the materialized view
No comments yet.