Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

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 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 needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.

Which visualization option should the analyst utilize?

ARight-click to hide unwanted rows.

BLimit displayed rows.

CUse a custom filter.

DHide rows with table calculations.

Answer : B

Question 4

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 5

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 6

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.

What should the analyst do to optimize the dashboard for mobile viewing?

ASchedule the dashboard as HTML to adjust automatically.

BSchedule the dashboard with the PDF format Use single column layout.

CCreate a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

DSchedule the dashboard with PDF paper size set to Fit Page to Dashboard.

Answer : B

Question 7

The query below shows how many uses purchased an item from each of two clothing departments.

Why are the total and sum of the rows unequal?

AThere is a filter limiting the count in the Total row.

BThere is a faulty logic in the way users relate to clothing departments.

CA user is only counted once in the total even if the user has purchased from both departments.

DThere are users who have never purchased a clothing item from either department.

Answer : C

Google Looker Business Analyst Looker-Business-Analyst Exam Questions