Spring Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

  1. Home
  2. Google
  3. Looker certifications
  4. Looker-Business-Analyst
  5. Looker Business AnalystExam Questions and Answers

Looker-Business-Analyst Looker Business AnalystExam Questions and Answers

Questions 4

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?

Options:

A.

Pivot the Explore by the Brand Name dimension.

B.

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

C.

Pivot the Explore by brand Rank.

D.

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

Buy Now
Questions 5

An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.

How can the analyst create this filter condition?

Options:

A.

Custom filter “is in the past” 12 months AND “is before” “relative” 9 months ago

B.

Sales Closing Date “matches advanced” “12 months ago for 3 months”

C.

Sales Closing Date “is in the past” 12 months OR “is before” “relative” 9 months ago

D.

Sales Closing Date “matches advanced” “between 12 months ago and 9 months ago”

Buy Now
Questions 6

An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.

Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

Options:

A.

pivot_offset()

B.

lookup()

C.

offset_list()

D.

offset()

Buy Now
Questions 7

Two users report seeing different results on the same dashboard.

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

Options:

A.

The time zone setting is different for each user.

B.

Looker caching is affecting results.

C.

The dashboard uses separate Explores for each user.

D.

Dashboard filters are being used

E.

The dashboard was accessed via different boards.

Buy Now
Questions 8

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

Looker-Business-Analyst Question 8

Why are the total and sum of the rows unequal?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 9

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?

Options:

A.

Copy the dashboard.

B.

Edit embed settings.

C.

Apply a table theme.

D.

Edit HTML on the dashboard.

Buy Now
Questions 10

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

Options:

A.

Pin the dashboards into boards and grant user access to the individual dashboards.

B.

Add descriptions to the dashboards to give more details.

C.

Sort the dashboards in the folder by name.

D.

Show the dashboards in a grid style for displaying the snapshot.

Buy Now
Questions 11

An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.

How should the analyst ensure that the differences between returned order counts for each day are more visible?

Options:

A.

Change the returned orders series to a line type.

B.

Move the returned orders series to a new right axis.

C.

Change the y-axis height to a higher number of pixels.

D.

Set the x-axis to use a log scale.

Buy Now
Questions 12

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?

Options:

A.

Schedule the dashboard as HTML to adjust automatically.

B.

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

C.

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

D.

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

Buy Now
Exam Code: Looker-Business-Analyst
Exam Name: Looker Business AnalystExam
Last Update: Apr 30, 2026
Questions: 40

PDF + Testing Engine

$63.52  $181.49
buy now Looker-Business-Analyst pdf + testing engine

Testing Engine

$50.57  $144.49
buy now Looker-Business-Analyst testing engine

PDF (Q&A)

$43.57  $124.49
buy now Looker-Business-Analyst pdf