Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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.

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

A.

Pin the dashboards into boards and grant user access to the individual dashboards.

B.

Add descriptions to the dashboards to give more details.

C.

Sort the dashboards in the folder by name.

D.

Show the dashboards in a grid style for displaying the snapshot.

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.

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

A.

Select the dimension Created Month, and pivot on the dimension Created Year.

B.

Select the dimension Created Year, and pivot on the dimension Created Month.

C.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

D.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading “All Results Unavailable.”

What are three causes of this message? (Choose three.)

A.

The Row Limit chosen in the Look is too high.

B.

There is a table calculation in the Look.

C.

Unlimited results are unsupported by CSV format.

D.

The Row Totals option is turned on in the Look.

E.

There is a Running Total measure in the Look.

F.

The Totals option is turned on in the Look.

Two users report seeing different results on the same dashboard.

Which three configurations could explain these discrepancies? (Choose three.)

A.

The time zone setting is different for each user.

B.

Looker caching is affecting results.

C.

The dashboard uses separate Explores for each user.

D.

Dashboard filters are being used

E.

The dashboard was accessed via different boards.

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.

How should that metric be calculated?

A.

Add a Sum measure to the Explore and re-run the query.

B.

Add a table calculation that calls running_portal (${users.signup_count})

C.

Add a custom measure of type: running_total

D.

Add a table calculation that calls ${users.signup_count:total}

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

A.

7 days from now

B.

After Today’s Date for 7 days

C.

Today for 7 days

D.

For 7 days

An analyst needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.

Which visualization option should the analyst utilize?

A.

Right-click to hide unwanted rows.

B.

Limit displayed rows.

C.

Use a custom filter.

D.

Hide rows with table calculations.

An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.

Which action should the analyst take to download all results?

A.

Request that the admin user download this Look and share the file.

B.

Change the table calculation to use an offset() function.

C.

Contact the developer to create the percentage as a measure.

D.

Apply a custom limit to the download.