NO.19 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.)

NO.20 You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

NO.21 You have the Mowing two tables that contains data about the books in a library.


Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?

NO.22 You have a dataset that contains sates dat
a. The following is a sample of the data.

You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two

NO.23 You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

NO.24 Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

NO.25 Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.

NO.26 You have the following dashboard that contains two visualizations.

You want to show only visualization at time. Users must be able to switch between visualizations.
What should you me?

NO.27 Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

NO.28 You are the owner of an alert.
You receive an email notification that the alert was suspended From where can you resume the suspended alert?

NO.29 You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?

NO.30 You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

NO.31 You have the following dashboard.

Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?

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

NO.33 Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

NO.34 You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

NO.35 You have the following bar chart.

You want the chart to appear as shown in the Mowing exhibit.

What should you add?

NO.36 You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

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

Which type of object should you use?

NO.38 Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.

NO.39 You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?