Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.

What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)

AThe analyst wants to use the Look-linked tile in a separate company performance dashboard.

BThe analyst plans on creating a scheduled report of the associated Look.

CThe analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.

DThe analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.

Answer : A, B

Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard

Question 2

An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:

Number of bananas cleared for consumption the previous week

Number of bananas cleared for consumption the week before that

Which process should the analyst follow to show these two metrics in a report?

ACreate two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile (''last week'' and ''2 weeks ago'' respectively)

BCreate one tile on a dashboard and two dashboard filters (''last week'' and ''2 weeks ago'' respectively). Apply both dashboard filters to the tile.

CCreate two tiles on a dashboard. In the Edit mode of one tile, add a filter for ''last week''. Add a dashboard filter for ''2weeks ago'' and apply it to the other tile.

DCreate two identical looks in the same folder. Add filters on them for ''last week'' and ''2 weeks ago'' respectively.

Answer : C

Question 3

An analyst has created a dashboard that needs to be integrated into the company's internal support portal. The dashboard should match the style of the support portal.

How should the analyst display the dashboard in the style of the support portal without changing the style of the tiles in Looker?

ACopy the dashboard.

BEdit embed settings.

CApply a table theme.

DEdit HTML on the dashboard.

Answer : B

Question 4

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

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 compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

ASelect the dimension Created Month, and pivot on the dimension Created Year.

BSelect the dimension Created Year, and pivot on the dimension Created Month.

CSelect the dimension Created Month Name, and pivot on the dimension Created Year.

DSelect the dimension Created Year, and pivot on the dimension Created Month Name.

Answer : A

Question 7

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

Google Looker Business Analyst Looker-Business-Analyst Exam Questions