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 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 team's 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.

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 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 needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.

Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

A. pivot_offset()

B. lookup()

C. offset_list()

D. offset()

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

The query below shows how many uses purchased an item from each of two clothing departments.

Why are the total and sum of the rows unequal?

A. There is a filter limiting the count in the Total row.

B. There is a faulty logic in the way users relate to clothing departments.

C. A user is only counted once in the total even if the user has purchased from both departments.

D. There are users who have never purchased a clothing item from either department.

The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.

Which access settings should be applied to the folder?

A. Admins: Manage Access, Edit Sales analyst: Edit Sales group: View

B. Admins: View Sales analyst: Edit Sales group: View

C. Admins: View Sales analyst: Manage Access, Edit Sales group: View

D. Admins: Manage Access, Edit Sales analyst: Manage Access, Edit Sales group: View