- (Topic 3)
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00. What should you do?

1. A. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
2. B. From Tableau Server, select Schedules, and change the priority of the existing schedule.
3. C. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
4. D. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

Correct Answer: C

- (Topic 3)
The following table displays the row-level data in a Tableau data source:

A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?

1. A. 12
2. B. 50
3. C. 15
4. D. An error

Correct Answer: A

DRAG DROP - (Topic 3)
You have a data source that contains the following columns.

You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.
Which calculation should the analyst use to do this?

1. A. {FIXED [Region]: SUM([Sales])}
2. B. [FIXED [Region]: TOTAL([Sales])]
3. C. {FIXED [State]: SUM([Sales])}
4. D. {FIXED [State], [Region]: SUM([Sales])}

Correct Answer: A

HOTSPOT - (Topic 1)
You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A