Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

APin the dashboards into boards and grant user access to the individual dashboards.

BAdd descriptions to the dashboards to give more details.

CSort the dashboards in the folder by name.

DShow the dashboards in a grid style for displaying the snapshot.

Answer : C

Question 2

An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI dat

a. Each store's users must receive only the data filtered for that store. The analyst needs to see all store data in Looker.

What should the analyst build to accommodate these requirements?

AThree dashboards, one for each store

BThree schedules filtered by store

CFive schedules, one for each visualization

DA dashboard with three filters, one for each store

Answer : D

Question 3

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?

ADashboard filter to specify which individual data shows

BTwo dashboards, one with aggregate and one with individual data

CTwo dashboards with a text tile to hyperlink from one dashboard to the other

DFolder with all dashboard tiles for aggregate data and individual data.

Answer : A

Question 4

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?

ARemove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

BRemove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

CAdd the Sum Revenue measure to the query.

DAdd a table calculation that sums the Ticket Revenue dimension.

Answer : C

Question 5

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:

''At least one dimension should be of type Location or have a map_layer specified''.

There are currently three fields in the Explore:

City Name (Dimension)

Population (Measure)

Number of Museums (Measure)

What should the analyst do to resolve this error?

ARemove the Number of Museums measure from the Explore

BSelect the Static Map visualization instead of Interactive

CContact the LookML Developer

DAdd a table calculation that evaluates location (${cities.city_name})

Answer : D

Question 6

An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.

Which action should the analyst take to download all results?

ARequest that the admin user download this Look and share the file.

BChange the table calculation to use an offset() function.

CContact the developer to create the percentage as a measure.

DApply a custom limit to the download.

Answer : D

Question 7

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?

AThe filter values of both filters will combine in an additive manner and both filters will apply.

BThe individual tile's filter will override the global dashboard filter.

CThe global dashboard filter will override the individual tile filter.

DThe dashboard will break and warn the user that there are conflicting filter values

Answer : C

Google Looker Business Analyst Looker-Business-Analyst Exam Questions