LOOKER-BUSINESS-ANALYST Online Practice Questions and Answers

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

A. Pin the dashboards into boards and grant user access to the individual dashboards.

B. Add descriptions to the dashboards to give more details.

C. Sort the dashboards in the folder by name.

D. Show the dashboards in a grid style for displaying the snapshot.

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. Display row totals for each category.

B. Series type customization on budgeted spend.

C. Grouped series positioning on budgeted spend.

D. Transpose table to separate out budgeted spend.

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?

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

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

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

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

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?

A. There is a row limit applied.

B. There is a filter on a dimension.

C. There is a problem with the underlying LookML.

D. There is a column limit applied.

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:

1.

Number of bananas cleared for consumption the previous week

2.

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

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

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

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

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

A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

A. X-axis settings

B. Column settings

C. Explore settings

D. Row settings

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error "Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time".

How can the analyst resolve this error while showing the rank as a column visualization?

A. Pivot the Explore by the Brand Name dimension.

B. Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

C. Pivot the Explore by brand Rank.

D. Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles.

What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?

A. Dashboard filter to specify which individual data shows

B. Two dashboards, one with aggregate and one with individual data

C. Two dashboards with a text tile to hyperlink from one dashboard to the other

D. Folder with all dashboard tiles for aggregate data and individual data.