Google LOOKER-BUSINESS-ANALYST Exam Questions & Answers

A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.

What should the analyst do to further investigate the low numbers?

A. Run the Explore again to make sure the results are the same.

B. Click on the Count measure where it is low to drill in to it.

C. Click on the Room Type dimension where it is King to drill in to it.

D. Remove the pivot on the Room Type dimension and re-run the Explore.

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?

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

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

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

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

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?

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.