Question No : 1
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis. You need to configure be shapes to be much larger than the line.
What should you do?

• A.Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
• B.Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
• C.For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
• D.Change Population to a discrete dimension

Show Answers

Answer:
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm

Question No : 2
You have the following tiled dashboard that has one sheet.



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

• A.Right-click Sheet2 and select Add to Dashboard.
• B.Select Sheets and click the Swap Sheet button next to Sheet2.
• C.From the context menu of Sheet3. select Remove Dashboard item
• D.Drag Sheet2 to the dashboard.
• E.From the context menu of Sheet3. select Deselect

Show Answers

Answer:
Explanation:
To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm
https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm

Question No : 3
You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
• Top N Customers
• Customers of 2020
• Top N Products
• Sellers of 2020
Which two sets can you combine? Choose two

• A.Sellers of 2020
• B.Customers of 2020
• C.Top N Products
• D.Top N Customers

Show Answers

Answer:
Explanation:
To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets

Question No : 4
You have the following dataset.



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

• A.{FIXED: [Region] SUM Sales}
• B.{FIXED: SUM Sales}
• C.{Fixed: [Region]: TOTAL Sales}
• D.{FIXED: TOTAL (Sales)}

Show Answers

Answer:
Explanation:
To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

Question No : 5
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?

• A.August
• B.October
• C.December
• D.November

Show Answers

Answer:
Explanation:
To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm
https://www.mathsisfun.com/algebra/line-equation-slope.html

Question No : 6
DRAG DROP
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)

Show Answers

Answer:

Question No : 7
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers.
How should you share me dashboard with the healthcare workers?

• A.Publish the dashboard to Tableau Public
• B.Print the dashboard to PDF
• C.Publish aw dashboard to Tableau Server
• D.Export the dashboard as a .twbx

Show Answers

Answer:
Explanation:
To share a dashboard that contains confidential information about patients health and needs to always be up to date for a team of healthcare workers, you should publish it to Tableau Server. This will allow you to control who can access and interact with your dashboard, as well as schedule automatic refreshes of your data source or extract. Publishing to Tableau Public would expose your data to anyone on the internet, printing to PDF would not update your data, and exporting as a .twbx would require sending a large file that might not be compatible with other versions of Tableau.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_tableauserver.htm

Question No : 8
HOTSPOT
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?

Show Answers

Answer:


Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category], which means that the ranking will reset for each category.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_rank.htm

Question No : 9
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.



You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

• A.Right-click a in the chat, select Annotate and then select Mark.
• B.Right-click a bar in the chart select Mark Label and then select Always show.
• C.Edit the aliases for City.
• D.Drag Region to Tooltip on the Marks card

Show Answers

Answer:
Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

Question No : 10
You publish a dashboard tut uses an attract. 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?

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

Show Answers

Answer:
Explanation:
To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules.
Reference:
https://help.tableau.com/current/server/en-us/refresh_extracts.htm
https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm