2 packs: 15% off with code BUY2. 3 or more: 20% off with code BUY3.

Free Salesforce Tableau Data Analyst Practice Questions

8 free Salesforce Tableau Data Analyst practice questions from the CertStash pack of 127, each with the correct answer and a full explanation. The rule is the same for every exam: ten free on the product page, 8 free here, all 127 in the pack, and each step includes the one before it.

Question 1

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?

  1. The My Content area of Tableau web pages
  2. The Data Source page of Tableau Desktop
  3. The Notifications area of Tableau Prep
  4. The Shared with Me page
Show answer and explanation

Correct answer: A. The My Content area of Tableau web pages

When a data-driven alert fails repeatedly, Tableau suspends it and emails the owner. The owner, or an administrator, can resume it from the My Content area of the Tableau web pages: the alert shows a suspension icon, and the actions menu for the alert offers Resume Alert. The notification email also contains a Resume Alert link. Alerts are a Tableau Server and Tableau Cloud feature managed in the browser, so the Desktop and Prep tools play no part in managing them.

Why the other options are wrong

  • B. The Data Source page of Tableau Desktop edits connections and has no access to server alerts.
  • C. Tableau Prep builds data flows and does not manage data-driven alerts.
  • D. The Shared with Me page lists content others shared with you, not the alerts you own.

Question 2

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. Both charts will use the same measure named Population on the axis.

You need to configure the 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 size of the marks independently
  2. For the second axis, select Shape on the Marks card. From Select Shape Palette, select Custom, and then select Reset
  3. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository.
  4. Change Population to a discrete dimension.
Show answer and explanation

Correct answer: A. Duplicate Population. Drag the duplicate to the second Marks card and configure the size of the marks independently

In a dual axis chart each measure on the axis has its own Marks card, and the Size setting on a card affects only that card's marks. Duplicating Population and placing the copy on the second axis gives the shape chart its own Marks card, so the shapes can be set to a large size while the line stays thin. This lets one measure be drawn twice with different mark types and sizes.

Why the other options are wrong

  • B. Resetting the custom shape palette changes which shapes are used, not their size.
  • C. A custom shape file is not needed, because the Size control on the Marks card sets mark size.
  • D. Making Population a discrete dimension removes the axis that the dual axis chart depends on.

Question 3

A colleague provides you with access to a folder that contains the following files:

• Sales.csv

• Book1.twb

• Sales.hyper

• Export.mdb

Which file contains an extract?

  1. Export.mdb
  2. Sales.hyper
  3. Book1.twb
  4. Sales.csv
Show answer and explanation

Correct answer: B. Sales.hyper

Tableau stores extracts in the .hyper format. An extract file is a local copy of a subset or all of the data, so Sales.hyper is the file that contains an extract. A .twb workbook holds only the workbook definition and connection information, and the other two files are source data files that Tableau can connect to.

Why the other options are wrong

  • A. Export.mdb is a Microsoft Access database file, not a Tableau extract.
  • C. A .twb file holds the workbook definition and contains no data.
  • D. Sales.csv is a plain text data file that Tableau can connect to, not an extract.

Question 4

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. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
  2. From Tableau Server, select Schedules, and change the priority of the existing schedule.
  3. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
  4. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
Show answer and explanation

Correct answer: A. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.

An extract can have more than one refresh task. To keep the Monday refresh and also refresh on the last day of each month at 18:00, open the workbook on Tableau Server, go to its extract refreshes and create a new refresh task on a monthly schedule. The existing task is left alone, so both refreshes run.

Why the other options are wrong

  • B. Changing the priority only affects the order of jobs and adds no new refresh time.
  • C. The refresh schedule is managed on the server, so the Desktop publishing step is not the place to add a second refresh.
  • D. Changing the existing schedule would replace the Monday refresh instead of adding to it.

Question 5

You need to change the values of a dimension without creating a new field.

What should you do?

  1. Rename the fields.
  2. Create aliases.
  3. Create groups.
  4. Transform the fields.
Show answer and explanation

Correct answer: B. Create aliases.

Aliases give dimension members alternate display names, so the values appear differently in the view without any new field being created. The field and its underlying data stay the same, and only the labels shown in headers, legends and marks change. Aliases can be edited from the field's context menu in the Data pane.

Why the other options are wrong

  • A. Renaming changes the name of the field, not the values it contains.
  • C. Creating groups adds a new group field to the data pane.
  • D. Transforming fields, such as splitting them, creates new fields.

Question 6

You have a Tableau workbook that contains three worksheets named Sheet1, Sheet2, and Sheet3.

You create several filters.

From the Data Source page, you plan to add data source filters.

Which type of filter will appear in the Edit Data Source Filters dialog box?

  1. A context filter on a dimension in Sheet3
  2. A table calculation filter used on Sheet2
  3. A top N condition filter on a dimension in Sheet1 and Sheet2
  4. A dimension filter on all the sheets
Show answer and explanation

Correct answer: D. A dimension filter on all the sheets

When you open Edit Data Source Filters, Tableau automatically lists global filters that use the data source, and clicking OK promotes them to data source filters. A dimension filter applied to all the sheets is a global filter, so it appears in the dialog. Filters that apply only to some sheets, context filters and table calculation filters belong to the worksheet and are not listed.

Why the other options are wrong

  • A. A context filter on one sheet is a worksheet filter and is not shown in the dialog.
  • B. Table calculation filters are applied after the query and cannot be data source filters.
  • C. A filter used on only some of the sheets is not a global filter, so it is not listed.

Question 7

From Tableau Desktop, you sign in to a Tableau Server site.

What appears in the list of available data sources when you search for a published data source?

  1. All the data sources published to the Tableau Server
  2. All the data sources published to the site within the folders to which you have access
  3. All the data sources published to the Tableau Server within the folders to which you have access
  4. All the data sources published to the site
Show answer and explanation

Correct answer: B. All the data sources published to the site within the folders to which you have access

When Tableau Desktop is signed in to Tableau Server, you work within one site. Searching for published data sources lists only those published to that site, and only those in projects where your permissions let you see and connect to them. Content on other sites of the server, and content you have no permission for, does not appear.

Why the other options are wrong

  • A. Data sources on other sites and those without permission are not listed.
  • C. Desktop connects to one site at a time, so data sources on other sites are not listed.
  • D. Permissions still apply, so data sources you cannot access are not listed.

Question 8

You have a dashboard that contains confidential information about patients’ health.

The data needs to always be up to date for a team of healthcare workers.

How should you share the dashboard with the healthcare workers?

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

Correct answer: C. Publish the dashboard to Tableau Server

Publishing to Tableau Server keeps the dashboard connected to its data so it can be kept up to date through live connections or scheduled refreshes, and permissions restrict who can see it. Only the healthcare team needs access, and the data is confidential, so a secured, centrally managed server is the right place to share it.

Why the other options are wrong

  • A. A packaged workbook is a snapshot copy that goes out of date and cannot control who opens it.
  • B. Tableau Public makes content publicly visible, which is unsuitable for confidential health data.
  • D. A PDF is a static snapshot that is never updated.

That was 8 of 127.

The full Salesforce Tableau Data Analyst pack has all 127 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.

Get the full pack

Not ready yet? Get the first 83 free as one PDF by email. Get the Half Pack →