Home / Google / Looker Business Analyst

Google Looker Business Analyst Practice Test - Questions Answers, Page 3

Question list

List of questions

Question 21

(0)

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message: "At least one dime

Question 22

(0)

An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:

Question 23

(0)

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results a

Question 24

(0)

A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number

Question 25

(0)

Two users report seeing different results on the same dashboard. Which three configurations could explain these discrepancies? (Choose three.)

Question 26

(0)

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?

Question 27

(0)

A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter

Question 28

(0)

An analyst is trying to create a pie chart showing the breakdown of the top sales by brand in an Explore. The analyst selects the Brand Name dimension and a measure for the Count of Items Sold. The

Question 29

(0)

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit. How should the analyst, in addition to selecting the measure Total Sales bu

Question 30

(0)

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 fr

Question 21

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:

"At least one dimension should be of type Location or have a map_layer specified".

There are currently three fields in the Explore:

City Name (Dimension)

Population (Measure)

Number of Museums (Measure)

What should the analyst do to resolve this error?

Remove the Number of Museums measure from the Explore

Select the Static Map visualization instead of Interactive

Contact the LookML Developer

Add a table calculation that evaluates location (${cities.city_name})

Show Answer Comment (0)

Question 22

An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:

Number of bananas cleared for consumption the previous week

Number of bananas cleared for consumption the week before thatWhich process should the analyst follow to show these two metrics in a report?

Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)

Create one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.

Create two tiles on a dashboard. In the Edit mode of one tile, add a filter for "last week". Add a dashboard filter for "2weeks ago" and apply it to the other tile.

Create two identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.

Show Answer Comment (0)

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

7 days from now

After Today's Date for 7 days

Today for 7 days

For 7 days

Show Answer Comment (0)

Question 24

A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.

What is a possible cause of this discrepancy?

There is a row limit applied.

There is a filter on a dimension.

There is a problem with the underlying LookML.

There is a column limit applied.

Show Answer Comment (0)

Question 25

Two users report seeing different results on the same dashboard.

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

The time zone setting is different for each user.

Looker caching is affecting results.

The dashboard uses separate Explores for each user.

Dashboard filters are being used

The dashboard was accessed via different boards.

Show Answer Comment (0)

Question 26

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?

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

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

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

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

Show Answer Comment (0)

Question 27

A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.

What happens in this situation?

The filter values of both filters will combine in an additive manner and both filters will apply.

The individual tile's filter will override the global dashboard filter.

The global dashboard filter will override the individual tile filter.

The dashboard will break and warn the user that there are conflicting filter values.

Show Answer Comment (0)

Question 28

An analyst is trying to create a pie chart showing the breakdown of the top sales by brand in an Explore. The analyst selects the Brand Name dimension and a measure for the Count of Items Sold. The analyst then selects the pie chart visualization, but sees the error "Too Many Rows: Pie charts can display a maximum of 50 rows of data." How can the analyst resolve this error and create a pie chart that will always show the top brands by items sold?

Sort the data by Count of Items Sold descending and apply a row limit of 50.

Sort the data by Brand Name alphabetically and apply a row limit of 50.

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

Apply a filter on the Count of Items Sold measure that requires the count to be not NULL, sort the data by Count of Items Sold ascending, and apply a row limit of 50.

Show Answer Comment (0)

Question 29

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Show Answer Comment (0)

Question 30

How should the analyst make sure that only the filter set on the dashboard is applied to the tile?

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

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

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

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

Show Answer Comment (0)

Total 40 questions

1 2 3 4

Go to page: of 4

Google Looker Business Analyst Practice Test - Questions Answers, Page 3

Question list

List of questions

Question 21

(0)

Question 22

(0)

Question 23

(0)

Question 24

(0)

Question 25

(0)

Question 26

(0)

Question 27

(0)

Question 28

(0)

Question 29

(0)

Question 30

(0)

Related questions

Question