Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.

What should the analyst do to meet this requirement?

AFilter the dashboard for the advanced value ''yesterday'', and create a new schedule.

BEdit the dashboard data filters default value to be the previous day's date, and create a new schedule.

CCreate a new schedule and modify the filter's default value to the previous day's date.

DCreate a new schedule and modify the schedule filter to be the advanced value ''yesterday''.

Answer : B

Question 2

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

ADisplay row totals for each category.

BSeries type customization on budgeted spend.

CGrouped series positioning on budgeted spend.

DTranspose table to separate out budgeted spend.

Answer : D

Question 3

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 4

Two users report seeing different results on the same dashboard.

Which three configurations could explain these discrepancies? (Choose three.)

AThe time zone setting is different for each user.

BLooker caching is affecting results.

CThe dashboard uses separate Explores for each user.

DDashboard filters are being used

EThe dashboard was accessed via different boards.

Answer : C, D, E

Question 5

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 6

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