Google LOOKER-BUSINESS-ANALYST Online Practice Questions and Exam Preparation

Google LOOKER-BUSINESS-ANALYST Online Questions & Answers

• Question 21:

  An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard. How should the analyst ensure that the PDF shows all available results in the UI dashboard?

  A. Select the Expand Tables option.
  B. Select the All Results option
  C. Select the Allow Scroll option and specify each table.
  D. Select the Paper Size option and specify a large size.
  A. Select the Expand Tables option.

• Question 22:

  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
  B. Value Format

• Question 23:

  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. Remove the Number of Museums measure from the Explore
  B. Select the Static Map visualization instead of Interactive
  C. Contact the LookML Developer
  D. Add a table calculation that evaluates location (${cities.city_name})
  D. Add a table calculation that evaluates location (${cities.city_name})

• Question 24:

  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.
  C. Change the y-axis height to a higher number of pixels.

• Question 25:

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

• Question 26:

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

• Question 27:

  A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor. How should the analyst configure the dashboard?

  A. Set the dashboard schedule to run every 5 minutes.
  B. Set the dashboard auto refresh to 5 minutes.
  C. Set the dashboard to run on load every 5 minutes.
  D. Set the dashboard schedule to 5 minutes and "send if the results have changed".
  A. Set the dashboard schedule to run every 5 minutes.

• Question 28:

  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.
  C. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

• Question 29:

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

• Question 30:

  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.
  A. Dashboard filter to specify which individual data shows