Google Cloud Associate Data Practitioner — Question 35
Your company uses Looker to generate and share reports with various stakeholders. You have a complex dashboard with several visualizations that needs to be delivered to specific stakeholders on a recurring basis, with customized filters applied for each recipient. You need an efficient and scalable solution to automate the delivery of this customized dashboard. You want to follow the Google-recommended approach. What should you do?
Answer options
- A. Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.
- B. Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.
- C. Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.
- D. Use the Looker Scheduler with a user attribute filter on the dashboard, and send the dashboard with personalized filters to each stakeholder based on their attributes.
Correct answer: D
Explanation
Option D is correct because it leverages the Looker Scheduler with user attribute filters, allowing for automated and personalized report distribution based on stakeholder attributes. Option A is inefficient as it requires creating multiple models, which is not scalable. Option B involves manual scripting and requires more effort to generate plans for each stakeholder, and Option C introduces unnecessary complexity by embedding dashboards in a custom application, which is not the recommended approach.