Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data analyst regularly creates interactive reports in Looker Studio based on multi-terabyte datasets stored in Google BigQuery. The dashboard users report slow chart loading times, and the organization wants to accelerate query response times using an in-memory caching mechanism while minimizing BigQuery query computation costs.
Which service should be configured to optimize Looker Studio dashboard performance with BigQuery?
Persistent Derived Tables (PDTs) are a data modeling feature in core Looker (managed via LookML) that writes the results of complex transformation queries into temporary scratch tables or materialized tables within the underlying database.
datagroup triggers and SQL persistence definitions inside Looker models.The scenario focused on pre-aggregating complex SQL transformation models inside a core Looker (LookML) deployment to optimize query performance across multiple governed Explores.
Dataproc Metastore is a fully managed, serverless Apache Hive metastore (HMS) service in Google Cloud that stores metadata schemas and partition information for open-source big data processing frameworks like Apache Spark, Apache Hive, and Presto running on Dataproc.
The scenario required managing a centralized Apache Hive metadata catalog across multiple ephemeral Apache Spark clusters on Google Cloud Dataproc.
BigQuery BI Engine is a fast, in-memory analysis service built directly into Google BigQuery. It enables business intelligence (BI) and visualization tools—such as Looker Studio, Looker, and third-party BI applications—to interactively query large datasets with sub-second response times and high concurrency.

BigQuery BI Engine is purpose-built to sit between BigQuery storage and visualization tools like Looker Studio. It provides an immediate speed and cost optimization layer specifically designed for analytical dashboard workflows.
BigQuery Data Transfer Service (DTS) is a fully managed data ingestion service designed to automate and schedule recurring data transfers from SaaS applications (such as Google Ads, YouTube, and Google Analytics) and external cloud storage providers into BigQuery.
The scenario asked how to automatically import daily campaign performance data from Google Ads or YouTube Analytics into BigQuery datasets for future analysis.
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