Online Access Free Looker-Business-Analyst Exam Questions

An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.
What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)

• A.The analyst wants to use the Look-linked tile in a separate company performance dashboard.
• B.The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
• C.The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
• D.The analyst plans on creating a scheduled report of the associated Look.

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

• A.The time zone setting is different for each user.
• B.The dashboard was accessed via different boards.
• C.Dashboard filters are being used
• D.The dashboard uses separate Explores for each user.
• E.Looker caching is affecting results.

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 Brand Name alphabetically and apply a row limit of 50.
• B.Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.
• C.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.
• D.Sort the data by Count of Items Sold descending and apply a row limit of 50.

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

• A.Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
• B.Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"
• C.Sales Closing Date "matches advanced" "12 months ago for 3 months"
• D.Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago