Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

An analyst has a dashboard with a single filter on Created Date ''is in the past year'', but a tile on the dashboard is returning results for only the past 7 days. When the analyst selects ''Explore from Here'' on the tile, there are filters on both Created Date ''is in the past year'' and Created Time ''is in the past 7 days''.

How should the analyst make sure that only the filter set on the dashboard is applied to the tile?

AAfter selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.

BAfter selecting Edit on the tile, add a filter on Created Date and hit Save.

CEdit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.

DEdit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.

Answer : D

Question 2

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 3

An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.

Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

Apivot_offset()

Blookup()

Coffset_list()

Doffset()

Answer : D

Question 4

An analyst needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.

Which visualization option should the analyst utilize?

ARight-click to hide unwanted rows.

BLimit displayed rows.

CUse a custom filter.

DHide rows with table calculations.

Answer : B

Question 5

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?

AGive all users view access to the personal folder.

BMove the dashboard to a shared folder and provide access only to the users from the team.

CGive view access to the individual dashboards.

DCreate a subfolder in the personal folder and given view access to the users from the team.

Answer : D

Question 6

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.)

AThe Row Limit chosen in the Look is too high.

BThere is a table calculation in the Look.

CUnlimited results are unsupported by CSV format.

DThe Row Totals option is turned on in the Look.

EThere is a Running Total measure in the Look.

FThe Totals option is turned on in the Look.

Answer : A, B, D

Question 7

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

Google Looker Business Analyst Looker-Business-Analyst Exam Questions