google looker-business-analyst practice test

Looker Business Analyst


Question 1

An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a
printout of the dashboard.
How can the analyst set up a schedule to accomplish this?

  • A. Check Use single column layout in the Advanced options section of the scheduler.
  • B. Check Expand tables in the Advanced options section of the scheduler.
  • C. Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.
  • D. Select Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipients user attribute preferences to be individual_images.
Answer:

A

Discussions

Question 2

An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile
or use an existing Look.
What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)

  • A. The analyst wants to use the Look-linked tile in a separate company performance dashboard.
  • B. The analyst plans on creating a scheduled report of the associated Look.
  • C. The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
  • D. The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
Answer:

A B

Explanation:
Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard

Discussions

Question 3

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

D

Explanation:
Reference: https://docs.looker.com/exploring-data/using-table-calculations

Discussions

Question 4

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
Answer:

B

Explanation:
Reference: https://docs.looker.com/exploring-data/visualizing-query-results/line-options


Discussions

Question 5

A business analyst is filtering for this years 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
Answer:

C

Explanation:
Reference: https://docs.looker.com/exploring-data/exploring-data

Discussions

Question 6

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

D

Discussions

Question 7

An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the
dashboard. There are a few dashboards in the personal folder that are not ready to share yet.
What should the analyst do to enable the teams access?

  • A. Give all users view access to the personal folder.
  • B. Move the dashboard to a shared folder and provide access only to the users from the team.
  • C. Give view access to the individual dashboards.
  • D. Create a subfolder in the personal folder and given view access to the users from the team.
Answer:

D

Explanation:
Reference: https://docs.looker.com/sharing-and-publishing/organizing-spaces

Discussions

Question 8

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”.
Answer:

B

Discussions

Question 9

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

D

Explanation:
Reference: https://docs.looker.com/exploring-data/exploring-data#features_for_developers

Discussions

Question 10

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”
Answer:

A

Explanation:
Reference: https://community.looker.com/explores-36/index4.html

Discussions
To page 2