QUESTION 33
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.

QUESTION 34
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

QUESTION 35
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?

QUESTION 36
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?

QUESTION 37
You have the following dataset.

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

QUESTION 38
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.

QUESTION 39
You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?

QUESTION 40
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.

QUESTION 41
You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

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

Which type of object should you use?

QUESTION 43
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.

QUESTION 44
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.

QUESTION 45
You have the following visualization.

QUESTION 46
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?

QUESTION 47
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.

QUESTION 48
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

QUESTION 49
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

QUESTION 50
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?

QUESTION 51
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?

QUESTION 52
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?

QUESTION 53
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

QUESTION 54
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

QUESTION 55
You have the following visualization.

You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?

QUESTION 56
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 ?