Google Looker Business Analyst Practice Test - Questions Answers, Page 3
List of questions
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?
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:
Question 23

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?
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?
Explanation:
Reference: https://docs.looker.com/exploring-data/exploring-data#features_for_developers
Question 25

Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)
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?
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?
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?
Explanation:
Reference: https://community.looker.com/dashboards-looks-7/top-5-and-other-10743
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?
Question 30

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