Google Cloud Professional Data Engineer — Question 257

Your retail company is concerned about their BigQuery analytics spend. The company runs several queries that require the use of the same aggregation for the store ID and real-time sales volume. You need to implement the optimal solution that minimizes analytics spend and returns faster results. What should you do?

Answer options

• A. Create a new table from a CSV file with the repeated aggregation for the other queries to reference for faster processing.
• B. Create a materialized view to minimize repetitive computations.
• C. Use join acceleration with primary and foreign keys to increase query joining to live data.
• D. Leverage partitioning to minimize the number of bytes read.

Correct answer: B

Explanation

The correct answer is B, as creating a materialized view allows for the storage of precomputed results, leading to reduced computation time during queries. Options A and C do not address the need for minimizing repetitive calculations effectively, while option D focuses on reducing data read but does not optimize the computation process itself.