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

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

A.

RUNNING_AVG

B.

INCLUDE

C.

AVG

D.

EXCLUDE

A Data Analyst has a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.

The following is a sample of the data.

The analyst wants to ensure that every calculation is affected by including only animals of a particular type.

Which type of filter should the analyst create on the worksheet?

A.

Extract

B.

Table calculation

C.

Context

D.

Measure

You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.

What should you do?

A.

Select Sheet3 and click the Swap Sheet button next to Sheet2.

B.

Right-click Sheet2 and select Add to Dashboard.

C.

From the context menu of Sheet3, select Deselect.

D.

Drag Sheet2 to the dashboard.

E.

From the context menu of Sheet3, select Remove Dashboard Item.

How should a Data Analyst sort data by Sales across multiple dimensions in Tableau?

A.

Use the Sets feature to combine dimensions and then sort one of the fields.

B.

Use the Group feature to combine dimensions and then sort the grouped field.

C.

Right-click on the rightmost dimension, choose Sort, then select nested in the options.

D.

Right-click on each dimension, choose Sort, then select data source order in the options.

When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?

A.

Fonts and Lines

B.

Fonts and Color Palette

C.

Number format and Shading

D.

Dashboard Height and Width pixel settings

A Data Analyst has a workbook that uses an extracted data source.

The analyst publishes the workbook to Tableau Server.

Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)

A.

Run a refresh

B.

Change the refresh from full to incremental

C.

Delete the refresh

D.

Modify the frequency of the refresh

E.

Change the priority of the refresh

You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

A.

Image

B.

Sheet

C.

Web page

D.

Horizontal

You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

A Data Analyst is using containers on a dashboard.

How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?

A.

Use the Layout tab to set the size of each object

B.

Float the objects and manually adjust the size

C.

Adjust the size of each object individually

D.

Use the distribute evenly option

You have the following dataset in Microsoft Excel.

You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

A.

10

B.

20

C.

17

D.

15