Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 14 of 27
Free Preview · 27 of 90 · questions 1–27 of 90 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The best option is A. Create a materialized view in BigQuery that uses the SUM( ) function and the DATE_SUB( ) function. Materialized views provide the efficiency of pre-computation, automatic updates, and are directly usable in Looker Studio, making them the ideal choice for creating an automated and performant monthly inventory report. Options B, C, and D are either manual, technically inaccurate in their description, or less efficient than leveraging the power of materialized views for this reporting task.