Crucial Exams

GCP Professional Data Engineer Practice Question

Your analytics team maintains a 5-TB orders fact table that grows by about 50 million rows each day. Looker Studio dashboards repeatedly aggregate monthly revenue by region and product category for the last 24 months. Results must load in seconds and show new data within 30 minutes while keeping BigQuery costs low. Which solution best satisfies these requirements?

  • Purchase a BI Engine reservation on the orders table; BI Engine will automatically serve the monthly revenue without making any other changes.

  • Replace the dashboard SQL with a standard view; BigQuery will automatically reuse cached results as long as the SQL text is unchanged.

  • Schedule a nightly batch job that writes the monthly aggregates to a separate BigQuery table and point the dashboards at that table.

  • Create a BigQuery materialized view that performs the monthly revenue aggregation and rely on its automatic incremental refresh and query-rewrite capabilities so dashboards read the precomputed 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