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 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?
This option suggests writing separate LookML model files for every individual user or manager, embedding fixed SQL WHERE clauses directly into the model logic to restrict dates and categories.
You needed to establish permanent, distinct database connections for completely isolated environments or distinct business entities.
This approach suggests bypassing Looker's data modeling layer entirely by embedding raw SQL scripts inside public iframe URLs hosted on external web pages.
The goal was to embed a single, publicly accessible chart into an unauthenticated external website without requiring access controls or dashboard filters.
This approach involves running raw SQL queries via SQL Runner, manually exporting snapshot results into static CSV files, uploading the files to Cloud Storage, and presenting links via Markdown text tiles on a dashboard.
The requirement was simply to post external reference documentation or download links to static historical files on a dashboard canvas.
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.
Order 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.
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