Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
A business analyst needs to create an interactive sales dashboard in Looker for regional managers. The dashboard must present regional revenue metrics using visual charts and allow managers to dynamically filter all visualizations by date range and product category.
Which approach should the analyst use to design and build this dashboard?
Create separate LookML model files for each regional manager with hardcoded WHERE clauses for dates and categories.
Extract query results to static CSV files in SQL Runner, store them in Cloud Storage, and link them to the dashboard using text tiles.
Embed raw SQL statements directly into iframe URLs and publish them onto public websites without defining LookML views or Explores.
Query data in an Explore using dimensions and measures, select appropriate visualization types to save as dashboard tiles, and add dashboard filters mapped to the relevant fields.
Create separate LookML model files for each regional manager with hardcoded WHERE clauses for dates and categories.
Extract query results to static CSV files in SQL Runner, store them in Cloud Storage, and link them to the dashboard using text tiles.
Embed raw SQL statements directly into iframe URLs and publish them onto public websites without defining LookML views or Explores.
Query data in an Explore using dimensions and measures, select appropriate visualization types to save as dashboard tiles, and add dashboard filters mapped to the relevant fields.
Looker is a modern business intelligence and data exploration platform. In Looker, users interact with data models through Explores, which expose curated dimensions (attributes or categories) and measures (aggregations like sums and counts). Dashboards in Looker serve as collections of visual tiles created from Explore queries or saved Looks, organized to deliver actionable insights.
StudyCerts
StudyCertsOrder Date, Product Category, and Total Revenue), configure chart types (such as bar charts, line graphs, or tables), and save them directly as dashboard tiles.Building tiles from Explores and implementing native dashboard filters represents standard best practice in Looker. It avoids hardcoded queries, supports self-service interactivity, and ensures centralized governance across all analytical views.