Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

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

Question 2

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 3

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 4

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 5

A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

AX-axis settings

BColumn settings

CExplore settings

DRow settings

Answer : C

Question 6

A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.

How should the analyst ensure that the filter is unique to one customer?

AChange the filter type to string.

BEnable the setting Limit one filter value.

CUse the Matches Advanced filtering option.

DDisable the setting Allow multiple filter values.

Answer : D

Question 7

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

Google Looker Business Analyst Looker-Business-Analyst Exam Questions