Google Cloud Professional Data Engineer PDE — Topic 1 Question 339

Question

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Create a materialized view to minimize repetitive computations. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Data Engineer PDE — Question 339