Online Access Free Looker-Business-Analyst Exam Questions

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.
Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

• A.Transpose table to separate out budgeted spend.
• B.Series type customization on budgeted spend.
• C.Grouped series positioning on budgeted spend.
• D.Display row totals for each category.

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?

• A.Contact the LookML Developer
• B.Select the Static Map visualization instead of Interactive
• C.Add a table calculation that evaluates location (${cities.city_name})
• D.Remove the Number of Museums measure from 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.Sales Closing Date "matches advanced" "12 months ago for 3 months"
• B.Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
• C.Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
• D.Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

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 not NULL, sort the data by Count of Items Sold ascending, 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.Sort the data by Count of Items Sold descending and apply a row limit of 50.

An analyst needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.
Which visualization option should the analyst utilize?

• A.Use a custom filter.
• B.Limit displayed rows.
• C.Right-click to hide unwanted rows.
• D.Hide rows with table calculations.