LOOKER-BUSINESS-ANALYST Online Practice Questions and Answers

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" "12 months ago for 3 months"

C. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago

D. Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.

What should the analyst do to meet this requirement?

A. Filter the dashboard for the advanced value "yesterday", and create a new schedule.

B. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.

C. Create a new schedule and modify the filter's default value to the previous day's date.

D. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".

An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.

How should the analyst ensure that the differences between returned order counts for each day are more visible?

A. Change the returned orders series to a line type.

B. Move the returned orders series to a new right axis.

C. Change the y-axis height to a higher number of pixels.

D. Set the x-axis to use a log scale.

A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.

What happens in this situation?

A. The filter values of both filters will combine in an additive manner and both filters will apply.

B. The individual tile's filter will override the global dashboard filter.

C. The global dashboard filter will override the individual tile filter.

D. The dashboard will break and warn the user that there are conflicting filter values.

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 needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.

How should the analyst display the data from both sources?

A. use Merged Results to combine the data sources.

B. Ask the LookML developer to build a new Explore.

C. Add both Looks to a dashboard

D. Pin both Looks to a board.

An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.

Which visualization option should the analyst utilize to alter the display of the value labels?

A. Axis Value Labels

B. Value Format

C. Label Rotation

D. Time Label Format

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.

Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.

How should the analyst filter the query?

A. Created Month "is in the first 2 quarters"

B. Created Month "is in the past 2 complete quarters"

C. Created Month "is in the past 2 quarters"

D. Created Month "is in the last 6 months"

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.