Certified Tableau Data Analyst Practice Exam

Join Us Among the Stars

Sign Up & unlock 100% of Exam Questions

Log in / Sign up

No Strings Attached!

127Practice Questions

3Study Modes

Free

TopicSort

Question 1

Explore and Analyze Data

A Data Analyst has the following dashboard.

Question Image

From the drop-down menu of Sales over time, the analyst selects Ignore Actions.
Several days later, the analyst wants to filter both Sales over time and Detail table by selecting a datapoint on the map.
What should the analyst do?

A Select Use as Filter from the drop-down menu of Sales over time, and then deselect Use as Filter.
B Select Ignore Actions from the drop-down menu of Detail table.
C Deselect Use as Filter from the drop-down menu of Profits by state, and then select Use as Filter.
D Select Filters from the drop-down menu of Sales over time, and then select Enable Auto Update.

Question 2

Connect to and Transform Data

Question 3

Explore and Analyze Data

Question 4

Create Content

Question 5

Explore and Analyze Data

Question 6

Create Content

Question 7

Create Content

Question 8

Connect to and Transform Data

Question 9

Explore and Analyze Data

Question 10

Publish and Manage Content on Tableau Server and Tableau Cloud

Question 11

Explore and Analyze Data

Question 12

Explore and Analyze Data

Question 13

Explore and Analyze Data

Question 14

Connect to and Transform Data

Question 15

Explore and Analyze Data

Question 16

Connect to and Transform Data

Question 17

Explore and Analyze Data

Question 18

Connect to and Transform Data

Question 19

Explore and Analyze Data

Question 20

Publish and Manage Content on Tableau Server and Tableau Cloud

Question 21

Explore and Analyze Data

Question 22

Create Content

Question 23

Create Content

Question 24

Explore and Analyze Data

Question 25

Publish and Manage Content on Tableau Server and Tableau Cloud

Page 1 of 6 • Questions 1-25 of 127

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

A Data Analyst has the following dataset.

Question Image

The analyst plans to create a dashboard that will be filtered to shown only data that is relevant to a specific Tableau user based on the Tableau_User_Name field.
The analyst needs to create a boolean calculated field to place on the data source filter.
Which formula should the analyst use for the filter?

A [Name] = [Tableau_User_Name]
B USERNAME () = [Tableau_User_Name]
C [Name] = USERNAME ()
D ISFULLNAME ( [ Tableau_User_Name] ) = USERNAME ()

A Data Analyst needs to filter a view to include only events that have occurred year to date.
Which formula accomplishes this?

A [Event Date] > TODAY()AND DATETRUNC( “year”, [Event Date]) = DATETRUNC(“year”, TODAY() )
B [Event Date] <= TODAY()AND DATETRUNC( “year”, [Event Date] = DATETRUNC( “year”, TODAY() )
C DATETRUNC( “year”, [Event Date]) = DATETRUNC(“year”, TODAY() )
D [Event Date] <= DATETRUNC( “year”, [Event Date])

What is a valid CASE statement?

A CASE SUM ([Profit])>0 -WHEN TRUE THEN “Profitable”ELSE “Unprofitable”END
B CASE [Category]WHEN “Furniture” AND Profit >0 THEN “Profitable Furniture”WHEN “Furniture” AND Profit <0 THEN “Unprofitable Furniture”END
C CASE [Profit]WHEN >0 THEN “Profitable”WHEN <0 THEN “Unprofitable”END
D CASE [Category]WHEN “Furniture” OR “Office Supplies” THEN “Nonelectronics”ELSE [Category]END

A Data Analyst has the following dataset:

Question Image

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

A { FIXED : TOTAL(Sales) }
B { FIXED : SUM(Sales) }
C { FIXED [Region]: TOTAL(Sales) }
D { FIXED [Region]: SUM(Sales) }

Question 6

Create Content

Question 7

Create Content

Question 8

Connect to and Transform Data

Question 9

Explore and Analyze Data

Question 10

Publish and Manage Content on Tableau Server and Tableau Cloud

Question 11

Explore and Analyze Data

Question 12

Explore and Analyze Data

Question 13

Explore and Analyze Data

Question 14

Connect to and Transform Data

Question 15

Explore and Analyze Data

Question 16

Connect to and Transform Data

Question 17

Explore and Analyze Data

Question 18

Connect to and Transform Data

Question 19

Explore and Analyze Data

Question 20

Publish and Manage Content on Tableau Server and Tableau Cloud

Question 21

Explore and Analyze Data

Question 22

Create Content

Question 23

Create Content

Question 24

Explore and Analyze Data

Question 25

Publish and Manage Content on Tableau Server and Tableau Cloud

A Data Analyst wants to add a draft watermark to a dashboard as shown in the following exhibit.

Question Image

Which type of object should the analyst use?

A Image
B Horizontal
C Sheet
D Web page

A Data Analyst wants to create the following dashboard.

Question Image

How should the analyst lay out the objects on the dashboard?

A Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
B Add both sheets to the dashboard. Set Fit to Fix width.
C Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
D Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fir to Entire view.

A Data Analytics has the following dataset that contains null values in the Profits field.

Question Image

The analyst wants the data to appear as shown in the following table.

Question Image

Which two formulas achieve this goal? (Choose two.)

A IF [Profits] !=null then [Profits] END
B ISNULL ([Profits])
C IFNULL ([Profits],0)
D ZN([Profits])

A Data Analyst has a dataset that contains people and the awards they have won.

Question Image

Which formula should the analyst use to get the number of people who won an award?

A COUNTD([Name])
B COUNT([Name])
C ATTR([Name])
D COVAR([Name])
E MAX([Name])

A Data Analyst is the owner of an alert.
The analyst receives an email notification that the alert was suspended.
Where should the analyst go to resume the suspended alert?

A The Notifications area in Tableau Prep
B The Data Source page in Tableau Desktop
C The Shared with Me page on Tableau Cloud or Server
D The My Content are on Tableau Cloud or Server

A Data Analyst has the following dataset.

Question Image

The analyst needs to analyze the relationship between math scores and history scores as shown in the following exhibit.

Question Image

Which three actions should the analyst perform? (Choose three.)

A Drag in a Trend Line from the Analytics Pane.
B Add History Score and Math Score to the Marks card.
C Drag Student ID to Detail on the Marks card.
D Right-click the y axis, and then select Add Reference Line.
E Add Math Score to the Rows shelf and History Score to the Columns shelf.

A Data Analyst has the following dataset.

Question Image

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

A (SUM([Sales]) – LOOKUP (SUM([Sales]) / (LOOKUP(SUM([Sales]), -4))
B (SUM([Sales]) / LOOKUP (SUM([Sales]), -4))
C (SUM([Sales]) – LOOKUP (SUM([Sales]), -4))
D (ZN(SUM([Sales])) – LOOKUP(ZN(SUM([Sales])), -4

A Data Analyst applied a dimension filter to a worksheet with FIXED Level of Detail (LOD) calculations.
How does this filter affect the worksheet?

A The dimension filter is carried out first before computing the FIXED LOD calculation.
B The dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation.
C The dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation.
D The dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation.

What does a Web Data Connector allow a Data Analyst to do?

A Scrape data from an HTML table.
B Publish data to the company website.
C Capture website traffic.
D Connect to an API.

Which function should a Data Analyst use to aggregate total regional sales for a dataset regardless of what is in the view?

A FIXED
B INCLUDE
C EXCLUDE
D SUM

A Data Analyst has the following dataset the contains sales for the month of May.

Question Image

The analyst plans to create a data extract from the dataset.
The analyst wants to extract data only from stores that have 500 or more in total sales.
What should the analyst do?

A Create an extract filter on Store Number and select Condition by field Sales.
B Create an extract filter on Store Number and select Top by field Store Number.
C Create an extract filter on Store Number and select Top by field Sales.
D Create an extract filter on Store Number and set the At least value.

A Data Analyst has a sales dataset that contains the following fields.

Question Image

The analyst needs to analyze the average revenue per item sold in different regions over time.
Which two fields should the analyst measure? (Choose two.)

A Revenue
B Customer Region
C Product Name
D Quantity
E Order Date

What happens within Tableau Prep Builder when a Data Analyst selects Publish as Data Source for a flow output step?

A The flow output is saved to the database
B The flow output is saved locally as a Tableau Data Source
C The flow output is published as a data source on the server
D The flow is published to the Tableau Server environment.

A Data Analyst has the following line chart that shows the average sales by month.

Question Image

Which month had the biggest increase in average sales compared to the previous month in 2019?

A August
B November
C December
D October

A Data Analyst has the following two tables.

Question Image

Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?

A Outer join
B Left join
C Inner join
D Right join

A Data Analyst is working with the following dataset.

Question Image

The analyst is trying to build a box plot showing the distribution of discounts offered to different vendors (something that will look like the following box plot).

Question Image

Which action does the analyst need to take next to achieve the desired box plot?

A Change AVG(Discount) field aggregation to Count Distinct.
B Add Invoice Number to the Marks card detail shelf.
C Allow whiskers to extend to the maximum extent of the data.
D Covert AVG(Discount) field to Discrete.

A Data Analyst has the following map that shows profits per state in the United States.

Question Image

How are the colors configured for the map?

A A diverging color palette that has five stepped colors
B A single color gradient
C A sequential color gradient
D A diverging color palette that has six stepped colors

A Data Analyst has the following dashboard that contains two visualizations.

Question Image

The analyst wants to show only one visualization at a time. Users must be able to switch between visualizations.
What should the analyst use?

A A parameter and a calculated field
B Show/hide buttons
C Worksheet actions
D Filter actions

A Data Analyst has a data source with row data for service calls and their activity log.

Question Image

Which calculation allows the analyst to count the calls that have never had a technician assigned to them?

A COUNT ( IF {INCLUDE [Activity Name]: NOT ‘Assign Technician’ } THEN [Call ID] END )
B SUM( {FIXED [Call ID]: IF MAX( [Activity Name]= ‘Assign Technician’) THEN 0 ELSE 1 END } )
C COUNT( {FIXED [Call ID]: IF [Activity Name]<> ‘Assign Technician’ THEN 1 ELSE 0 END } )
D SUM( {INCLUDE [Activity Name]: COUNT(IF [Activity Name] <> ‘Assign Technician’ THEN 1 END) } )

A Data Analyst has a workbook that connects to a database. The database requires authentication.
The analyst plans to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? (Choose two.)

A The data source must use a live connection.
B The credentials must be embedded.
C The data must be extracted.
D The data source must be stored as a hyper file.

Join Us Among the Stars

Certified Tableau Data AnalystPreview

About the Certified Tableau Data Analyst Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25