[Jul-2022] Looker-Business-Analyst Dumps Full Questions – Looker certifications Exam Study Guide [Q11-Q25]

QUESTION 11
Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)

QUESTION 12
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?

QUESTION 13
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?

QUESTION 14
An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.
How should the analyst ensure that the PDF shows all available results in the UI dashboard?

QUESTION 15
The query below shows how many uses purchased an item from each of two clothing departments.

Why are the total and sum of the rows unequal?

QUESTION 16
A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.
How should the analyst ensure that the filter is unique to one customer?

QUESTION 17
An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading “All Results Unavailable.” What are three causes of this message? (Choose three.)

QUESTION 18
A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.
What is a possible cause of this discrepancy?

QUESTION 19
A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.
What happens in this situation?

QUESTION 20
Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.
How should the analyst filter the query?

QUESTION 21
An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.
Which visualization option should the analyst utilize to alter the display of the value labels?

QUESTION 22
An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.
How should the analyst display the data from both sources?

QUESTION 23
A business analyst is filtering for this year’s data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.
Where should the analyst go to make sure dates are filled in for the future?

QUESTION 24
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?

QUESTION 25
An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet.
What should the analyst do to enable the team’s access?