Looker Business Analyst Exam Questions and Answers
The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.
Which access settings should be applied to the folder?
A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.
What should the analyst do to further investigate the low numbers?
An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.
Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?
An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.
What should the analyst do to meet this requirement?
An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles.
What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?
An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.
There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.
What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?
