Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Salesforce
  5. Certified Tableau Data Analyst

Salesforce Certified Tableau Data Analyst Exam Questions
Certified Tableau Data Analyst (Page 4 )

Updated On: 21-Feb-2026
Page 4 of 36
PDF with 174 Questions

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?

  1. Right-click a in the chat, select Annotate and then select Mark.
  2. Right-click a bar in the chart select Mark Label and then select Always show.
  3. Edit the aliases for City.
  4. Drag Region to Tooltip on the Marks card

Answer(s): D

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

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.



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

  1. From the Data menu select New Data Source
  2. From the Data menu select Replace Data Source
  3. From the File menu select Import Workbook
  4. From the File menu select New

Answer(s): A

Explanation:

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page.


Reference:

https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm When connecting to a dataset in Tableau Desktop, you would go to the 'Data' menu and select 'New Data Source'. This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.



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?

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

Answer(s): A

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

In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.



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?

  1. Publish the dashboard to Tableau Public
  2. Print the dashboard to PDF
  3. Publish the dashboard to Tableau Server
  4. Export the dashboard as a .twbx

Answer(s): C

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 When sharing sensitive and confidential information that needs to be kept up-to-date, such as patient health data for a team of healthcare workers, the best practice is to publish the dashboard to Tableau Server. Tableau Server is designed for secure, controlled access and can be configured to ensure that data is refreshed as needed. Publishing to Tableau Public is not secure for confidential data, printing to PDF or exporting as a .twbx does not allow for live data updates.



You have the following dataset.



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

  1. {FIXED: [Region] SUM Sales}
  2. {FIXED: SUM Sales}
  3. {Fixed: [Region]: TOTAL Sales}
  4. {FIXED: TOTAL (Sales)}

Answer(s): B

Explanation:

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

https://help.tableau.com/current/pro/desktop/en-
us/functions_functions_tablecalculation.htm#TOTAL






Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam dumps with other Community members:

Join the Certified Tableau Data Analyst Discussion