Google Looker-Business-Analyst Exam Practice Test Instant Access

Question 1

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 2

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 3

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 4

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

A7 days from now

BAfter Today's Date for 7 days

CToday for 7 days

DFor 7 days

Answer : B

Question 5

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 6

A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor.

How should the analyst configure the dashboard?

ASet the dashboard schedule to run every 5 minutes.

BSet the dashboard auto refresh to 5 minutes.

CSet the dashboard to run on load every 5 minutes.

DSet the dashboard schedule to 5 minutes and ''send if the results have changed''.

Answer : A

Question 7

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?

AAxis Value Labels

BValue Format

CLabel Rotation

DTime Label Format

Answer : B

Google Looker Business Analyst Looker-Business-Analyst Exam Practice Test