Tableau Desktop Specialist Test - 15

The Tableau Desktop Specialist mock test is a career signal booster. It validates your Tableau fundamentals and demonstrates initiative. Certifications boost visibility, but employers want more. They expect candidates to integrate Tableau with Power BI, SQL, SAS, and Azure, while also mastering data engineering tools like Snowflake, Databricks, and PySpark. Data science and AI skills—TensorFlow, PyTorch, LLMs, and Generative AI—are increasingly required. Project work is the ultimate proof of employability. SynergisticIT’s Data Science JOPP program ensures your certification signal translates into career readiness by equipping you with advanced skills and project experience.

Welcome to your Tableau Desktop Specialist - Test-15

Name

Phone

Q1. In Tableau, which of the following options can you use to sort a bar chart by the values of a measure?

Select 1 option(s):

Right-click the dimension in the view and choose “Sort“

Drag the measure onto the Sort shelf on the Marks card

Click the “Sort“ button in the toolbar

Right-click the measure in the Data pane and choose “Sort by Field“

Q2. What is the primary purpose of logical and physical tables in Tableau‘s data model?

Select 1 option(s):

To create a backup of the original data

To improve performance and take advantage of Tableau functionality not available in the original data

To better describe how extracts will be stored

To convert the data into a different format

Q3. In Tableau, when defining a Percent Difference From table calculation, which option calculates the difference between the current value and the first value in the partition?

Select 1 option(s):

First

Last

Q4. In Tableau, what are the two types of sets that can be created and how do they differ?

Select 1 option(s):

Dynamic sets and Static sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Static sets do not change even if the underlying data changes and can be based on a single or multiple dimensions

Dynamic sets and Fixed sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Fixed sets do not change even if the underlying data changes and can be based on a single or multiple dimensions

Dynamic sets and Variable sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Variable sets change depending on user interaction and can be based on a single or multiple dimensions

Dynamic sets and Interactive sets - Dynamic sets change when the underlying data changes and can be based on a single dimension, while Interactive sets change depending on user interaction and can be based on a single or multiple dimensions

Q5. When you need to relate tables across different databases, what should you do?

Select 1 option(s):

Add them as new data sources from the Data menu

Create a new data source from the drop-down menu next to the Data Source‘s name

Use the Add link in the Left pane to add them as data connections within the same data source

Relating tables across different databases is not possible in Tableau

Q6. How may a sheet - level field be renamed?

Select 2 option(s):

Q7. What is the under-dated portion of the following?

Select 2 option(s):

43952

5th March 2022

2022

Q8. What function is used to determine the input string‘s length?

Select 1 option(s):

Len ()

Zn ()

Find ()

Replace ()

Q9. Which of the following is the correct definition of the ZN function?

Select 1 option(s):

It uses the input expression. If the expression is positive, it returns 0.

It uses the input expression. If the expression is negative, it returns 0.

It uses the input expression. If the expression is NULL, it returns 0.

It uses the input expression. If the expression is a string, it returns 0.

Q10. Why should we prefer an extract connection over a live?

Select 2 option(s):

We can work offline: With an extract connection, we have the advantage of working offline. We can access and analyze data even without an internet connection.

Better performance for large databases: When dealing with large databases, it is recommended to use an extract connection for improved performance. Extracts are optimized subsets of data that are stored locally, allowing for faster querying and analysis.

No constant internet connection is required: Unlike live connections, extract connections do not rely on a continuous internet connection. Once the data is extracted, it is stored locally, eliminating the need for a constant internet connection.

Always up-to-date: Extracts can be refreshed to get the latest data whenever needed. By refreshing the extract, we can ensure that we are working with the most updated information.

Q11. Why is joining better than a relationship?

Select 3 option(s):

Joining is possible when we are working with the same data source.

Joining provides different options to combine two tables.

Joining reduces the size.

Joining supports different data sources.

Q12. If you first drag a dimension field to the row shelf, then a measure field to the column shelf, the chart type you will get in the view is a _____ graph.

Select 1 option(s):

Line

Bar

Circle

Bubble

Q13. Number of dimensions to create a heat map?

Select 1 option(s):

One measure.

Zero measure and more dimension.

1 or more dimensions and 1 or 2 measures.

One or more dimensions.

Q14. Which method do we use for forecasting?

Select 1 option(s):

Trend line

Binomial

Exponential smoothing

Smoothing

Q15. Which of the following helps to reduce the size of the extract?

Select 2 option(s):

By hiding unused fields.

Using aggregation on the measures.

Increasing the connection between tables.

Inner joining the tables.

Q16. Measure create axis when dragging to column or row shelf

Select 1 option(s):

TRUE

FALSE

Q17. What is the use of marks in the tableau?

Select 1 option(s):

Proper viz.

For better performance.

Marks to control the visual features of view in a plot.

None

Q18. What if we create a group using the marks?

Select 1 option(s):

We will get a set type.

We will get a field on the dimension section in the data pane the grouped values will represent in blue colour.

No of mark increase.

No effect.

Q19. How to add a new data source connection in tableau at the data source page

Select 12 option(s):

Go to file in menu bar then new file.

Click on add in the connection pane.

We can’t connect new data source.

Go to data in the menu bar -> Data-> new data source.

Q20. Aliases we can create only for discrete dimensions

Select 1 option(s):

TRUE

FALSE

Q21. For contribution analysis, the recommended quick table calculation to use is

Select 1 option(s):

Difference

Percentage of total

Sum

Moving age

Q22. What does it mean * after the ATTR function?

Select 1 option(s):

No value present in the expression.

It represents the input expression contains multiple values.

When one value is zero.

Calculation is not supports.

Q23. What are the ways we can change the tooltip contents?

Select 2 option(s):

Go to marks card -> tooltips

Mouse right-click (on view) -> format-> default -> tooltip

Worksheet in menu bar -> tooltip

Dashboard -> format

Q24. Which of the following displays a blue pill?

Select 2 option(s):

Sales

Percentage of contribution

Order id

State

Q25. It is possible to delete an auto-generated field.

Select 1 option(s):

TRUE

FALSE

Q26. We can convert a dimension to a measure.

Select 1 option(s):

TRUE

False

Q27. We can add a trend line to a scatterplot.

Select 1 option(s):

TRUE

False

Q28. Which of the following is true about dimension?

Select 3 option(s):

State, country etc are dimension

Dimension create header when we drag to column and row shelf

We can’t convert a dimension to measure

We can create BIN on dimension

Q29. How to clear a worksheet

Select 3 option(s):

Alt + Shift + Backspace (shortcut)

Go to clear work sheet icon in tool bar and press

Go to worksheet in menu bar -> worksheet -> clear

None of above

Q30. Which of the following is correct about relationships?

Select 3 option(s):

Relationships don’t change the table structure.

To combine tables from different data sources, we use relationships.

It occurs at a logical layer.

Relationships are executed at sheet levels.

Q31. Which of the following is true about action?

Select 2 option(s):

We can add actions at the sheet level.

Action is used to create the interactive relationship between date, worksheets, and URL.

Action change the data types.

Action helps to change the dashboard layout.

Q32. Is it possible to add two work sheets at the same time to a dashboard?

Select 1 option(s):

YES

Q33. Which of the following auto-generated measures supports an alias?

Select 1 option(s):

Measure name

Latitude

Longitude

Measure value

Q34. Is it possible to change the aggregation or alias of the published data source?

Select 1 option(s):

YES

Q35. We can create a reference line, reference band, and distribution band from the analytic pane for a continuous axis.

Select 1 option(s):

TRUE

False

Q36. Show title is disabled in the dashboard by default.

Select 1 option(s):

TRUE

False

Q37. What are the default properties available for a dimension?

Select 1 option(s):

Boolean

Comment

String

MAP

Q38. Is it possible to create a BIN on a dimension?

Select 1 option(s):

YES

Q39. It is possible to add two reference lines for the same axis.

Select 1 option(s):

TRUE

False

Q40. Which of the following are representations of geographic role types?

Select 3 option(s):

Airport

Area code

Village name

CBSA/ MSA

Continent

Q41. Bubble charts don’t have any axes.

Select 1 option(s):

TRUE

False

Q42. Can we sort as per date?

Select 1 option(s):

YES

Q43. Which of the following is true for incremental and extract refresh?

Select 2 option(s):

An incremental refresh takes less time to update the dataset compared to a full refresh.

An incremental refresh only adds the newly added rows to the existing table.

An incremental refresh increases the data size.

A full refresh is faster than an incremental refresh.

Q44. Which pane does the below figure indicate?

Select 1 option(s):

DATA PANE

Filter

Parameter

Data source page

Q45. We can add a calculated field to the reference line.

Select 1 option(s):

TRUE

False

Q46. What is the P value in the trend line?

Select 1 option(s):

P <= 0.05

P = 0

P >= 0

P >= 0.05

Q47. Which of the following is true for the TDS file type?

Select 2 option(s):

It stores the connection information.

It stores local data.

filter settings.

It contains groups, set, bins.

Q48. We can pass SET, GROUP, and PARAMETERS in calculated fields.

Select 1 option(s):

TRUE

FALSE

Q49. Choose the correct representation of the animation type.

Select 2 option(s):

Sequential animation takes more time than simultaneous animation.

Simultaneous animation is the default.

The default animation duration is 1 minute.

We can create animations at the dashboard level.

Q50. Which one, if not correct for quick filter options, is available for dimension?

Select 1 option(s):

Single value (slider)

Single value (list)

Multi value (custom list)

None

Q51. When we drag dimensions to the shelf, it will create a header.

Select 1 option(s):

TRUE

False

Q52. Default marks type in the marks card Tableau

Select 1 option(s):

Circle

Bar

Automatic

Polygon

Q53. Choose different ways to create groups.

Select 3 option(s):

In the data pane, select the particular file on which we want to create a group, right-click the mouse button, create, and then group.

Select the marks you want to group from view by pressing the ctrl key -> mouse right button -> group.

Select the headers from the view -> group icon on the tool bar.

None of the above

Q54. How to add a new data source connection in Tableau at the sheet level

Select 2 option(s):

Go to data in the menu bar: Data->New Data Source.

Go to Work Sheet in the menu bar and add a new data source.

Click on the new data source icon on the sheet level.

We can’t connect to any new data sources.

Q55. Can we export our workbook in a lower version from the current version?

Select 1 option(s):

Yes

Q56. Which of the following can we add by quick table calculation?

Select 3 option(s):

Difference form

Percentage of total

Moving average

Sum ()

Q57. To visualize the year-over-year (YOY) growth of sales, the chart we should prefer is a ______ chart.

Select 1 option(s):

Line

Bar

Circle

Pie

Q58. How do I change the sheet title to italic?

Select 2 option(s):

Double click on the work sheet title -> change the font style.

Right click on the title -> edit title-> change the font style.

We can’t change the title.

Go to worksheets in the menu bar and change the title.

Q59. Which of the following is a green pill?

Select 2 option(s):

State

Sales

Ship mode

Measure value

Q60. What are the different ways we can sort?

Select 3 option(s):

Tool bar

Header

Legend

None

[/ppwp]

Tableau Desktop Specialist Test - 15

Q1. In Tableau, which of the following options can you use to sort a bar chart by the values of a measure?

Q2. What is the primary purpose of logical and physical tables in Tableau‘s data model?

Q3. In Tableau, when defining a Percent Difference From table calculation, which option calculates the difference between the current value and the first value in the partition?

Q4. In Tableau, what are the two types of sets that can be created and how do they differ?

Q5. When you need to relate tables across different databases, what should you do?

Q6. How may a sheet - level field be renamed?

Q7. What is the under-dated portion of the following?

Q8. What function is used to determine the input string‘s length?

Q9. Which of the following is the correct definition of the ZN function?

Q10. Why should we prefer an extract connection over a live?

Q11. Why is joining better than a relationship?

Q12. If you first drag a dimension field to the row shelf, then a measure field to the column shelf, the chart type you will get in the view is a _____ graph.

Q13. Number of dimensions to create a heat map?

Q14. Which method do we use for forecasting?

Q15. Which of the following helps to reduce the size of the extract?

Q16. Measure create axis when dragging to column or row shelf

Q17. What is the use of marks in the tableau?

Q18. What if we create a group using the marks?

Q19. How to add a new data source connection in tableau at the data source page

Q20. Aliases we can create only for discrete dimensions

Q21. For contribution analysis, the recommended quick table calculation to use is

Q22. What does it mean * after the ATTR function?

Q23. What are the ways we can change the tooltip contents?

Q24. Which of the following displays a blue pill?

Q25. It is possible to delete an auto-generated field.

Q26. We can convert a dimension to a measure.

Q27. We can add a trend line to a scatterplot.

Q28. Which of the following is true about dimension?

Q29. How to clear a worksheet

Q30. Which of the following is correct about relationships?

Q31. Which of the following is true about action?

Q32. Is it possible to add two work sheets at the same time to a dashboard?

Q33. Which of the following auto-generated measures supports an alias?

Q34. Is it possible to change the aggregation or alias of the published data source?

Q35. We can create a reference line, reference band, and distribution band from the analytic pane for a continuous axis.

Q36. Show title is disabled in the dashboard by default.

Q37. What are the default properties available for a dimension?

Q38. Is it possible to create a BIN on a dimension?

Q39. It is possible to add two reference lines for the same axis.

Q40. Which of the following are representations of geographic role types?

Q41. Bubble charts don’t have any axes.

Q42. Can we sort as per date?

Q43. Which of the following is true for incremental and extract refresh?

Q44. Which pane does the below figure indicate?

Q45. We can add a calculated field to the reference line.

Q46. What is the P value in the trend line?

Q47. Which of the following is true for the TDS file type?

Q48. We can pass SET, GROUP, and PARAMETERS in calculated fields.

Q49. Choose the correct representation of the animation type.

Q50. Which one, if not correct for quick filter options, is available for dimension?

Q51. When we drag dimensions to the shelf, it will create a header.

Q52. Default marks type in the marks card Tableau

Q53. Choose different ways to create groups.

Q54. How to add a new data source connection in Tableau at the sheet level

Q55. Can we export our workbook in a lower version from the current version?

Q56. Which of the following can we add by quick table calculation?

Q57. To visualize the year-over-year (YOY) growth of sales, the chart we should prefer is a ______ chart.

Q58. How do I change the sheet title to italic?

Q59. Which of the following is a green pill?

Q60. What are the different ways we can sort?

Q61. Is it possible to convert a measure to a dimension?

Q62. How do I edit the row and column labels?

Q63. Which of the following is true about measure?

Q64. How can we increase the mark on the views evenly?

Q65. Which of the following are dashboard objects?