Online Access Free Looker-Business-Analyst Exam Questions

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?

• A.There is a filter limiting the count in the Total row.
• B.A user is only counted once in the total even if the user has purchased from both departments.
• C.There is a faulty logic in the way users relate to clothing departments.
• D.There are users who have never purchased a clothing item from either department.

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?

• A.Select the Paper Size option and specify a large size.
• B.Select the Expand Tables option.
• C.Select the Allow Scroll option and specify each table.
• D.Select the All Results option

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:
Ticket Purchase Month
Movie Name
Ticket Revenue
The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.
What should the analyst do to make the Explore query show the desired metric?

• A.Add the Sum Revenue measure to the query.
• B.Add a table calculation that sums the Ticket Revenue dimension.
• C.Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
• D.Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

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?

• A.Row settings
• B.X-axis settings
• C.Explore settings
• D.Column settings

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?

• A.Run the Explore again to make sure the results are the same.
• B.Click on the Room Type dimension where it is King to drill in to it.
• C.Remove the pivot on the Room Type dimension and re-run the Explore.
• D.Click on the Count measure where it is low to drill in to it.