Tableau Desktop Specialist Test - 6

The Tableau Desktop Specialist mock test is a validation tool for your Tableau knowledge. It helps you prepare for certification and demonstrates initiative. However, certifications alone don’t make you job-ready.

Employers expect candidates to master visualization tools like Power BI, statistical platforms like SAS, and SQL for querying.

They also want data engineering expertise in Snowflake, Databricks, and PySpark, plus data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI. Project work is critical to prove you can apply these skills in practice. SynergisticIT’s Data Science JOPP bridges this gap.

Welcome to your Tableau Desktop Specialist - Test-6

Name

Phone

Q1. Duplicate data after creating a join means that

Select 1 option(s):

Data is at different LOD levels

Data is improper

Data is at same LOD level

Data has to be cleansed

Q2. Sorting from an axis gives this sort by default.

Select 1 option(s):

Nested Sort

Not possible to sort from axis

Depends on data if it is nested or non nested

Non Nested Sort

Q3. Option used for seeing the queries being generated for relationships in Tableau Desktop are called as

Select 1 option(s):

Performance Recorder

Join Recorder

Relationship Recorder

Query Recorder

Q4. Is it possible to disable the sort option

Select 1 option(s):

Yes

Q5. Below are the potential advantages of changing size of the marks in tableau view.

Select 3 option(s):

Reduce the confusion caused by small marks

None

See the data better

Reduce the confusion caused by overlapping

Q6. You can aggregate the dimension in view as –

Select 1 option(s):

None

Maximum

Min and Max

Minimum

Q7. – This symbol means that

Select 1 option(s):

Active Link

Cross Database Join

Inner Join

Broken Link

Q8. Which one of the following is an invalid trend line model.

Select 1 option(s):

Linear

None

Power

Logarithmic

Q9. Which of the following chart types need atleast one dimension.

Select 1 option(s):

Area chart

Symbol Maps

Side by side circles chart

Scatter plots

Q10. Do we have any techniques to make Viz faster ?

Select 1 option(s):

Yes

Q11. This level of detail expressions can be useful when you want to calculate at a fine level of detail in the database and then re-aggregate and show at a coarser level of detail in your view.

Select 1 option(s):

Fixed LOD

None of the above

Include LOD

Exclude LOD

Q12. This helps to capture a point, or insight. The idea being that you can use this to guide somebody through your work to show them what you have found, and maybe even ask questions.

Select 1 option(s):

Worksheet

Story

Dashboard

Story point

Q13. Below is not an URL target option possible for URL actions in Dashboards.

Select 1 option(s):

New browser Tab

New browser Window

Web Page Object

Browser Tab if No Web Page Object Exists

Q14. Use sample-superstore data to solve this question. Which of these regions have highest sales.

Select 1 option(s):

South,West

West, East

South, Central

East, Central

Q15. In Histograms below, value of outlier is ?

Select 1 option(s):

Not Applicable

100

Q10. Do you need to define the joins up-front (using venn diagram) in latest Tableau 2020.2 version.

Select 1 option(s):

Yes

Q17. Is it possible to create a data visualization without a dataset.

Select 1 option(s):

Yes

Q18. Use sample-super store. How many marks are present in scatter plot when total profit, total quantity and Category are plotted.

Select 1 option(s):

Q19. Web authoring in Tableau online and Tableau server supports the following databases.

Select 4 option(s):

Amazon Redshift

MemSQL

Vertica

IBM DB2

Unattempted

Q20. These Viz animations make the complex changes clearer by presenting them step-by-step.

Select 1 option(s):

All of the above

Simultaneous animations

Simple animations

Sequential animations

Q21. Tableau reference line can be made dynamic using

Select 1 option(s):

None

Parameter Actions

Link Actions

Dynamic Actions

Q22. By default, dimensions in Tableau are always aggregated.

Select 1 option(s):

TRUE

FALSE

Q23. These features cannot be animated in Tableau

Select 4 option(s):

Axes and headers

Forecasts, trends, and reference lines

Density marks in web browsers

Maps

Unattempted

Q24. Which of the following are true

Select 3 option(s):

maps can float in floating layout

Floating items can be layered over other objects.

Tiled items dont overlap

Floating Layout resizes based on the overall dashboard size.

Q25. What is the maximum number of tables we can join in tableau?

Select 1 option(s):

Q26. When there is only one color range seen in palette its called as

Select 1 option(s):

Stepped

Sequential

Quantitative

Diverging

Q27. Which of the following is used for data drill down

Select 1 option(s):

set

date

hierarchy

group

Q28. Which of the following can be used to increase the performance when dataset is large or there are too many filters

Select 1 option(s):

dimension

context

measure

extract

Q29. Please use the books.csv data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

The Author for the Harry Potter book which has highest sum of Ratings count.

Select 1 option(s):

J.K.Rowling-Mary GrandPre

Philip Nel

J.K.Rowling

J.K.Rowling-Gemma Rovira Ortega

Q30. Which of the following options are used to italicize the content in tooltip.

Select 3 option(s):

Use format tooltip and then select I

Select Tooltip and use Italic option

Select worksheet and then tooltip and then use I option

Use Format , select font , slect tooltip and use Italic

Q31. Which of the following is not a geographic role

Select 1 option(s):

Airport

Area Code

City

Street/Lane

Q32. Which of the following options can be used to bold the title of the chart.

Select 2 option(s):

Go to format and select Font and then under title select bold option.

Double click on the title and bold the title

Go to format and select Font and then under edit select bold option.

Go to Worksheet and select Font and then under title select bold option.

Q33. The App with maximum number of reviews is as below .

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

Select 1 option(s):

YouTube

Candy Crush Saga

Instagram

Q34. Text is not treated as Null when Mapped datatype is

Select 1 option(s):

Numbers

Boolean

Dates

Text

Q35. Which of the following options can be used to change the palette color for dimensions

Select 1 option(s):

Assign Color

Change Color

Change Palette

Assign Palette

Q36. Which of the following is better when there is no network , and when you need better performance

Select 1 option(s):

Extract,Live

None

Extract,Extract

Live,Live

Live,Extract

Q37. Which of the following sports has equal sum of number of records measure. Please use Global Sports Finances.

Select 1 option(s):

Tennis and Boxing

Golf and Tennis

Racing and Golf

Tennis and Racing

Q38. Most viewed spot for visualizations is

Select 1 option(s):

center

top right

top left

end of the page

Q39. Please use data sheets (Global Sports Finances (Top teams payroll list)) from this link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Choose an League Team which has highest Avg Total Payroll. Average rank of that League team is

Select 1 option(s):

Q50. Which of the following can be used to include more than one set.

Select 1 option(s):

group

fixed

combined

dynamic

Q41. Which of these objects help you to integrate Tableau Dashboards with applications outside Tableau.

Select 1 option(s):

Navigation Objects

Blank Objects

Export Objects

Extension Objects

Q42. Please use the googleplaystore data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

How many apps has android version 8.0 and up ?

Select 1 option(s):

Q43. Which of the following URL prefixes is not allowed in Dashboard Actions

Select 1 option(s):

None

HTTPS

FTP

HTTP

Q44. Please use the crime data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Create a line chart using needed dimensions and measures. Which day of the week has highest total reporting areas.

Select 1 option(s):

Friday

Sunday

None

Q45. Which of the following can be removed

Select 3 option(s):

group

set

hierarchy

Unattempted

Q46. Assuming that both the table structures are same, Union of two tables will result in

Select 1 option(s):

Increase in number of rows

Decrease in number of columns

Increase in number of columns

Decrease in number of rows

Q47. blue vs green means

Select 1 option(s):

measure vs dimension

discrete vs continous

dimension vs measure

cont vs discrete

Q48. Which of the following files do not contain the actual data but rather the information necessary to connect to the actual data

Select 1 option(s):

.twbx

.hyper

.twb

.tds

Q49. Size of the marks is not significant in one of these charts

Select 1 option(s):

Area Chart

Pie Chart

Bar chart

Line chart

Q50. Please use googleplaystore.csv data sets from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Number of records in SOCIAL category is

Select 1 option(s):

295

195

395

[/ppwp]

Tableau Desktop Specialist Test - 6

Q1. Duplicate data after creating a join means that

Q2. Sorting from an axis gives this sort by default.

Q3. Option used for seeing the queries being generated for relationships in Tableau Desktop are called as

Q4. Is it possible to disable the sort option

Q5. Below are the potential advantages of changing size of the marks in tableau view.

Q6. You can aggregate the dimension in view as –

Q7. <img decoding="async" src="https://skillcertpro.com/wp-content/uploads/2021/i/07/word-image-704.png" data-pagespeed-url-hash="1151871059" /> – This symbol means that

Q8. Which one of the following is an invalid trend line model.

Q9. Which of the following chart types need atleast one dimension.

Q10. Do we have any techniques to make Viz faster ?

Q11. This level of detail expressions can be useful when you want to calculate at a fine level of detail in the database and then re-aggregate and show at a coarser level of detail in your view.

Q12. This helps to capture a point, or insight. The idea being that you can use this to guide somebody through your work to show them what you have found, and maybe even ask questions.

Q13. Below is not an URL target option possible for URL actions in Dashboards.

Q14. Use sample-superstore data to solve this question. Which of these regions have highest sales.

Q15. In Histograms below, value of outlier is ?

Q10. Do you need to define the joins up-front (using venn diagram) in latest Tableau 2020.2 version.

Q17. Is it possible to create a data visualization without a dataset.

Q18. Use sample-super store. How many marks are present in scatter plot when total profit, total quantity and Category are plotted.

Q19. Web authoring in Tableau online and Tableau server supports the following databases.

Q20. These Viz animations make the complex changes clearer by presenting them step-by-step.

Q21. Tableau reference line can be made dynamic using

Q22. By default, dimensions in Tableau are always aggregated.

Q23. These features cannot be animated in Tableau

Q24. Which of the following are true

Q25. What is the maximum number of tables we can join in tableau?

Q26. When there is only one color range seen in palette its called as

Q27. Which of the following is used for data drill down

Q28. Which of the following can be used to increase the performance when dataset is large or there are too many filters

Q29. Please use the books.csv data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q30. Which of the following options are used to italicize the content in tooltip.

Q31. Which of the following is not a geographic role

Q32. Which of the following options can be used to bold the title of the chart.

Q33. The App with maximum number of reviews is as below .

Q34. Text is not treated as Null when Mapped datatype is

Q35. Which of the following options can be used to change the palette color for dimensions

Q36. Which of the following is better when there is no network , and when you need better performance

Q37. Which of the following sports has equal sum of number of records measure. Please use Global Sports Finances.

Q38. Most viewed spot for visualizations is

Q39. Please use data sheets (Global Sports Finances (Top teams payroll list)) from this link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q50. Which of the following can be used to include more than one set.

Q41. Which of these objects help you to integrate Tableau Dashboards with applications outside Tableau.

Q42. Please use the googleplaystore data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q43. Which of the following URL prefixes is not allowed in Dashboard Actions

Q44. Please use the crime data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q45. Which of the following can be removed

Q46. Assuming that both the table structures are same, Union of two tables will result in

Q47. blue vs green means

Q48. Which of the following files do not contain the actual data but rather the information necessary to connect to the actual data

Q49. Size of the marks is not significant in one of these charts

Q50. Please use googleplaystore.csv data sets from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q51. Below are layout container types possible for dashboards

Q52. The order in which the following filters are executed :

Q53. Please use the crime.csv data set from link – https://drive.google.com/drive/folders/193Q8EyvYyrXusdS5r5ARyisK8DY0k_jt?usp=sharing

Q7. – This symbol means that