Google Cloud Associate Data Practitioner — Question 69

Your company uses Looker to visualize and analyze sales data. You need to create a dashboard that displays sales metrics, such as sales by region, product category, and time period. Each metric relies on its own set of attributes distributed across several tables. You need to provide users the ability to filter the data by specific sales representatives and view individual transactions. You want to follow the Google-recommended approach. What should you do?

Answer options

• A. Create multiple Explores, each focusing on each sales metric. Link the Explores together in a dashboard using drill-down functionality.
• B. Use BigQuery to create multiple materialized views, each focusing on a specific sales metric. Build the dashboard using these views.
• C. Create a single Explore with all sales metrics. Build the dashboard using this Explore.
• D. Use Looker's custom visualization capabilities to create a single visualization that displays all the sales metrics with filtering and drill-down functionality.

Correct answer: C

Explanation

The correct answer is C because creating a single Explore that encompasses all sales metrics allows for a more streamlined data model and facilitates easier filtering and visualization within the dashboard. Options A and B complicate the setup by requiring multiple Explores or views, which can hinder performance and user experience. Option D, while innovative, does not align with the best practice of keeping metrics organized within a single Explore for optimal data management.