You are in charge of optimizing a BigQuery workflow for a data analytics team. The team performs frequent queries on a 500GB dataset. To improve performance and reduce costs, what would be the best practice?
Choose an answer
Tap an option to check your answer.
Correct answer: Use BigQuery Materialized Views.
Why this is the answer
*Explanation:* The best practice to improve performance and reduce costs when working with a 500GB dataset in BigQuery is to **use BigQuery Materialized Views (option C. **. Materialized views store precomputed results of a query, improving performance and reducing costs for frequent queries. Options A, B, D, and E do not directly address the goal of optimizing query performance and cost.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed