Tableau Certification Questions and Answers Sample for Exam Practice

Tableau Exam Questions and Answers for Desktop Specialist, Desktop Qualified Associate and Desktop Certified Professionals

Data skills are in very high demand in every corporate. Organizations would like to assimilate simplified versions of the data in an easily understandable and presentable format. Tableau certifications help you to create data visualizations and present to the top management.

The Tableau certification can be obtained at different levels: Desktop qualified associate, desktop certified professionals, server qualified associate, server qualified professional; etc. With the help of Tableau certification, you can transform data into visually appealing dashboards and charts.

We have collated Tableau certification questions along with exam answers and explanations. You can quickly have a practice and recap your knowledge before appearing for the Tableau certification exam.

This is a free Tableau exam prep dumps simulates the actual certification exam. Have an attempt as a sample test to evaluate and understand your skillsets. We believe that these tableau certification sample questions will help you to earn passing score for building a successful tableau career.

Exam details:  Tableau

Exam name: Tableau Certification

Exam Duration: 60 minutes for all other certifications and 110 minutes for desktop certified professional, server qualified associate 80, Server CP 420 minutes.

No. of questions: Desktop Specialist 30, Desktop Qualified Associate 36, Desktop Certified Professionals

Passing score: 70%

Validated against: https://www.tableau.com/support/certification

Format: Multiple Choice

Exam price: Desktop specialist: $100; Desktop qualified associate:$250; Desktop certified professional:$ 600; Server qualified associate: $250; Server certified professional: $800.

1. State the best reason for using an extract instead of a live connection?

•    The data source supports a live connection through ODBC.

•    A fresh data set is required all the time.

• You need to apply an aggregation that takes too long when using a live connection.

•    You need to join tables that are in the data source.

Using the extract is the best option as an aggregation should be applied on a live connection which takes too long.

-------------------------------------------------------------------------------------------------------------------------

2. State what should be used to create a calculated field that returns data independent of the data granularity in a view?

•    An INCLUDE LOD calculation

•    A table calculation

•    A basic calculation

• A FIXED LOD calculation

A fixed Level of Detail calculation does not anticipate the dimensions. It is independent of the data granularity.

----------------------------------------------------------------------------------------------------------------------------

3. Mention, what should be specified to connect to multiple tables in a single data source at one time.

•    A blend

•    A calculation

• A join

•    A hierarchy

A join has to be defined to link multiple tables from a single data source.

----------------------------------------------------------------------------------------------------------------------------

4. A field that shows average home values for the United States in 2016 is most likely:

•    A discrete date part dimension

•    A continuous date value dimension

•    A geographical dimension

• An aggregated measure

An aggregate measure in Tableau is a set of values that returns a single numeric value. Hence, aggregated measure shows average home values.

----------------------------------------------------------------------------------------------------------------------------

5. Mention the interactive elements to add to a dashboard for users.

• URL actions

•    Edit tooltip options

• Filter actions

•    Hide and unhide all sheet options

The URL actions and filter actions are the interactive elements which add to the dashboard for users.

----------------------------------------------------------------------------------------------------------------------------

6. What does the box in a box plot represent?

•    Maximum extent of the data

• The range of the middle half of the data points

•    The median of the middle half of the data points

•    The outliers of the data

A box in the box plot represents the median value.

----------------------------------------------------------------------------------------------------------------------------

7. Tableau can create worksheet-specific filters.

•       True
•          False

The statement is true as Tableau can create worksheet specific filters.

----------------------------------------------------------------------------------------------------------------------------

8. In the Technology Product Category, which only profitable states surround unprofitable state?

• Colorado

•    Missouri

•    Wyoming

•    Utah

The profitable state encompasses the Colorado state in the Technology product category.

------------------------------------------------------------------------------------------------------------------------

9. In which Region do all Product Categories fall beneath the overall average profit?

•    All Regions

•    Central

•    East

• South

•    West

The South region displays average profits in all product categories.

----------------------------------------------------------------------------------------------------------------------------

11.    State true or false. A reference band cannot be based on a continuous axis.

•       False
•       True

A reference band is based on two reference points.

----------------------------------------------------------------------------------------------------------------------------

12. A Reference Distribution plot cannot be on a continuous axis.

•       True
•       False

A Reference Distribution plot can be on a continuous axis.

----------------------------------------------------------------------------------------------------------------------------

13. State which is not a trend Line model

•    Linear Trend Line

•    Exponential Trend Line

• Binomial Trend Line

•    Logarithmic Trend Line

Binomial Trend Line is not an example of a Trend Line model.

----------------------------------------------------------------------------------------------------------------------------

14. The image below uses which map visualization?

•    Filled maps

•    Layered maps

•    WMS server maps

•    Symbol maps

A web map service helps for geo-referenced map images and aids in map visualization.

--------------------------------------------------------------------------------------------------------------------------

15. How to execute a URL action on a dashboard object within a dashboard to open a Web Page, without opening the web browser?

•    Correct, with the use of Tableau Server

• Correct, with the use of a Web Page object

•    Not possible

•    Correct requires a plug-in

Correct, with the use of a Web Page object it is possible to execute a URL action on a dashboard object within a dashboard to open a web page in the system’s web browser.

----------------------------------------------------------------------------------------------------------------------------

16. In an entire workbook, the Highlighting action can be disabled.

• True

•    False

The disablement of the highlighting action is done for the entire workbook from the toolbar.

------------------------------------------------------------------------------------------------------------------------------

17. A sheet cannot directly be used within a story. Either sheet should be used within a dashboard, or a dashboard should be used within a story.

•       True
•       False

A sheet can be used directly within a story.

------------------------------------------------------------------------------------------------------------------------

18. How is a continuous field identified in Tableau?

•       A blue pill identifies it in the visualization.
•       A green pill identifies continuous field
•       Continuous field has a # symbol preceding the data window.
•       When the continuous field is added to the visualization, it produces distinct values.

A green pill identifies it in a visualization

----------------------------------------------------------------------------------------------------------------------------

19. In Tableau, can you use measures in the same view multiple times (e.g., SUM of the measure and AVG of the measure)?

•          No
•          Yes

Possible, measures can be used multiple times in the same view.

----------------------------------------------------------------------------------------------------------------------------

20. Sets can be created on Measures.

•          False
•          True

Sets can be created on dimensions.

----------------------------------------------------------------------------------------------------------------------------

21. What is used for creating variable size bins?

•          Sets
•          Groups
•          Calculated fields
•          Table Calculations

Calculated fields are used for creating variable size bins.

----------------------------------------------------------------------------------------------------------------------------

22. Which of the following best describes the usage of a bullet graph?

•          To Analyze the trend for a time period
•          To Compare the actual against the target sales
•          To add data to bins and calculating count measure
•          To Display the sales growth for a particular year

A bullet graph compares the actual sales with the targeted sales.

----------------------------------------------------------------------------------------------------------------------------

23. Disaggregation breaks down all records in the underlying data source.

•       True
•       False

True, Disaggregation breaks down all the data records in the underlying data sources.

----------------------------------------------------------------------------------------------------------------------------

24. The Tableau displays measures over a period of time as a ____________.

•       Bar
•       Line
•       Histogram
•       Scatter Plots

Tableau displays measures over a period of time as a Lines.

----------------------------------------------------------------------------------------------------------------------------

25. The icon associated with the field that has been grouped is a ______________.

•          Paper Clip
•          Set
•          Hash
•          Equal To

A paperclip is an icon associated with the field that has been grouped.

----------------------------------------------------------------------------------------------------------------------------

26. In the West region, which state’s sales fall within the Reference Band starting from average sales of that region till median of sales? (Perform the below questions in Tableau 9.0 and connect to the Saved Sample – Superstore dataset)

•          California
•          Colorado
•          Montana
•          New Mexico

The correct answer is Colorado

----------------------------------------------------------------------------------------------------------------------------

27. Which chart types always includes bars sorted in descending order?

•    Gantt Chart

• Pareto Chart

•    Combo Chart

•    Bar in Bar

A Pareto chart can be represented in line graph format and bar graph format. The values are represented in descending order in the bar graph. The line graph represents the line graph.

----------------------------------------------------------------------------------------------------------------------------

28. What is the minimum amount of RAM recommended for any production use of Tableau Server?

•       8 GB
•       16 GB
•       32 GB
•       64 GB

32 GB is the recommended RAM for a Tableau server.

----------------------------------------------------------------------------------------------------------------------------

29. A data server utilizes which of these user interactions?

•       A user publishes a workbook that uses an extract.
•       A user publishes a data source.
•       A new workbook is created from a Tableau Server Data Connection by the user.
•       A server administrator accesses an administrative view

The data server utilizes user interactions like publishing a data source and creating a new workbook.

----------------------------------------------------------------------------------------------------------------------------

30. Mention the best method to visualize individual users affected by a particular workbook permissions rule?

•       Search on the host project’s Permissions page, and then click the permissions rule.
•       On the menu, click on the content, then workbooks and then list icon.
•       Click on workbook's permission page and click on permission rule.
•       On the menu, click on groups and then all users.

Individual users can be viewed by navigating to the workbook’s permission page and clicking the permissions rules.

----------------------------------------------------------------------------------------------------------------------------

31. A user with a Viewer license type and site role can create data-driven alerts.

•       True
•       False

A user with viewer license type cannot create Data-driven alerts. Hence, the above statement is false.

----------------------------------------------------------------------------------------------------------------------------

32. How to subscribe a user to a view by an administrator?

•       By using parameters in the view’s Embed Link
•       By clicking Subscribe on the view, and then clicking Manage
•       By clicking Subscribe on the view, and then click Add under Subscribe Others
•       By using URL parameters in the view’s Share Link

An administrator can allow a user to a view by clicking on the subscribe and add under subscribe to others.

----------------------------------------------------------------------------------------------------------------------------

33. Mention all of the relevant options for Active Directory group synchronization performance?

•       Use the Settings page to synchronize on demand.
•       Set the site role for users who have been removed from Active Directory.
•       Use the Settings page to set a regular schedule for synchronization.
•       Set the minimum site role for group users to be applied during Active Directory synchronization.

Active directory group synchronization can be done by using the settings page to synchronize on demand, to set a regular schedule and to set the minimum site role for group users.

----------------------------------------------------------------------------------------------------------------------------

34. A Tableau Support case can be opened in one of the following valid ways. Which one?

•       Contact the Developer Community Forum.
•       Contact Consulting Services.
•       Use the Tableau Community site.
•       Use Tableau’s Support website

The valid method to open tableau support case is by using the Tableau support website. A submit support request form will be present which has to be filled.

----------------------------------------------------------------------------------------------------------------------------

35. One of the following charts uses binned data. Which one?

•    Pie Chart

•    Box Plot

• Histogram

•    Bullet Graphs

A histogram bins the range of values.

----------------------------------------------------------------------------------------------------------------------------

36. What does it imply if a field has a blue background?

•    Continuous

• Discrete

•    Dimension

•    Measure

If the field has a background color, blue, then the field is discrete.

----------------------------------------------------------------------------------------------------------------------------

 37. A Reference Band cannot be based on two fixed points.

•    False

• Correct

A reference band can be based on two fixed points.

----------------------------------------------------------------------------------------------------------------------------

38. A reference distribution plot cannot be along with the continuous axis

•    True

•    False

A reference distribution plot can be along the continuous axis.

----------------------------------------------------------------------------------------------------------------------------

39. Mention the statement which is not a trend line model

•    Linear trend line model

•    Exponential trend line

• Binomial trend line

•    Logarithmic Trend Line

A binomial trend line is not a trend line model.

----------------------------------------------------------------------------------------------------------------------------

40. How to identify a continuous field in Tableau?

•    A blue pill identifies it in the visualization.

• A green pill identifies it in a visualization.

•    A continuous field is preceded by a # symbol in the data window.

•    When a continuous field is added to the visualization, it produces distinct values.

A green pill identifies a continuous field as a visual in Tableau.

----------------------------------------------------------------------------------------------------------------------------

41. Why is the benefit of using a bullet graph?

•    To analyze the trend for a time period

•    To compare the actual against the target sales

•    To add data to bins and calculating count measure

•    To display the sales growth for a particular year

A bullet graph is helpful in comparing the actual sales against the targeted sale.

---------------------------------------------------------------------------------------------------------------------------

42. Disaggregation allows visualizing all the data rows the underlying data source.

•    True

•    False

The Disaggregation in Tableau allows to visualize all the data rows from a data source.

------------------------------------------------------------------------------------------------------------------------

43. Tableau displays time as a measure in which graph?

•    Bar graph

• Line graph

•    Histogram

•    Scatter Plots

A line graph in Tableau displays time

-----------------------------------------------------------------------------------------------------------------------

44. In Tableau, the icon that represents a grouped field is

• Paper clip

•    Set

•    Hash

•    Equal to

A paper clip represents the group field.