Tableau TDA-C01 Practice Test - Questions Answers, Page 6

You have the following table.

You need each record to alternate between grey and white.

What should you change in the Format Shading pane?

HOTSPOT

You have a data set that contains three columns named Sales, Profit, and Quantity.

You need to build the following scatter plot.

DRAG DROP

You have the following calculated fields in a worksheet.

[Calc1] = DATEADD ('year', -1, TODAY ())

[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())

You want to calculate the month to date value of the prior year.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.

DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.

You want to combine the tables to meet the following requirements:

. Each record in Employeelnfo must be retained in the combined table.

. The records must contain the Department Name, Size, and VP fields.

* Every record must have a full name.

Which type of join should you use?

You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.

When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

You are creating an annual report in Microsoft Word.

In Tableau Desktop, you build a chart in a worksheet.

You want to create an image of the chart that you can add to the annual report.

What are two ways to create the image? Choose two.

You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

HOTSPOT

You have a blank dashboard.

You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.

To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

HOTSPOT

You receive a tab-delimited data file name sales.tsv.

You need to connect to the file.

Which option should you select in Tableau Desktop?