Answer-first summary for fast verification
Answer: Materialized views
A. Incorrect. Views rerun the query each time on the source data; therefore, is not optimal. B. Correct. Materialized views will improve query performance by precomputing and periodically caching query results. C. Incorrect. Federated queries are not optimal, because they are used to query data that is stored outside BigQuery. D. Incorrect. Partitions can improve the query performance by only scanning a portion of a table. However, scanning a portion of the table might not suit the business need in this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.