Tableau Desktop Specialist Test - 8

The Tableau Desktop Specialist mock test is a professional signal to employers. It validates your Tableau knowledge and demonstrates initiative. Yet, certifications alone don’t secure jobs.

Employers want professionals who can integrate Tableau with Power BI, SQL, SAS, and Azure, while also mastering data engineering platforms like Snowflake, Databricks, and PySpark. Data science and AI skills—TensorFlow, PyTorch, LLMs, and Generative AI—are increasingly required.

SynergisticIT’s Data Science JOPP program ensures your professional signal translates into career success. Learn more: Data Science JOPP

Welcome to your Tableau Desktop Specialist - Test-8

Name

Phone

Q1. From where you can‘t create the groups in Tableau?

Select 1 option(s):

Marks Card

Data pane

Directly from the view

None of the above

Q2. Which of the following are valid calculations?

Select 2 option(s):

MAX(SUM(Profit), (Sales))

SUM([Profit]) * SUM([Quantity])

SUM([Profit]) * 1000

SUM([Profit]) * [Quantity]

Q3. What are the security options available for Web Page objects of a dashboard?

Select 3 option(s):

Enable JavaScript

Block Pop-ups

Enable Extensions

Enable Developer Tools

Q4. What possibly can be recognized as a dimension?

Select 1 option(s):

State

Profit

Latitude

Measure Value

Q5. Which of the following field types will create a color gradient?

Select 1 option(s):

Discrete

Continuous

Measure

Dimension

Q6. In the following view, how you will define the Profit and Sales fields?

Select 1 option(s):

Sales is continuous and profit is discrete

Profit is continuous and sales is discrete

Both are continuous

Both are discrete

Q7. The following field would display the average value of apartments in the United Kingdom for the calendar year 2021?

Select 1 option(s):

A geographical field

A continuous date value

A discrete data part

An aggregated measure

Q8. How you should calculate the profit ratio in Tableau?

Select 1 option(s):

SUM([Sales])/SUM([Profit])

SUM([Profit])/SUM([Sales])

[Profit]/[Sales]

[Sales]/[Profit]

Q9. A date field in the Tableau can be?

Select 1 option(s):

Discrete

Continuous

Both a) and b)

None of the above

Q10. What is the output of the function FINDNTH(“Tableau“, “a“, 2)?

Select 1 option(s):

Error

Q11. For which field type, Tableau automatically creates a hierarchy?

Select 1 option(s):

Field which start from same word like Customer ID, Customer Name

Geography

Date

Numeric

Q12. In a scatter plot that shows a negative correlation between values, what it means?

Select 1 option(s):

Similar trends

Many outliers

Opposing trends

No relation

Q13. To create a ________ in a workbook already connected to at least two data sources, bring a field from one data source to the sheetit becomes the primary data source. Switch to the other data source and use a field on the same sheetit becomes a secondary data source.

Select 1 option(s):

union

relationship

blend

join

Q14. Using which type of field you can create the bins? (select the most appropriate one)

Select 1 option(s):

Continuous measure

Discrete

Dimension

Geography

Q15. In a single worksheet, if you want to give control to the user to select the view that shows Sales over time or Profit over time. This can be achieved using which of the following?

Select 1 option(s):

Sets

Groups

Parameters

Hierarchies

Q16. Which of the following are valid scope for Reference Line?

Select 3 option(s):

Pane

Cell

Table

Column

Q17. You can control overall dashboard size using Dashboard size options. What are the dashboard size options available in Tableau?

Select 3 option(s):

Range

Automatic

Fixed size

Standard

Q18. Which dashboard objects let you add unique features to dashboards or integrate them with applications outside Tableau?

Select 1 option(s):

Plugin

Extension

Webpart

API

Q19. You have a dataset that contains the organization names and in which segment it works. Which formula should you use to get the number of companies in the Organization column?

Select 1 option(s):

COUNTD ( [Organization] )

MAX ( [Organization] )

ATTR ( [Organization] )

COUNT ( [Organization] )

Q20. From where you can add the reference lines in your view?

Select 1 option(s):

Analytics pane

Analysis menu

Data menu

Data pane

Q21. Which is the easiest way to show the top 5 and bottom 5 sales in the same chart for the Customer Name dimension?

Select 1 option(s):

Using Sets

Using Parameters

Using Calculated Fields

Using Filters

Q22. The _______ layer of the data model is where you can combine data using joins and unions.

Select 1 option(s):

logical

virtual

physical

data

Q23. Which of the following are true regarding relationships in a data model in Tableau?

Select 3 option(s):

You can define relationships based on geographic fields.

When relating tables, the fields that define the relationships must have the same data type.

You can‘t edit relationships in a published data source.

Relationships can be based on calculated fields.

Q24. Which feature is used in Tableau for cleaning your data?

Select 1 option(s):

Data Manager

Pivot table

Data Cleanser

Data Interpreter

Q25. What is a default connection type when you connect to a data source?

Select 1 option(s):

Live

Extract

twbx

twb

Q26. __________ files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Select 1 option(s):

.twbx

.tde

.tdsx

.twb

Q27. In a tableau view, if you would like to change the font color of the tooltip, how you can do it?

Select 2 option(s):

Right-click on the view, select ‘Format‘ and select the dropdown next to the tooltip. And select the color.

Click on the tooltip button in the Marks card, select the text, and select the color from the dropdown

Go to Format Menu, Select the tooltip and highlight the text, and select the color from the dropdown

Right-click on the view, select ‘Tooltip‘ and highlight the text, and select the color from the dropdown

Q28. Which of the following are true regarding animations? Select all that apply.

Select 3 option(s):

When you create a new workbook, animations are enabled by default.

Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

You can reset animations to return an entire workbook to the default animation settings.

Simultaneous animations take more time but make complex changes clearer by presenting them step-by-step.

Q29. In a Tableau story, we can update the navigator style using the ____________

Select 1 option(s):

story pane

layout pane

story menu

story toolbar

Q30. Which of the following best describes the frequency distribution of the measure values?

Select 1 option(s):

Reference Lines

Trend Lines

Histogram

Heat Maps

Q31. You connected to the data source, but Tableau has not generated the Latitude and Longitude fields, what is the possible reason for that?

Select 1 option(s):

There is no numeric field present in the data source

You are using Tableau Public edition

There is no geographic field present in the data source

You are connected to Spatial file data source

Q32. If the pill color is green, this means that the field is

Select 1 option(s):

Continuous

Discrete

Measure

Dimension

Q33. The following view shows the sales recorded for each sub-category against discount offered. Which of the following is true?

Select 1 option(s):

Discount is discrete, Sales is continuous

Discount is discrete, Sales is discrete

Discount is continuous, Sales is discrete

Discount is continuous, Sales is continuous

Q34. We connected to an excel as a data source, and it has a Column ‘A‘ which consists of mostly numeric data, but also has a few text and date values. Tableau assigned the Number as a data type for this field. Now when this ‘A‘ column data is imported to Tableau, what will happen to the date and text values?

Select 1 option(s):

Text, dates, and numbers are treated as Null.

Text is treated as Null. A date is treated as the number of days since 1/1/1900.

Text values are treated as Null and dates are treated as zero

Date is treated as Null and text values are treated as zero

Q35. In your source data, there is 100 products information (100 rows). You create a scatter plot using measures Marketing Cost field and Revenue field. How many marks you will get by default when you drag both these fields to the view?

Select 1 option(s):

100

200

Q36. Which of the following is not true for Sets?

Select 1 option(s):

Three sets can be combined into one set

Sets can be both static and dynamic

Set can be combined if they were created using same dimension

None of the above

Q37. Which of the following are available as a background map in Tableau?

Select 3 option(s):

Satellite

Streets

Roads

Outdoors

Q38. In which of the following scenario you have to create a calculated field?

Select 1 option(s):

Split the customer name into First Name and Last Name

Find the substring within a string value

Rank the products on the basis of sales value

Sort the customer name

Q39. Which of the following are true regarding dashboards in Tableau?

Select 2 option(s):

Floating items can be layered over other objects.

We cannot evenly distribute a layout container‘s items.

Fixed items don‘t overlap; they become part of a single-layer grid that resizes based on the overall dashboard size.

A horizontal layout container resizes the width of the views and objects it contains.

Q40. Using the download object of the dashboard, you can download the dashboard in which of the following types?

Select 3 option(s):

PDF

CSV

Image

PowerPoint

Q41. Using which options you can automatically add the phone layouts on your dashboard?

Select 2 option(s):

choose Dashboard > Add Phone Layouts to Existing Dashboards

In device preview mode, check the Tableau mobile app

choose Dashboard > Add Phone Layouts to New Dashboards

Select Size and then choose Phone

Q42. Which sorting is used to rearrange the order of dimension fields by dragging them next to each other in an ad hoc fashion?

Select 1 option(s):

Random Sort

Manual Sort

Computed Sort

Nested Sort

Q43. I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we dont need. For example – We dont have any country which is the part of Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?

Select 1 option(s):

You will select Exclude Values in a filter card options

You will select Only Relevant Values in a filter card options

You will select Format filter and Set Control in a filter card options

You will select Wild card match in a filter card options

Q44. In your dataset, you have Profit and Sales measures. You create a dual-axis chart using these measures. To avoid confusion, what you should do?

Select 1 option(s):

Hide the axis

Synchronise the axis

Add the tooltip

Change the legend color

Q45. How can you identify the top five customers with the highest sales, only consider the customers who are in the Consumer segment?

Select 1 option(s):

Use a set to identify the top 5 customers with the highest sales, and add a dimension filter on the consumer segment.

Use a set to identify the top 5 customers with the highest sales, and create a context filter on the consumer segment.

Use a Customer Name filter to find the top 5 customer, and then add a dimension filter on consumer segment.

None of the above

Q46. Which of the following are date parts?

Select 3 option(s):

2020

Friday

11-Jun

Q47. Which one of the following best describes measures?

Select 1 option(s):

Text based data

Qualitative data

Quantitative data

Map based data

Q48. How many marks you will get in the view if you drop one continuous measure in the rows shelf and one dimension having 11 distinct members in the column shelf?

Select 1 option(s):

Q49. In the following view, how do you define the field types for Sub-Category, SUM(Quantity), and SUM(Sales)?

Select 1 option(s):

Sub-Category is a discrete measure, SUM(Quantity) is a continuous measure and SUM(Sales) is a discrete measure.

Sub-Category is a discrete dimension, SUM(Quantity) is a continuous measure and SUM(Sales) is a discrete measure.

Sub-Category is a discrete measure, SUM(Quantity) is a discrete dimension and SUM(Sales) is a continuous measure.

Sub-Category is a discrete dimension, SUM(Quantity) is a discrete measure and SUM(Sales) is a continuous measure.

Q50. Which of the following changes can be stored in a TDS file?

Select 3 option(s):

Visualization

Default Aggregation

Sets

Calculated fields

Q51. Sometimes youll want to make changes to a data source such as add more tables, hide and show fields, set field defaults, and so on. When you make these changes it affects all sheets that use the data source. Which feature help you to do it without affecting the existing sheets?

Select 1 option(s):

It is not possible, you need to again add the same data source

Use blending to achieve it

From Data Source page go to Data menu, select Refresh data source

From Data Source page go to Data menu, select Duplicate data source

Q52. In which of the scenario, it is best to use the union to combine the data?

Select 1 option(s):

The data to combine is at different level of detail

The data to combine comes from different excel files

The data to combine has the same structure but for different years

None of the above

Q53. How to convert the string into a geographic role “Country“?

Select 1 option(s):

Right click the string in dimension pane and select Transform and click Geographic Role and choose Country

Right click the string in dimension pane and select Geographic Role and choose Country

Both of the above

None of the above

Q54. Which of the following is not the default property which can be set for non-numeric dimension?

Select 1 option(s):

Comment

Number format

Color

Sort

Q55. How to configure the animations in Tableau?

Select 1 option(s):

Go to the Analysis menu and then Click on Animations

Go to the Format menu and then Click on Animations

Right Click on the Visualization and then select Animations

Q56. A dashboard can contain multiple worksheets?

Select 1 option(s):

TRUE

FALSE

Q57. How to export the workbook as a PowerPoint presentation?

Select 1 option(s):

Go to Data Source, right click on the connection and select Export As PowerPoint

Go to Worksheet, Click on export and select Export As PowerPoint

Go to File, Click on Export As PowerPoint

None of the above

Q58. Tableau automatically associates continuous fields with categorical palettes.

Select 1 option(s):

TRUE

FALSE

Q59. Which of the following is the best reason to use a relationship instead of a join?

Select 1 option(s):

You wish to avoid data duplication when combining tables with different granularity

You are combining tables based on the calculated field.

You wish to combine the data from different data sources

You would like to use mutiple table extract.

Q60. Suppose your extract is comprised of one logical table that contains three physical tables. If you open the extract using the packaged data source (.tdsx) file or the data source (.tdsx) file with its corresponding extract (.hyper) file, how many tables you will see on the Data Source page?

Select 1 option(s):

[/ppwp]

Tableau Desktop Specialist Test - 8

Q1. From where you can‘t create the groups in Tableau?

Q2. Which of the following are valid calculations?

Q3. What are the security options available for Web Page objects of a dashboard?

Q4. What possibly can be recognized as a dimension?

Q5. Which of the following field types will create a color gradient?

Q6. In the following view, how you will define the Profit and Sales fields?

Q7. The following field would display the average value of apartments in the United Kingdom for the calendar year 2021?

Q8. How you should calculate the profit ratio in Tableau?

Q9. A date field in the Tableau can be?

Q10. What is the output of the function FINDNTH(“Tableau“, “a“, 2)?

Q11. For which field type, Tableau automatically creates a hierarchy?

Q12. In a scatter plot that shows a negative correlation between values, what it means?

Q13. To create a ________ in a workbook already connected to at least two data sources, bring a field from one data source to the sheetit becomes the primary data source. Switch to the other data source and use a field on the same sheetit becomes a secondary data source.

Q14. Using which type of field you can create the bins? (select the most appropriate one)

Q15. In a single worksheet, if you want to give control to the user to select the view that shows Sales over time or Profit over time. This can be achieved using which of the following?

Q16. Which of the following are valid scope for Reference Line?

Q17. You can control overall dashboard size using Dashboard size options. What are the dashboard size options available in Tableau?

Q18. Which dashboard objects let you add unique features to dashboards or integrate them with applications outside Tableau?

Q19. You have a dataset that contains the organization names and in which segment it works. Which formula should you use to get the number of companies in the Organization column?

Q20. From where you can add the reference lines in your view?

Q21. Which is the easiest way to show the top 5 and bottom 5 sales in the same chart for the Customer Name dimension?

Q22. The _______ layer of the data model is where you can combine data using joins and unions.

Q23. Which of the following are true regarding relationships in a data model in Tableau?

Q24. Which feature is used in Tableau for cleaning your data?

Q25. What is a default connection type when you connect to a data source?

Q26. __________ files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Q27. In a tableau view, if you would like to change the font color of the tooltip, how you can do it?

Q28. Which of the following are true regarding animations? Select all that apply.

Q29. In a Tableau story, we can update the navigator style using the ____________

Q30. Which of the following best describes the frequency distribution of the measure values?

Q31. You connected to the data source, but Tableau has not generated the Latitude and Longitude fields, what is the possible reason for that?

Q32. If the pill color is green, this means that the field is

Q33. The following view shows the sales recorded for each sub-category against discount offered. Which of the following is true?

Q35. In your source data, there is 100 products information (100 rows). You create a scatter plot using measures Marketing Cost field and Revenue field. How many marks you will get by default when you drag both these fields to the view?

Q36. Which of the following is not true for Sets?

Q37. Which of the following are available as a background map in Tableau?

Q38. In which of the following scenario you have to create a calculated field?

Q39. Which of the following are true regarding dashboards in Tableau?

Q40. Using the download object of the dashboard, you can download the dashboard in which of the following types?

Q41. Using which options you can automatically add the phone layouts on your dashboard?

Q42. Which sorting is used to rearrange the order of dimension fields by dragging them next to each other in an ad hoc fashion?

Q44. In your dataset, you have Profit and Sales measures. You create a dual-axis chart using these measures. To avoid confusion, what you should do?

Q45. How can you identify the top five customers with the highest sales, only consider the customers who are in the Consumer segment?

Q46. Which of the following are date parts?

Q47. Which one of the following best describes measures?

Q48. How many marks you will get in the view if you drop one continuous measure in the rows shelf and one dimension having 11 distinct members in the column shelf?

Q49. In the following view, how do you define the field types for Sub-Category, SUM(Quantity), and SUM(Sales)?

Q50. Which of the following changes can be stored in a TDS file?

Q51. Sometimes youll want to make changes to a data source such as add more tables, hide and show fields, set field defaults, and so on. When you make these changes it affects all sheets that use the data source. Which feature help you to do it without affecting the existing sheets?

Q52. In which of the scenario, it is best to use the union to combine the data?

Q53. How to convert the string into a geographic role “Country“?

Q54. Which of the following is not the default property which can be set for non-numeric dimension?

Q55. How to configure the animations in Tableau?

Q56. A dashboard can contain multiple worksheets?

Q57. How to export the workbook as a PowerPoint presentation?

Q58. Tableau automatically associates continuous fields with categorical palettes.

Q59. Which of the following is the best reason to use a relationship instead of a join?

Q60. Suppose your extract is comprised of one logical table that contains three physical tables. If you open the extract using the packaged data source (.tdsx) file or the data source (.tdsx) file with its corresponding extract (.hyper) file, how many tables you will see on the Data Source page?

Q13. To create a ________ in a workbook already connected to at least two data sources, bring a field from one data source to the sheetit becomes the primary data source. Switch to the other data source and use a field on the same sheetit becomes a secondary data source.

Q51. Sometimes youll want to make changes to a data source such as add more tables, hide and show fields, set field defaults, and so on. When you make these changes it affects all sheets that use the data source. Which feature help you to do it without affecting the existing sheets?