Labour Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

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

Options:

A.

After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.

B.

After selecting Edit on the tile, add a filter on Created Date and hit Save.

C.

Edit the dashboard Created Date filter to update the tile’s Created Time field under Tiles to Update.

D.

Edit the dashboard Created Date filter to update the tile’s Created Time filter under Filters to Update.

Buy Now
Questions 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?

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 6

The analyst is exploring weekly sales revenue in the last 3 months using a line chart. One requirement is to show the sales target $30,000 in the chart.

Which solution can help the analyst display the sales target?

Options:

A.

Add a trend line for 30000.

B.

Add a Tick Density of 30000.

C.

Add a reference line for 30000.

D.

Add a table calculation to hide values less than 30000.

Buy Now
Exam Code: Looker-Business-Analyst
Exam Name: Looker Business AnalystExam
Last Update: May 5, 2024
Questions: 40

PDF + Testing Engine

$66.4  $165.99
buy now Looker-Business-Analyst pdf + testing engine

Testing Engine

$46  $114.99
buy now Looker-Business-Analyst testing engine

PDF (Q&A)

$42  $104.99
buy now Looker-Business-Analyst pdf