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

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

A. Display row totals for each category.

B. Series type customization on budgeted spend.

C. Grouped series positioning on budgeted spend.

D. Transpose table to separate out budgeted spend.

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:

Ticket Purchase Month Movie Name Ticket Revenue

The analyst notices that the numbers look a lot smaller than expected and the results are difficult to

understand.

What should the analyst do to make the Explore query show the desired metric?

A. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

B. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

C. Add the Sum Revenue measure to the query.

D. Add a table calculation that sums the Ticket Revenue dimension.

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.

What should the analyst do to optimize the dashboard for mobile viewing?

A. Schedule the dashboard as HTML to adjust automatically.

B. Schedule the dashboard with the PDF format Use single column layout.

C. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

D. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.

The analyst is exploring weekly sales revenue in the last 3 months using a line chart. One requirement is to show the sales target $30,000 in the chart.

Which solution can help the analyst display the sales target?

A. Add a trend line for 30000.

B. Add a Tick Density of 30000.

C. Add a reference line for 30000.

D. Add a table calculation to hide values less than 30000.

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.

An analyst has created a dashboard that needs to be integrated into the company's internal support portal. The dashboard should match the style of the support portal.

How should the analyst display the dashboard in the style of the support portal without changing the style of the tiles in Looker?

A. Copy the dashboard.

B. Edit embed settings.

C. Apply a table theme.

D. Edit HTML on the dashboard.

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