Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

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 2

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

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 5

An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard.

How can the analyst set up a schedule to accomplish this?

ACheck Use single column layout in the Advanced options section of the scheduler.

BCheck Expand tables in the Advanced options section of the scheduler.

CSelect the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.

DSelect Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipient's user attribute preferences to be individual_images.

Answer : A

Question 6

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error ''Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time''.

How can the analyst resolve this error while showing the rank as a column visualization?

APivot the Explore by the Brand Name dimension.

BSelect a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

CPivot the Explore by brand Rank.

DSelect a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

Answer : D

Question 7

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.

How should the analyst ensure that the PDF shows all available results in the UI dashboard?

ASelect the Expand Tables option.

BSelect the All Results option

CSelect the Allow Scroll option and specify each table.

DSelect the Paper Size option and specify a large size.

Answer : A

Google Looker Business Analyst Looker-Business-Analyst Exam Questions