Salesforce Certified Tableau Data Analyst Practice Test 1

Free Salesforce Certified Tableau Data Analyst Practice Test 1 is a timed rehearsal before the paid exam. The credential shows you can connect data, prepare it, and publish decisions with Tableau Desktop, Tableau Prep, and Tableau Server or Cloud. No prerequisite is required. The official exam runs 105 minutes, costs $200, and uses 60 scored questions plus five unscored items, with a 65 percent pass mark. Banks and care systems already run on this stack. JPMorgan Chase expanded Tableau across hundreds of teams, Charles Schwab equipped more than 16,000 people, and CVS Health uses analytics to coordinate care. Pay is banded, not fixed. In September 2026, ZipRecruiter put the average junior data analyst near $79,352, with most offers from $57,000 to $81,500. A 2026 PayScale view placed data analysts at $56,000 to $99,000 and senior data analysts at $77,000 to $128,000. BI analyst postings often sit from $76,000 to $116,000. Desktop Foundations, $75 and 70 minutes, is the starter badge. AI and data science seats pay more once models sit beside the dashboard. SynergisticIT JOPP helps jobseekers get certified, prepared, and hired through the Java DevOps Full Stack JOPP and the Data Science JOPP. To learn how to get hired as a data engineer, data scientist, data analyst, AI or ML engineer, or software engineer, use the SynergisticIT contact page and JOPP.

Welcome to your Tableau Data Analyst – Test-01

Name

Phone

Q1. You are given a task to replace the data source. Choose the correct steps in order:

1. Go to the sheet tab and select Data > Replace Data Source.
2. Open a new sheet where you want to replace the data source
3. On the Data Source page, drag a table to the canvas to set up the data source (if this isn’t automatically done for you).
4. Open a workbook that connects to the original data source.
5. In the Replace Data Source dialog box, select the Current data source and the Replacement data source.
6. When finished, click OK.
7. Select Data > New Data Source and then connect to the new data source.

Select 1 option(s):

4-7-3-1-5-6

2-7-3-1-5-6

4-7-2-3-5-1-6

2-7-4-3-1-5-6

7-4-3-1-5-6

Q2. You are given two data sets. The result should be to show all customers and their corresponding sales records using a custom SQL query:

Sales: Customers:

Tableau data visualization practice test with numerical data and ID values.

Tableau data visualization practice quiz, sample data table with names

Select 1 option(s):

SELECT * FROM Sales
LEFT JOIN Customers
ON Sales.ID=Customers.ID
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID AND Customers.Name = Sales.Value
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID
WHERE Name = ‘Phillina Ober‘;

Q3. Which of the following is valid about Published Data Source when you sign in Tableau Server Site?

Select 1 option(s):

You can see all data on Tableau Server which you have access

You can see all data on Tableau Server Site which you have access

You can see all data on Tableau Server

You can see all data on Tableau Server Site

Q4. You need to open *twb file on your Tableau desktop. Choose the appropriate section to open it.

Tableau Server export options including Excel, JSON, PDF, and Amazon Redshift.

Select 1 option(s):

Tableau Server

Microsoft Excel

Text File

More... (To a File)

JSON File

PDF File

Q5. You are given a task to combine these two data sources but keep duplicate records. Choose the appropriate custom SQL statement.

Data1:

Tableau data visualization of sales by state, including New York and Texas data.

Data2:

Tableau data visualization of state and value data for business intelligence assessment.

Select 1 option(s):

JOIN

UNION

LEFT JOIN

RIGHT JOIN

UNION ALL

Q6. Select all true statements about ad-hoc calculations.

Select 3 option(s):

Ad-hoc calculations are not available when you create groups, sets, hierarchies, or parameters.

Ad-hoc calculations are valid for creating trend lines, forecasts, reference lines, bands, and distributions.

Only one ad-hoc calculation can be open at a time.

Ad-hoc calculations are supported on the Rows, Columns, Marks, and Pages shelves.

All of the above

Q7. What best describes how this FIXED expression works in a view?

{FIXED : SUM([Sales])}

Tableau data visualization of order dates and categories, demonstrating business intelligence analysis.

Select 1 option(s):

Calculates the sum of sales of each Category and Year.

Calculates the sum of sales for each Category and Year.

Calculates the total sum of sales

Calculates the sum of sales of the Category in each Year.

Q8. Choose the way how to get this “Draft“ sign in a dashboard.

Select 1 option(s):

Image Objects

Navigation Objects

Web Page Objects

Blank Objects

Q9. Which filter do you use to get sub-categories with sales over 100K?

Tableau data analysis practice quiz results displaying categories and numerical values.

Select 1 option(s):

Top filter

General Filter

Condition filter

Wildcard filter

Q10. How to get sales data by category only for 2020?

Tableau data visualization of order dates and categories, illustrating sales trends from 2019 to 2022.

Select 1 option(s):

FIRST()=-1

FIRST=1

FIRST=2

FIRST(-1)

FIRST(1)

Q11. You have a Profit.tsv file. Which section do you choose to open it in Tableau Prep Builder?

Tableau data source options and search bar for Tableau Data Analyst practice assessment.

Select 1 option(s):

Microsoft Excel

PDF file

Tableau extract

Tableau Server

Text file

Spatial file

Q12. Choose the correct answer:

RANK(_______)

Select 1 option(s):

SUM([Sales])

[Sales]

SUM(Sales)

Sales

Q13. Which of the following export options are available from the Tableau worksheet?

Select 3 option(s):

.pptx

.png

.html

.csv

.xlxs

Q14. There are two dashboards in the workbook. Which object is used to move to the next dashboard

Select 1 option(s):

Web Page

Blank

Navigation

Link

Go to sheet

Go to URL

Q15. Which month shows a higher percent increase?

Tableau chart visualizing sales trends and percentage differences by month.

Select 1 option(s):

March

May

December

September

Q16. You used Data Interpreter and based on the result how many rows will be shown in Tableau as values?

Tableau data visualization of sales report with city, state/province, and year data.

Select 1 option(s):

Q17. Which type of join should be used when you want to keep all the records from both tables, but only match those that have matching values in both tables?

Select 1 option(s):

Inner Join

Left Join

Right Join

Full Outer Join

Q18. You have a data set that contains the Date, Sales, Profit, and Quantity fields. To create the view in the picture, choose the correct steps.

Tableau line chart visualizing sales, profit, and quantity data over time.

Select 1 option(s):

Drag Date to the Columns, Measure Values to the Rows, and Measure Names to the Colors.

Drag Date to the Columns, Sales, Profit, and Quantity to the Rows, set Quantity to Dual Axis, drag Measure Names to the Rows

Drag Date to the Columns, Sales and Profit to the Rows, set Profit to Dual Axis, drag Quantity next to Dual Axes, Measure Names to the Rows

Drag Date to the Rows, Measure Values to the Columns, and Measure Names to the Colors.

Q19. Which of the following gives the moving average of Profit for 5 days?

Select 1 option(s):

WINDOW_AVG(SUM([Profit]), -4, 0)

MOVING_AVG(SUM([Profit]), -4, 0)

WINDOW_AVG(SUM([Profit]), -5, 0)

MOVING_AVG(SUM([Profit]), -5, 0)

Q20. Choose valid syntaxes for a Level of Detail (LOD) expression in Tableau.

Select 4 option(s):

{SUM([Sales])}

{INCLUDE [Category] : AVG([Profit])}

{EXCLUDE [Date] : MAX([Revenue])}

{AGG([Sales]) : MIN([Profit])}

{FIXED : SUM([Sales])}

Q21. Which of the following calculations gives that result?

Tableau data visualization example with first name, last name, and result columns.

Select 1 option(s):

CONCATENATE([First Name], [Last Name])

[First Name] + [Last Name]

[First Name] + ‘ ‘ + [Last Name]

REPLACE([First Name], [Last Name])

Q22. Which of the following returns part of a given date as an integer?

Select 1 option(s):

DATEPART()

DATENAME()

DATETRUNC()

MAKEDATE()

Q23. You have a dataset with a “Date“ field that contains dates in the format “MM/DD/YYYY“. You want to create a view that shows the sum of sales by quarter. Which Tableau function would you use to accomplish this?

Select 1 option(s):

DATEADD

DATEDIFF

DATEPART

DATETRUNC

Q24. Choose the correct output file type in Tableau Prep.

Select 3 option(s):

Tableau Data extract

Microsoft Excel

Comma Separated Values

Power Point

Microsoft Word

Q25. What does that icon mean?

Tableau data analytics interface with dimensions and measures for data visualization.

Select 1 option(s):

The workbook is directly connected to a relational data source or file.

The workbook is connected to a cube (multidimensional) data source. In Tableau, cube data sources are supported only in Windows.

The workbook is connected to an extract that still references the underlying data.

The workbook is connected to an Excel table, sub-table, or named range.

The workbook is connected to a data source that has been published to Tableau Server.

Q26. In Tableau Server, what is the minimum frequency at which you can schedule a data extract refresh?

Select 1 option(s):

Every 15 minutes

Every 30 minutes

Every hour

Every day

Every 2 hours

Q27. What is the most appropriate grouping method for this case in Tableau Prep?

Tableau data visualization example with library names and data fields.

Select 1 option(s):

Automatic

Pronunciation

Spelling

Common characteristics

Manual Selection

Q28. Choose the valid worksheet action(s) in Tableau.

Select 3 option(s):

Filter

Highlight

Go to Dashboard

Change Group Values

Go to URL

Q29. If Tableau Prep Builder samples the data in the input step, which of the following occurs?

Select 1 option(s):

The entire data set is used in the flow and to create the output.

The sampled data is used in the flow and to create the output.

The entire data set is used in the flow, but the sampled data is used to create the output.

The sampled data is used in the flow, but the entire data set is used to create the output.

Q30. You are given a data set which contains twitter handle of users. You need to get their first name only but first letter should be the Capital letter. Choose the correct functions.

Data set:

Twitter usernames list for Tableau data analyst practice assessment by SynergisticIT.

Expected Result:

Tableau data analyst practice quiz with first name fields and sample names.

_____(_____(_____([Twitter], 2), ‘_‘, 1))

Select 1 option(s):

PROPER, SPLIT, MID

SPLIT, UPPER, MID

UPPER, SPLIT, MID

MID, SPLIT, LOOKUP

CONTAINS, UPPER, SPLIT

FIND, UPPER, SPLIT

Q31. According to Tableau‘s Order of Operations, which of the following operations is performed first, and which one is the last?

Select 2 option(s):

Context Filters

Table Calc Filters

Extract Filters

Measure Filters

Dimension Filters

Data Source Filters

Q32. Which of the following fields would be appropriate to get the color palette on the map?

US states map visualizing Tableau data analysis skills distribution.
1)

Tableau data analysis visualization dashboarding practice quiz for SynergisticIT training.
2)

Tableau data analysis visualization practice quiz for SynergisticIT job seekers
3)

Tableau data analysis categories and visualization examples for SynergisticIT skill assessment.
4)

Tableau data analysis practice quiz illustrating profit visualization and business intelligence skills.
5)

Tableau location data visualization for data analysis practice assessment
6)

Tableau data analysis practice quiz with discount offer for SynergisticIT training.

Select 2 option(s):

Q33. This is the Sales by Cities sorted in Descending order. You are given a task to take the TOP 10 cities by Sales for the last month in the data set. When the records come in for the upcoming months, the TOP 10 cities should be updated accordingly. Choose the correct answer(s)

Tableau data visualization of sales by city, illustrating Tableau Desktop skills for data analyst certification.

Select 1 option(s):

Select TOP 10 cities in the view, right-click and choose Group

Select TOP 10 cities in the view, right-click and choose Create Set

Right-click City field in the Data pane, create a set with TOP 10 option by Sales field

Right-click City field in the Data pane, create a set with Condition option by setting Sales field greater than 43K.

Right-click City field in the Data pane, create a group by choosing first 10 city names in the list

Q34. Which of the following gives MEDIAN([Sales])?

Select 1 option(s):

PERCENTILE([Sales],.5)

WINDOW_MIN([Sales],.5)

RANK_PERCENTILE([Sales],.5)

WINDOW_MEDIAN([Sales],.5)

WINDOW_PERCENTILE([Sales],.5)

Q35. Choose the correct calculation(s)

Select 3 option(s):

SUM(Price)*[Quantity]

SUM(Price*Quantity)

SUM(Price)*SUM(Quantity)

[Price]*SUM(Quantity)

SUM(Price)*10

Q36. What is the shaded region in the picture?

Tableau data visualization of sales trends over time for data analyst practice assessment.

Select 1 option(s):

Forecast Indicator

Prediction Interval

Seasonal Pattern

Forecast Length

Q37. How do you get that result?

Tableau data visualization showing Region, Sales, and Result metrics for data analysis practice assessment.

Select 1 option(s):

CEILING([Sales])

FLOOR([Sales])

ROUND([Sales],1)

BUFFER([Sales])

Q38. What can you publish into Tableau Server?

Select 2 option(s):

Workbooks

Views

Data Sources

Worksheets

Stories

Q39. You want to create a table showing the number of orders by category. What steps should be taken?

Select 1 option(s):

Create a function using COUNTD([Order ID]), drag the function to the row shelf then Category to the column shelf.

Create a function using COUNT([Order ID]), drag the function to the column shelf then Category to the row shelf.

Create a function using COUNT([Order ID]), drag the function to the text shelf then Category to the row shelf.

Create a function using UNIQUE ([Order ID]), drag the function to the row shelf then Category to the column shelf.

Q40. What does this data story type shape mean in Tableau?

Tableau data visualization concept illustrating upward trend and data analysis.

Select 1 option(s):

Describes how something your audience cares about relates to the bigger picture.

Shows how two or more subjects differ.

Sets context so that your audience better understands what‘s going on in a particular category.

Uses a chronology to illustrate a trend.

Highlights important shifts when one category overtakes another.

Q41. Which of the following statements about aliases in Tableau is true?

Select 1 option(s):

Changing the alias of a field will change the underlying data source

Aliases can only be applied to discrete dimensions, not continuous dimensions

Aliases can be created for a discrete measure

Aliases can be created for the dates

Q42. Which statement will replace missing values with 0‘s in the table below?

Select 1 option(s):

ISNULL([Sales])

IFNULL(LOOKUP(SUM([Sales]),0),0)

IFNULL([Sales],0)

ZN(LOOKUP(SUM([Sales]),0),0)

Edit Aliases and replace null with 0

Q43. How to create a Quick LOD expression?

Select 1 option(s):

Control-click (or Command-click on a Mac) the measure you want to aggregate and drag it to the dimension you want to aggregate on.

Right-click on the selected measure and select Create > LOD Calculation.

Click on the selected measure, go to the Analysis menu, and select Quick LOD

Click the drop-down icon on the data pane and select Create Calculated Field

Q44. Choose the correct steps to create this scatter plot

Tableau scatter plot visualizing sales versus profit by category: Furniture, Office Supplies, and Technology.

Select 4 option(s):

Drag the Profit measure to Rows.

Drag the Category dimension to Color on the Marks card.

Drag the Sales measure to Rows.

Drag the Category dimension to Size on the Marks card.

Drag the Sales measure to Columns.

Drag the Order ID dimension to Details on the Marks card.

Q45. What needs to create a pie chart?

Select 2 option(s):

At least 1 dimension

At least 1 measure

1 or 2 measures

1 or 2 dimensions