Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
A business intelligence team uses Looker Studio to query a 600 GB partitioned and clustered sales dataset stored in BigQuery. Users report that interactive dashboard filters on recent summary metrics (last 30 days, totaling ~20 GB) perform with sub-second response times, but ad-hoc multi-year queries spanning the full 600 GB dataset experience significant latency due to queries partially falling back to standard BigQuery slot execution.
You have a 30 GB BigQuery BI Engine reservation provisioned in the project. You need to ensure consistent, sub-second query performance across both dashboard filters and broader historical aggregation queries while minimizing BI Engine reservation costs.
What should you do?
BigQuery scheduled queries execute SQL statements on a recurring schedule (e.g., hourly) and write the output into dedicated summary tables.
The business only required static batch reports generated once per day without interactive filtering or sub-second latency needs.
Cloud Bigtable is a managed NoSQL database designed for high-throughput, low-latency key-value lookups. BigQuery supports querying Bigtable via external federated tables.
The workload consisted primarily of real-time single-row lookups based on a known row key with millisecond latency requirements.
BigQuery BI Engine is a fully managed, in-memory analysis service that accelerates SQL queries by caching frequently queried data in memory and using a vectorized execution engine. When paired with Materialized Views, BI Engine automatically accelerates pre-aggregated summaries without requiring massive memory allocations.
Increasing the BI Engine reservation to match the full table size allocates sufficient in-memory capacity to cache all raw partitions across the entire dataset.
Every ad-hoc query strictly required sub-second access to raw, unaggregated, row-level details across all 600 GB of historical data without budget constraints.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated