Trang chủ Professional Data Engineer 336 / 343
Quay lại bộ đề
Question #336 Topic 1
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?
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.