Crucial Exams

GCP Professional Data Engineer Practice Question

Your media company streams millions of click records every minute into an append-only BigQuery table named events_raw that is partitioned by event_date. A Looker Studio dashboard refreshes every minute with a query that aggregates the previous day's clicks by country and referrer. The repeated execution of this aggregation has driven up slot usage and query cost. You must lower cost and latency while leaving both the analysts' SQL and the dashboard configuration unchanged. What should you do?

  • Schedule a daily batch job that writes yesterday's aggregation to a new partitioned table and update all Looker Studio reports to query that table instead of events_raw.

  • Convert events_raw to a clustered table on country and referrer and purchase a BI Engine reservation to keep frequently accessed data in memory.

  • Enable the "Use cached results" option in Looker Studio so identical queries are served from BigQuery's query cache rather than re-executed each minute.

  • Create a materialized view that pre-aggregates yesterday's clicks by country and referrer and keep the dashboard pointing to events_raw so the BigQuery optimizer can automatically rewrite the queries to use the cached results.

GCP Professional Data Engineer
Preparing and using data for analysis
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot