Google LOOKER-BUSINESS-ANALYST Exam Questions & Answers

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 company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.

How should the analyst ensure that the filter is unique to one customer?

A. Change the filter type to string.

B. Enable the setting Limit one filter value.

C. Use the Matches Advanced filtering option.

D. Disable the setting Allow multiple filter values.

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.