Salesforce-Tableau-Data-Analyst Exam Questions With Explanations
The best Salesforce-Tableau-Data-Analyst practice exam questions with research based explanations of each question will help you Prepare & Pass the exam!
Over 15K Students have given a five star review to SalesforceKing
Why choose our Practice Test
By familiarizing yourself with the Salesforce-Tableau-Data-Analyst exam format and question types, you can reduce test-day anxiety and improve your overall performance.
Up-to-date Content
Ensure you're studying with the latest exam objectives and content.
Unlimited Retakes
We offer unlimited retakes, ensuring you'll prepare each questions properly.
Realistic Exam Questions
Experience exam-like questions designed to mirror the actual Salesforce-Tableau-Data-Analyst test.
Targeted Learning
Detailed explanations help you understand the reasoning behind correct and incorrect answers.
Increased Confidence
The more you practice, the more confident you will become in your knowledge to pass the exam.
Study whenever you want, from any place in the world.
Salesforce Salesforce-Tableau-Data-Analyst Exam Sample Questions 2026
Start practicing today and take the fast track to becoming Salesforce Salesforce-Tableau-Data-Analyst certified.
22124 already prepared
Salesforce 2026 Release212 Questions
4.9/5.0
From Tableau Desktop, a Data Analyst signs in to a site within Tableau Server. What appears in the list of available data sources when the analyst searches for a published data source?
A. All the data sources published to Tableau Server within the unlocked projects to which the analyst has access.
B. All the data sources published to Tableau Server.
C. All the data sources published to the site.
D. All the data sources to which the analyst has access within the site.
Explanation
The correct answer is D. All the data sources to which the analyst has access within the site. When a Data Analyst signs in to a site on Tableau Server from Tableau Desktop and searches for a published data source, Tableau displays only the data sources that the analyst has been granted permission to access within that specific site. Visibility is governed by project-level permissions and the user's site role. The analyst will not see data sources in projects they cannot access, nor will they see data sources from other sites on the same server. This makes option D the correct answer.
Why the other options are incorrect:
A. All the data sources published to Tableau Server within the unlocked projects to which the analyst has access
– This option is partially correct in spirit but overly narrow. It implies visibility is limited to "unlocked" projects, which is not the determining factor. Access is governed by permissions (such as View or Connect), not by whether a project is locked or unlocked. Option D is the more accurate and complete answer.
B. All the data sources published to Tableau Server
– This is incorrect because users cannot see all data sources on the server. Visibility is restricted by site membership and project permissions. A user only sees content within the sites and projects they have access to.
C. All the data sources published to the site
– This is incorrect because not all data sources on a site are visible to every user. Access is further restricted by project-level permissions. A user may be a member of the site but still lack access to specific projects or data sources.
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Connecting to Data and Permissions — specifically signing in to a Tableau Server site from Tableau Desktop, searching for published data sources, and permission-based visibility governed by project permissions and site roles.
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide
button.
To which two objects can you add the sheets? (Click the two appropriate Options in the
Answer Area.)

Explanation:
In Tableau, the native Show/Hide button feature is used to dynamically toggle the visibility of dashboard components, helping optimize layout space.
The Core Logic: A Show/Hide button cannot be applied to individual standalone worksheets directly if they are placed as fixed, tiled elements on the dashboard canvas. Instead, the button targets the container or object wrapper enclosing the content.
Supported Objects: * Floating Objects/Containers: Any dashboard object or layout container set to Floating can have a Show/Hide button enabled via its context drop-down menu.
Layout Containers (Vertical/Horizontal): Both Vertical and Horizontal containers natively support the Show/Hide functionality, whether they are floating or tiled. Placing sheets inside a Vertical container allows the entire container block to be toggled at once.
Why Other Options Are Incorrect:
Tiled: Standard tiled worksheets locked directly into the core dashboard grid framework do not support individual Show/Hide button triggers. They must be wrapped inside a layout container first.
Blank: A Blank object is used purely as a static spacing placeholder to add empty padding between dashboard components and cannot host sheet visibility toggles.
Text: A Text object renders static or dynamic string text blocks (such as titles or annotations) and cannot act as a functional layout wrapper for worksheets.
Extension / Web Page: These objects are used to embed web URLs or custom JavaScript API plug-ins rather than managing native sheet visibility structures.
References:
Tableau Documentation (Show and Hide Dashboard Containers):"You can add a Show/Hide button to any Floating object, or any Horizontal or Vertical layout container (tiled or floating) to let users show or hide the contents with the click of a button."
A Data Analyst has the following dataset:

The analyst wants to create a new calculated dimension field named Category that meets
the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
A. IF [Subject] = 'Science' THEN 'Sciences'
ELSEIF [Subject] = 'English' THEN 'Humanities'
ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'
ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'
END
B. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences')
C. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
END
ELSEIF [Subject] = 'English' THEN 'Humanities'
ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'
ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'
END
D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
END
Explanation:
You need to create a calculated dimension field named Category that maps each Subject to either "Sciences" or "Humanities" as follows:
Sciences: Computer Science, Science
Humanities: English, Social Studies
Both A and D correctly implement this logic.
Why A is correct:
The IF/ELSEIF statement explicitly checks each subject value and assigns the correct category.
It covers all four subjects and returns the appropriate Category for each.
The syntax is correct and will execute without errors.
Why D is correct:
The CASE statement is a clean and efficient way to map multiple discrete values to corresponding results.
It specifies each subject and its resulting Category.
Note: The CASE statement will return NULL for any subject not listed, but since the dataset only contains these four subjects, it works perfectly.
Why other options are incorrect:
B. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences'):
This formula is logically flawed. It checks if the subject contains the word "Science" (which would be TRUE for both "Science" and "Computer Science") and returns "Humanities" for those—which is the opposite of the requirement.
It would return "Sciences" only for subjects that do not contain "Science" (e.g., English, Social Studies), which is incorrect.
C. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END:
This only checks for "Computer Science" and returns "Sciences" for it.
For all other subjects (including "Science"), it returns "Humanities", which misclassifies "Science" (should be "Sciences").
It also does not handle "English" and "Social Studies" specifically, though they would fall into "Humanities" by default, which is coincidentally correct for those two.
Reference:
Tableau Help: Logical Functions – IF and CASE – Both IF and CASE statements can be used to create calculated dimension fields based on discrete conditions. CASE is typically cleaner for mapping multiple discrete values to results.
A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?
A. Inner
B. Left only
C. Left
D. Full outer
E. Union
Explanation
The analyst needs to perform an "anti-join" operation, which keeps records from the primary table that have no matching records in the secondary table. In Tableau Prep's join dialog, this is explicitly called a "Left only" join. This join type starts with a Left Join (keeping all records from Table1) and then filters out any records that successfully matched with Table2, leaving only the non-matching rows where all fields from Table2 will be null.
✅ Correct Option
🟢 B. Left only:
This is the specific join type designed for this "anti-join" scenario. It keeps all records from the left table (Table1) that do not have a match in the right table (Table2). For these unmatched records, all columns from Table2 will be populated with null values, exactly as the analyst requires.
❌ Incorrect Options
🔴 A. Inner:
An inner join would return only the records where there is a match between Table1 and Table2. This is the opposite of what is needed, as it would exclude the non-matching records from Table1.
🔴 C. Left:
A standard left join keeps all records from Table1, regardless of whether they match with Table2. Matching records show Table2 data, and non-matching records show nulls. However, this includes both matching and non-matching records, while the requirement is for only the non-matching ones.
🔴 D. Full outer:
A full outer join returns all records from both tables. It will include matching records, non-matching records from Table1, and non-matching records from Table2. This includes much more data than the specified requirement.
🔴 E. Union:
A union is used to stack rows from tables with similar structures on top of each other. It is not a join and cannot be used to horizontally combine tables based on matching keys, making it irrelevant for this scenario.
Summary
A "Left only" join is the precise tool for filtering a primary table to rows that have no corresponding data in a secondary table, resulting in null values for all secondary table fields.
Reference
Tableau Help: Combine Your Data
You have the following dataset.

You need to generate the results in the Day field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select
the correct options to complete the formula.)


Explanation:
This question tests your knowledge of Tableau's built-in date functions and how they return different string versus numeric outputs.
DATENAME vs. DATEPART: * DATENAME returns a string representing the specified part of a date (e.g., "Sunday", "Monday").
DATEPART returns an integer representing the specified part of a date (e.g., 1 for Sunday, 2 for Monday).
Since the output column Day in the source data (image_c15de9.png) contains text strings like "Sunday" and "Monday" rather than numbers, DATENAME must be used.
The Date Part Literal ('weekday'):
To get the name of the day of the week, the required date part literal string argument in Tableau is 'weekday'. Passing 'weekday' extracts the full localized text name of that particular calendar day.
References:
Tableau Documentation (Date Functions): DATENAME(date_part, date, [start_of_week]) returns the specified part of date as a string, where date_part can be 'weekday', 'month', 'year', etc.
Tableau Exam Guide: Distinguishing between string-returning functions (DATENAME) and integer-returning functions (DATEPART or DAY) is a standard requirement for core data analytics certification.
Prep Smart, Pass Easy Your Success Starts Here!
Transform Your Test Prep with Realistic Salesforce-Tableau-Data-Analyst Exam Questions That Build Confidence and Drive Success!
Frequently Asked Questions
Connect to and Transform Data (23%): Connecting to various data sources, performing data cleaning, applying joins, unions, and data blending, and using Tableau Prep for data preparation workflows.
Explore and Analyze Data (28%): Building calculations, using Level of Detail (LOD) expressions, applying filters, sorting, grouping, and performing statistical analysis to derive meaningful insights.
Create Charts and Visualizations (24%): Selecting the appropriate chart types, building bar charts, line charts, scatter plots, maps, heat maps, and using dual-axis views effectively.
Build Dashboards and Stories (16%): Designing interactive dashboards with actions, filters, and layout containers, and creating data stories that communicate findings clearly.
Share and Publish Content (9%): Publishing workbooks and data sources to Tableau Server or Tableau Cloud, managing permissions, and sharing insights with end users.
Time allowed: 120 minutes
Passing score: 65%
Exam fee: $250 USD
Retake fee: $125 USD
Delivery: Available online via Pearson VUE or at an authorized testing center
Level of Detail (LOD) Expressions: Understanding the difference between FIXED, INCLUDE, and EXCLUDE LOD expressions and knowing exactly when to apply each one is consistently reported as the hardest concept on the exam. These require strong analytical thinking beyond basic Tableau usage.
Table Calculations: Questions involving WINDOW functions, RUNNING totals, RANK, and PERCENTILE calculations often trip up candidates who have not practiced them extensively in real-world scenarios.
Data Blending vs. Joins: Knowing when to use data blending versus a traditional join, and understanding how aggregation behaves differently in each case, is a frequently tested and commonly misunderstood topic.
Dashboard Actions: Designing dashboards with filter actions, highlight actions, and URL actions in a way that delivers a smooth user experience requires both technical knowledge and practical hands-on exposure.
Spending extra study time on these four areas and practicing them in Tableau Desktop before your exam date will significantly improve your confidence and performance.
United States: Certified Tableau Data Analysts typically earn between $75,000 and $110,000 per year. Senior analysts and those working in finance, healthcare, or technology sectors often command salaries exceeding $120,000 annually.
United Kingdom: Salaries typically range from £45,000 to £70,000 per year depending on experience and location.
Canada and Australia: Professionals can expect annual earnings between CAD $70,000 to $100,000 and AUD $80,000 to $110,000 respectively.
Beyond base salary, certified professionals often gain access to performance bonuses, remote work opportunities, and faster career advancement compared to non-certified peers. The certification signals to employers that you can independently extract and communicate value from data, which is a highly sought-after skill across virtually every industry.
Industry Recognition: The certification is globally recognized and backed by Salesforce, one of the most trusted names in enterprise technology. It immediately adds credibility to your professional profile.
Career Advancement: Certified analysts are more likely to be considered for senior analyst, BI developer, and data consultant roles. Many employers specifically list Tableau certification as a preferred or required qualification in job postings.
Stronger Data Storytelling Skills: The preparation process itself deepens your ability to turn raw data into compelling visual narratives, a skill that is valuable in any business function including marketing, finance, operations, and product management.
Access to the Tableau Community: Certification grants access to an active global community of data professionals, exclusive Tableau events, and continued learning resources that keep your skills current as the platform evolves.
Competitive Job Market Advantage: In a crowded data job market, a recognized certification helps your resume stand out and demonstrates a verified, standardized level of competence that self-taught skills alone cannot always convey.