Google Cloud Associate Data Practitioner — Question 46

You have created a LookML model and dashboard that shows daily sales metrics for five regional managers to use. You want to ensure that the regional managers can only see sales metrics specific to their region. You need an easy-to-implement solution. What should you do?

Answer options

• A. Create a sales_region user attribute, and assign each manager’s region as the value of their user attribute. Add an access_filter Explore filter on the region_name dimension by using the sales_region user attribute.
• B. Create five different Explores with the sql_always_filter Explore filter applied on the region_name dimension. Set each region_name value to the corresponding region for each manager.
• C. Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.
• D. Create separate Looker instances for each regional manager. Copy the LookML model and dashboard to each instance. Provision viewer access to the corresponding manager.

Correct answer: A

Explanation

The correct answer is A because creating a sales_region user attribute allows for dynamic filtering based on the manager's assigned region, which is a straightforward and efficient solution. Options B and C involve creating multiple Explores or dashboards, which complicates management and can lead to redundancy. Option D is overly complex and resource-intensive, as it requires maintaining separate instances for each manager.