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 retail company uses Looker to provide interactive executive dashboards over a large BigQuery dataset that receives continuous real-time transaction updates. Business analysts frequently explore the data by applying diverse, dynamic filters and aggregations across various combinations of store locations, product categories, and transaction timestamps.
The engineering team must meet the following requirements:
Which acceleration strategy should the data engineering team implement?
Query result caching stores the exact deterministic output table of a previously executed query for up to 24 hours at zero cost, returning instant results if the identical query is submitted again.
Query caching is best for static, read-only reporting dashboards refreshed once daily where multiple users view identical aggregate summaries.
Materialized views are precomputed views that periodically aggregate and persist query results in BigQuery storage to accelerate recurring, predictable aggregation patterns.
Materialized views are ideal when queries share predictable aggregation keys and mathematical rollups (e.g., daily sales rollups by region) across high-volume, slowly changing base tables.
BigQuery BI Engine is a built-in, distributed in-memory analysis service that accelerates SQL queries by caching frequently accessed data in memory and using an optimized execution engine designed specifically for business intelligence (BI) and dashboard workloads.
FULL_QUERY, FULL_INPUT, and PARTIAL_INPUT acceleration modes to optimize subquery execution automatically.Compared to static caching or manual materialized aggregates, BI Engine excels at handling arbitrary filter combinations on streaming data while significantly reducing slot resource consumption.
Looker Persistent Derived Tables (PDTs) are database tables written and managed directly by Looker within a scratch schema in BigQuery based on scheduled SQL queries.
Looker PDTs are suitable for heavy, complex multi-table data transformations and joins that only need periodic refreshes (e.g., nightly ETL rollups) rather than real-time data inspection.
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