Tableau Desktop Specialist Test - 5

Passing the Tableau Desktop Specialist mock test boosts your resume by validating your ability to build dashboards and analyze data.

Employers value certifications, but they also want candidates with broader skills.

Power BI, SQL, SAS, and Azure are essential for reporting and querying. Data engineering platforms like Snowflake, Databricks, and PySpark are critical for managing pipelines. Data science and AI skills—TensorFlow, PyTorch, LLMs, and Generative AI—are increasingly required.

Project work is equally important to prove practical expertise. SynergisticIT’s Data Science JOPP program ensures you go beyond certification, combining advanced training with hands-on projects. Explore more: Data Science JOPP.

Welcome to your Tableau Desktop Specialist - Test-5

Name

Phone

Q1. How to disaggregate data in tableau

Select 1 option(s):

Analysis - Disaggregate data

Analysis - show measures

Analysis - show data

Analysis - Aggregate Measures

Q2. Which of the following is an local copy of a subset or entire dataset that you can share with others.

Select 2 option(s):

.tdsx

.tds

.hyper

.twbx

.tde

Q3. Which of the following options are used to bold the content in tooltip

Select 3 option(s):

Select Tooltip and use bold option

Select worksheet and then tooltip and then use bold option

Use format tooltip and then select bold

Use Format , select font , slect tooltip and use Bold

Q4. What is the median Life Expectancy difference between top two countries with highest median Life Expectancy.

Please use the Life expectancy data sets from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

0.05

0.15

0.35

0.6

Q5. Which developed country has lowest average alcohol.

Please use the life expectancy data sets from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Norway

Singapore

Japan

Kuwait

Q6. Which of the following statements are correct

Select 2 option(s):

There is no difference between dual axis and combined axis charts

Once the Combined axis chart is created, rows/columns are updated to Measure Names and Mesaure values

Combined axis chart is created by dragging 2 measures onto same axis

Dual Axis chart can be created only with measures and not with date

Q7. There are 3 points on the scatter plot. When you drag a dimension which has 3 values on to scatter plot, number of points in the scatter plot will be

Select 1 option(s):

Cant determine

Q8. Tableau displays a quantitative legend with a continuous range of colors when you use

Select 1 option(s):

Dimension

Discrete Field

Continous Field

Measure

Q9. Tableau Desktop creates which one of the following formats for image file on MAC

Select 1 option(s):

EMF

JPEG

BMP

TIFF

Q10. Which of the following can be converted to a bin. (a) Continous measure (b) Numeric Dimension

Select 1 option(s):

Only a

Neither a nor b

Only b

Both a and B

Q11. “Use as filter” creates an action by default in dashboard.

Select 1 option(s):

Depends

Yes

Q12. Which of the following changes are saved in .tds file.

Select 4 option(s):

Aliases

Parameters

Calculated Fields

Groups

Default Properties

Q13. Which of the following is a best fit line

Select 1 option(s):

R square is 0.01 and P is 0.01

R square is 0.9 and P is 0.01

R square is 0.9 and P is 0.9

R square is 0.1 and P is 0.01

Q14. which of the following years Q4 has highest Sales. Download the sample super store data needed from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

2016

2017

2014

2015

Q15. Which of the following joins result is a table that contains all values from both tables.

Select 1 option(s):

Union

Left Join

Full Outer Join

Right Join

Inner Join

Q16. Using data filter in the data source page will

Select 1 option(s):

This option itself is not present

data can be filtered only in sheet

filter the data for only one sheet

filter the data for all sheets

Q17. Union of two tables will result in

Select 1 option(s):

Increase of number of columns

Increase in number of rows

No increase

Increase in both rows and columns

Q18. Which of the following connections will help to work even if you are not able to connect to the original data source

Select 1 option(s):

Both

None

Extract

Live

Q19. Which of the following statements are correct :

Select 2 option(s):

Granularity is more, marks are also more

When more dimensions are added, granularity decreases

When more measures are added, granularity increases

When more dimensions are added, granularity increases

Q20. Which of the following steps can be used to rename a field name

Select 2 option(s):

Right click and choose rename in work sheet

Double click on the field name to edit in sheet

Right Click and choose aliases in data source page

Double click on the field name to edit in data source page

Q21. Which of the following charts does not have shape option in Marks tab

Select 2 option(s):

Scatter Plot

Pie Chart

Stacked Bar Chart

Circle Views

Q22. How can I create a dual axis chart with sales and profit measures.

Select 2 option(s):

Drag Sales to rows and Drag Profit on the right dotted line in the chart

Drag Sales and Profit on to Rows shelf, select Dual Axis option for Profit

Drag Sales and Profit on to Rows shelf, select Dual Axis option for Sales

Drag Sales to rows and Drag Profit on the left dotted line in the chart

Q23. Most important visualization in dashboard is placed on

Select 1 option(s):

Upper left

Upper right

Right Down

Center

Q24. Choose from the options : (a) A Blend combines the data and then aggregates. (b) A Join aggregates and then combines the data.

Select 1 option(s):

a is incorrect and b is correct

Both are incorrect

both are correct

a is correct and b is incorrect

Q25. Delete option is disabled for a sheet if

Select 2 option(s):

Exported as Image

Exported as PDF

Used by story

Used by dashboard

Q26. Color Palettes can be assigned for which one of the following fields

Select 1 option(s):

Dimensions

Measures

Both

None

Q27. Changes in the data model, such as converting dimensions to measures after creating a context filter will need a recomputation of context.

Select 1 option(s):

Yes

Q28. Which of the following types have hierarchy by default

Select 1 option(s):

String

Geographic

Map

Numbers

Date

Q29. Create Inner join for Orders and Returns. Which of the following ship mode has maximum sales percentage? download sample super store data from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

First Class

Standard Class

Same Day

Second Class

Q30. Which of this developing country has highest average alcohol.

Please use the Life expectancy data sets from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Czechia

France

Belarus

India

Q31. Which of the following statements are true.

Select 3 option(s):

Story can have multiple dashboards or sheets included

dashboard can have multiple storys included

A story can have same dashboard multiple times with different views

dashboard can have multiple sheets included

Q32. Which of the state has second highest average quantity. Use Super store data from the link : https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Vermont

Wyoming

California

Newyork

Texas

Q33. To visualize all the data rows in an data source you have to use following option

Select 1 option(s):

Aggregration

Groups

Disaggregation

Not possible

Q34. Y = b0 + b1 * ln(X) defines the below trend model.

Select 1 option(s):

Logarithmic

Polynomial

Power

Exponential

Linear

Q35. Which of the following Sub-Categories have huge loss when total profit is considered. Use Sample- Superstore data.

Select 1 option(s):

Bookcases

Furnishings

Supplies

Tables

Q36. Create a Side by side bar chart to determine the total beds in private rooms at Manhattan Neighbourhood. Use airbnb.xlsx data. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

6523

554

17454

6012

Q37. Which of the following ship modes contributes to the highest total profit and in which year. Use Sample – Superstore.xls for data. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Second class, 2016

Second class, 2017

Standard Class, 2016

Standard Class, 2017

Q38. Which of the following will have captions option.

Select 1 option(s):

Tableau Export

Tableau Story

Tableau Dashboard

Tableau Datasource

Q39. Which of the following neighborhoods have median price between westerpark and Noord-Oost. Use Accommodation.csv for this question. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Slotervaart

Centrum-West

Bijlmer-Oost

Noord-West

Q40. Shortcut to create a new worksheet is

Select 1 option(s):

Ctrl + M

Ctrl + W

Ctrl + C

Ctrl + N

Q41. Is it possible to change the datatype of fields in tableau ?

Select 1 option(s):

Yes

Depends

Q42. Measure Names means

Select 1 option(s):

This contains the values of all our measures into a single field and is shown at the bottom of the Measures pane.

This contains the values of all our measures into a single field and is shown at the bottom of the Dimensions pane.

This contains the names of all our measures in a single dimension and is shown at the bottom of the Measures pane

This contains the names of all our measures in a single dimension and is shown at the bottom of the Dimensions pane.

Q43. Which of the following Neighborhoods have maximum number of Reviews. Please use accommodation.csv file from the shared drive. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Zuid

Centrum-West

Bijlmer-Centrum

Bijlmer-Ost

Q44. If we are to compare measures that have the same scale and unit of measurement, then we use

Select 1 option(s):

Blended Axes chart

Stacked Bar chart

Dual Axes chart

Q45. Use Sample-Superstore. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing.

Number of records with last name “Cacioppo” are

Select 1 option(s):

Q46. Data Pane may conditionally accommodate these sections –

Select 1 option(s):

All of the above

Columns and Rows

Dimensions and Measures

Sets and Parameters

Q47. Which of the following are not Tableau Auto Generated Fields.

Select 1 option(s):

Sum Values

Measure Names and Measure Values

Number of Records

Latitude and Longitude

Q48. The average price difference between these following is high. Use Accommodation.csv file for calculation. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Select 1 option(s):

Shared room and Private room

Entire home/apt and Shared room

Hotel room and Entire home/apt

Q49. To bin a measure, we have to create a new

Select 1 option(s):

dimension

range

measure

Continuous values

Q50. Can we apply the filter or selections on one graph and treat it like a filter for all the other visuals on the dashboard ?

Select 1 option(s):

Yes

Q51. Below is not an dashboard sizing options available in Tableau to visualize.

Select 1 option(s):

Range

Automatic

Grid

Fixed

Q52. To switch a set to list the individual members:

Select 1 option(s):

Delete the set to view the individual members.

In the visualization workspace, select 'Show Members in Set'

In the visualization workspace, right-click the set and select 'Show Members in Set'.

Not possible to view individual members at all

Q53. Which of the following is a snapshot of your data.

Select 1 option(s):

Live and Extract

Live or Extract

Live

Extract

Q54. If ZIP-98007 is a string and ZIP- is used as separator then outcome is

Select 1 option(s):

ZIP

98007

ZIP, 98007

ZIP-98007

Error

Q55. Which of the following property types have equal number of total reviews. Use airbnb.xlsx sheet.

Select 1 option(s):

Lighthouse and Tent

Tent and Lighthouse

Tent and Castle

Tent and Apartment

Q56. “Show Me” option helps to check the following parameters for each of the charts

Select 4 option(s):

Number of dates

Number of measures

Number of dimensions

None

Number of Geo locations

Q57. You can add a dimension or a measure by

Select 2 option(s):

Single click to add to visualization

Drag and drop it into visualization

double click to add to visualization

Q58. Which of the following may be called as Pre-computed filters

Select 1 option(s):

Sets

Parameters

Context filters

Groups

Q59. Which of the following allows a conditional formatting which lets you compare a column or row with rest of the table

Select 1 option(s):

Cross tab

Text table

Highlight Table

Bar chart

[/ppwp]

Tableau Desktop Specialist Test - 5

Q1. How to disaggregate data in tableau

Q2. Which of the following is an local copy of a subset or entire dataset that you can share with others.

Q3. Which of the following options are used to bold the content in tooltip

Q4. What is the median Life Expectancy difference between top two countries with highest median Life Expectancy.

Q5. Which developed country has lowest average alcohol.

Q6. Which of the following statements are correct

Q7. There are 3 points on the scatter plot. When you drag a dimension which has 3 values on to scatter plot, number of points in the scatter plot will be

Q8. Tableau displays a quantitative legend with a continuous range of colors when you use

Q9. Tableau Desktop creates which one of the following formats for image file on MAC

Q10. Which of the following can be converted to a bin. (a) Continous measure (b) Numeric Dimension

Q11. “Use as filter” creates an action by default in dashboard.

Q12. Which of the following changes are saved in .tds file.

Q13. Which of the following is a best fit line

Q14. which of the following years Q4 has highest Sales. Download the sample super store data needed from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q15. Which of the following joins result is a table that contains all values from both tables.

Q16. Using data filter in the data source page will

Q17. Union of two tables will result in

Q18. Which of the following connections will help to work even if you are not able to connect to the original data source

Q19. Which of the following statements are correct :

Q20. Which of the following steps can be used to rename a field name

Q21. Which of the following charts does not have shape option in Marks tab

Q22. How can I create a dual axis chart with sales and profit measures.

Q23. Most important visualization in dashboard is placed on

Q24. Choose from the options : (a) A Blend combines the data and then aggregates. (b) A Join aggregates and then combines the data.

Q25. Delete option is disabled for a sheet if

Q26. Color Palettes can be assigned for which one of the following fields

Q27. Changes in the data model, such as converting dimensions to measures after creating a context filter will need a recomputation of context.

Q28. Which of the following types have hierarchy by default

Q29. Create Inner join for Orders and Returns. Which of the following ship mode has maximum sales percentage? download sample super store data from https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q30. Which of this developing country has highest average alcohol.

Q31. Which of the following statements are true.

Q32. Which of the state has second highest average quantity. Use Super store data from the link : https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q33. To visualize all the data rows in an data source you have to use following option

Q34. Y = b0 + b1 * ln(X) defines the below trend model.

Q35. Which of the following Sub-Categories have huge loss when total profit is considered. Use Sample- Superstore data.

Q36. Create a Side by side bar chart to determine the total beds in private rooms at Manhattan Neighbourhood. Use airbnb.xlsx data. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q37. Which of the following ship modes contributes to the highest total profit and in which year. Use Sample – Superstore.xls for data. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q38. Which of the following will have captions option.

Q39. Which of the following neighborhoods have median price between westerpark and Noord-Oost. Use Accommodation.csv for this question. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q40. Shortcut to create a new worksheet is

Q41. Is it possible to change the datatype of fields in tableau ?

Q42. Measure Names means

Q43. Which of the following Neighborhoods have maximum number of Reviews. Please use accommodation.csv file from the shared drive. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q44. If we are to compare measures that have the same scale and unit of measurement, then we use

Q45. Use Sample-Superstore. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing.

Number of records with last name “Cacioppo” areSelect 1 option(s):

Q46. Data Pane may conditionally accommodate these sections –

Q47. Which of the following are not Tableau Auto Generated Fields.

Q48. The average price difference between these following is high. Use Accommodation.csv file for calculation. https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q49. To bin a measure, we have to create a new

Q50. Can we apply the filter or selections on one graph and treat it like a filter for all the other visuals on the dashboard ?

Q51. Below is not an dashboard sizing options available in Tableau to visualize.

Q52. To switch a set to list the individual members:

Q53. Which of the following is a snapshot of your data.

Q54. If ZIP-98007 is a string and ZIP- is used as separator then outcome is

Q55. Which of the following property types have equal number of total reviews. Use airbnb.xlsx sheet.

Q56. “Show Me” option helps to check the following parameters for each of the charts

Q57. You can add a dimension or a measure by

Q58. Which of the following may be called as Pre-computed filters

Q59. Which of the following allows a conditional formatting which lets you compare a column or row with rest of the table

Number of records with last name “Cacioppo” are

Select 1 option(s):