Question 1

HOTSPOT
You have a data source that contains the following columns.

You have the following view that shows the percentage of total sales by category:

You want to change the calculation to show the percentage of total sales within the categories of
every region annually. Which Compute Using option should you use? (Click the appropriate Option in
the Answer Area.)

Question 2

You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the
worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from
appearing when you print the worksheet as a PDF. Which settings should configure from the File
menu in Tableau Desktop?

• A. Page Setup
• B. Print
• C. Export As PowerPoint
• D. Share
• E. Export As Version

Question 3

You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?

• A. From the worksheet, modify the subscription.
• B. From the My Content overview page, modify the subscription.
• C. From the dashboard overview page, modify the subscription.
• D. From the My Content overview page, modify the alert.

Question 4

HOTSPOT
You have the following worksheet.

Question 5

You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.

• A. PDF
• B. Image
• C. Microsoft Excel
• D. Microsoft PowerPoint

Question 6

You need the top 10 values to appear in a different color. The lop 10 values must be colored
dynamically.
What should you do?

• A. Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.
• B. Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.
• C. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
• D. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

Question 7

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

You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?

• A. Dimension filler
• B. Table calculation filter
• C. Context filter
• D. Measure filter

Question 8

You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by
selecting a data point on the map.
What should you do?

• A. From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
• B. From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.
• C. From the context menu of Detail table, select Ignore Actions.
• D. From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

Question 9

You want to create the following dashboard that will contain two sheets.

What should you do?

• A. Drag both sheets to the dashboard and add a border to each sheet.
• B. Drag both sheets to the dashboard and add a background lo each sheet.
• C. Add both sheets lo a horizontal container and add a border to the container.
• D. Add a border to both sheets and add both sheets to a horizontal object.

Question 10

HOTSPOT
You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link
named "Click here to know more!" as shown in the following exhibit.

Question 11

In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {“year”, [Order Dace]) = DATETPUNC)"year", TODAY(J)
You want to create a calculated column named Exclude Current Month that will be dragged to the
Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to
the Answer Area and drop into the correct locations.)

Question 12

You have the following view.

You want to filter the view lo show only records that have a movie name starting with the word.
"The". You must achieve the goal without writing any formulas.
Which type of filter should you use?

• A. Wildcard
• B. Condition
• C. General
• D. Top

Question 13

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft
SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your
company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose
two.

• A. Change the data source to an extract before you publish.
• B. Embed the credentials when you publish the workbook.
• C. Remove all the data source filters before you publish.
• D. Export the data to a .csv before you publish.
• E. Configure the local file permissions to the workbook file, and then publish the workbook.

Question 14

HOTSPOT
You use a quick table calculation lo calculate the moving average of a measure named Sales.
You need to calculate the moving averages of the last three years.
Which setting should you change in the Table Calculation dialog box? {Click the appropriate Option in
the Answer Area)

Question 15

HOTSPOT
You have the following dataset.

You need to generate the results in the Day field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct
options to complete the formula.)