Last Updated On : 20-Feb-2026


Salesforce Certified Tableau Data Analyst Practice Test

Prepare with our free Salesforce Certified Tableau Data Analyst sample questions and pass with confidence. Our Salesforce-Tableau-Data-Analyst practice test is designed to help you succeed on exam day.

97 Questions
Salesforce 2026

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

Which type of object should you use?

A. Image

B. Sheet

C. Web page

D. Horizontal

A.   Image

Explanation:

In Tableau, watermarks such as “DRAFT” are static visual elements that must be easily positioned and layered within a dashboard. The Image object is designed for inserting pictures, logos, or text graphics. By floating an image, you can place it behind or over other objects, resize it, and maintain a consistent appearance across dashboards. Other objects like sheets or containers are intended for displaying data or layout management, not static overlays.

Correct Option:

✔️ Image
The Image object is the recommended way to add a watermark. It allows you to upload a graphic (e.g., “DRAFT”) and place it anywhere on the dashboard. You can float it above or below other components, adjust transparency if needed, and ensure it does not interfere with data visualizations. This provides full control over appearance and placement.

Incorrect Options:

❌ Sheet
Sheets are for visualizing data (charts, tables, maps) and are dynamic by nature. Using a sheet to create a watermark is inefficient because you would need to manually format a text visualization, which cannot be layered flexibly like an image. Sheets are not intended for static branding elements.

❌ Web page
A Web Page object embeds online content within the dashboard. While it could theoretically display an image hosted online, it introduces unnecessary complexity, potential load issues, and is difficult to layer. It is not meant for simple static elements like watermarks.

❌ Horizontal
Horizontal objects are layout containers used to organize multiple dashboard components side by side. They cannot display any content themselves, so they cannot be used to show a watermark. Their purpose is purely structural.

Summary:
To add a “DRAFT” watermark in Tableau, the Image object is the correct choice because it is designed for static visuals, allows flexible placement and layering, and ensures the watermark does not interfere with data. Other options like Sheet, Web Page, and Horizontal are either for dynamic content or layout purposes, making them unsuitable for watermarks.

Reference:
Tableau Official Documentation – Create a Dashboard

Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?

A. { FIXED [Customer ID] : MIN([Purchase Date]) }

B. MIN([Purchase Date])

C. [Customer ID] : { [Purchase Date] }

D. [Customer ID] : MIN([Purchase Date])

A.   { FIXED [Customer ID] : MIN([Purchase Date]) }

Explanation

This question tests your understanding of how to perform a grouped calculation that is independent of the visual layout. The requirement is to find the first (minimum) purchase date for each customer, even when the Customer ID is not present in the view. This is a classic use case for a Level of Detail (LOD) expression in Tableau. A FIXED LOD expression computes a value using the specified dimensions (here, [Customer ID]) regardless of what is in the view, which is precisely what is needed to solve this problem .

✅ Correct Option

A. { FIXED [Customer ID] : MIN([Purchase Date]) }
This is the correct syntax for a FIXED Level of Detail expression in Tableau. The part before the colon, [Customer ID], defines the dimension at which the calculation will be performed. The part after the colon, MIN([Purchase Date]), is the aggregate calculation. Together, this expression instructs Tableau to find the earliest purchase date for each Customer ID, and this value will be available in the visualization even when the Customer ID field is removed from the view.

❌ Incorrect Options

B. MIN([Purchase Date])
This is a simple table calculation or measure aggregation. Without being grouped by [Customer ID] in the view, this function would not calculate the date per customer. Instead, it would return the single earliest [Purchase Date] found across the entire dataset, which is not the requested outcome. It lacks the grouping logic required to segment the result by each individual customer.

C. [Customer ID] : { [Purchase Date] }
This syntax is completely invalid in Tableau. It incorrectly places the dimension outside the LOD curly braces and, more critically, omits any aggregate function (like MIN, MAX, or AVG). An LOD expression must always include an aggregation to be meaningful. Tableau's calculation engine would reject this structure due to these fundamental syntax and logical errors.

D. [Customer ID] : MIN([Purchase Date])
This is not a recognized syntax for any calculation type in Tableau. While it attempts to imply a relationship between the dimension and the measure, it is missing the essential components of a valid LOD expression (the curly braces {} and a keyword like FIXED) and is also not a standard grouped calculation, which would typically be defined using the INCLUDE or EXCLUDE keywords or simply by dragging dimensions to the view.

📝 Summary
To find the first purchase date per customer independent of the view's dimensions, a FIXED LOD expression is required. Option A uses the correct syntax to compute the minimum purchase date for each customer ID, which will persist even when Customer ID is filtered out of the view.

🔗 Reference
For the definitive guide on this topic, please consult the "Create Level of Detail Expressions" section in the official Tableau Documentation.

A Data Analyst has received a request to provide a dashboard related to employee time logs. The employees are entering their time using mobile devices throughout the day and data is stored in a cloud-based database. The end users would like to receive data on their dashboard in as close to real-time as possible.
How should the analyst best create a data source to meet these requirements?

A. Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection and disable any firewalls on the database.

B. Create a connection to the database to retrieve the data using Tableau Bridge. Schedule the refresh of the data extract to 15 minutes.

C. Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection, ensuring the database firewall has been configured to allow connections from Tableau Cloud.

D. Create a connection to the database using Tableau Desktop and retrieve an extract of the data. Publish the data source from Tableau Desktop to Tableau Cloud and schedule the refresh of the extract.

C.   Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection, ensuring the database firewall has been configured to allow connections from Tableau Cloud.

Explanation

When the requirement is for data that is "as close to real-time as possible," a live connection is inherently superior to a scheduled extract refresh. Since the data is stored in a cloud-based database, a live connection from Tableau Cloud is feasible, provided the necessary network security (like the firewall) is correctly configured to allow the connection. This setup ensures that every dashboard interaction queries the most current data directly from the source.

✅ Correct Option: C

Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection, ensuring the database firewall has been configured to allow connections from Tableau Cloud.
This option is ideal for real-time needs. A live connection is the only way to get data immediately upon being recorded, avoiding the delay of scheduled extracts. Publishing this live connection to Tableau Cloud makes it accessible to end-users. The crucial step is configuring the database firewall to explicitly authorize the specific IP addresses or domain of Tableau Cloud, ensuring a secure and reliable data flow.

❌ Incorrect Options

A. Create a connection to the database using Tableau Desktop. Publish the data source to Tableau Cloud using a live connection and disable any firewalls on the database.
This option correctly identifies the need for a live connection but suggests a highly insecure practice: disabling firewalls. While disabling a firewall would allow the connection, it severely compromises the security of the underlying database, making the entire system vulnerable. Security best practices mandate allowing connections only from specific, necessary sources (like Tableau Cloud), not disabling the firewall entirely.

B. Create a connection to the database to retrieve the data using Tableau Bridge. Schedule the refresh of the data extract to 15 minutes.
This approach uses a data extract and a 15-minute refresh schedule, which directly contradicts the "as close to real-time" requirement, as the data will be at least 15 minutes old at any given time. Furthermore, Tableau Bridge is typically used to connect Tableau Cloud to on-premise or private network data sources, not standard cloud-based databases, making its inclusion here likely unnecessary.

D. Create a connection to the database using Tableau Desktop and retrieve an extract of the data. Publish the data source from Tableau Desktop to Tableau Cloud and schedule the refresh of the extract.
Like option B, using an extract and a scheduled refresh introduces an unacceptable delay for a real-time requirement. Extracts, even if refreshed frequently, are snapshots of data and will not reflect the time log entries instantaneously. This method is best for improving dashboard performance with less real-time data needs, not for immediate data visibility.

📖 Reference
Tableau Official Documentation: Live Connections vs. Extracts
Source: Tableau Help: Live Connections vs. Extracts (Search for "Tableau Live Connections vs. Extracts" on the official Tableau website)

Note: The official documentation emphasizes that live connections should be used for scenarios requiring access to the most up-to-date data, provided the underlying data source performance is adequate. Security configuration (like firewalls) for live connections to cloud databases is a standard, required step.

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?


Explanation

Tableau dashboards support several ways to move between views, but only one object is specifically built to let users click once and seamlessly switch to a different dashboard in the same workbook — without opening new tabs, writing URLs, or relying on worksheet actions. That object is the Navigation button.

Correct Answer: Navigation object ✔️

The Navigation object is the official, recommended way to create clickable buttons that take users to another dashboard.

➡️Drag Navigation from the Objects pane (under Dashboard) onto your canvas
➡️Click “Edit Button” (or double-click it) → choose Navigate to → select the target dashboard from the dropdown
➡️Customize appearance: change text (“Go to Executive Summary”), pick an icon, adjust colors, or even use an image as the button
➡️When published, it works perfectly on Tableau Server, Online, Reader, and mobile apps — one click instantly swaps the entire view

This keeps navigation intuitive, maintains context, and requires zero maintenance when dashboard names change.

Reference:
Tableau Official – Use a Button to Navigate Between Dashboards

A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server?
(Choose three.)

A. Run a refresh

B. Change the refresh from full to incremental

C. Delete the refresh

D. Modify the frequency of the refresh

E. Change the priority of the refresh

A.   Run a refresh
C.   Delete the refresh
D.   Modify the frequency of the refresh

Explanation

The Extract Refresh management interface on Tableau Server (or Tableau Cloud) provides control over all scheduled refresh tasks for published extracts. An analyst with appropriate permissions (Data Owner, Creator, or Administrator) can perform several actions on an existing schedule. These include running a refresh immediately ($\text{A}$), deleting the schedule entirely ($\text{C}$), and modifying the schedule's frequency (e.g., changing it from daily to weekly or adjusting the time, which is part of $\text{D}$, Change Schedule).

Options Analysis

✔️ Correct Option: [A] Run a refresh
The Run Now or Run option allows an analyst to manually initiate a full or incremental extract refresh on demand, outside of its set schedule. This is a common administrative task used for immediate data updates or for testing refresh functionality after making changes.

❌ Incorrect Option: [B] Change the refresh from full to incremental
The setting that defines an extract as Full or Incremental is configured in Tableau Desktop (or Web Authoring) before the extract is published to the server. This setting requires specifying a tracking column and cannot be changed directly from the extract refresh schedule management page on Tableau Server once published. To change the type, the analyst would need to re-publish the extract after modifying it in Tableau Desktop.

✔️ Correct Option: [C] Delete the refresh
The Delete option allows the analyst to remove an existing extract refresh schedule. This cancels all future scheduled runs of that specific refresh task, such as removing a redundant schedule or one that is no longer needed.

✔️ Correct Option: [D] Modify the frequency of the refresh
The Change Schedule option lets the analyst reassign the extract refresh task to a completely different schedule (e.g., changing from the "Morning Daily" schedule to the "Weekend Weekly" schedule). This modifies the timing and frequency of the extract refresh.

❌ Incorrect Option: [E] Change the priority of the refresh
The priority of an extract refresh task is typically set at the Schedule level (e.g., within the Schedules admin view on Tableau Server) to manage the order in which jobs run. While administrators can often change a job's priority, this action is distinct from the primary options available for managing the scheduled task itself (Run, Delete, Change Schedule) on the extract refresh page, and is often an Administrator-level function.

Reference 🔗
Tableau Help: Manage Refresh Tasks

Salesforce-Tableau-Data-Analyst Exam Questions - Home
Page 2 out of 20 Pages