Tableau Desktop Specialist Test - 13

The Tableau Desktop Specialist mock test provides a competitive edge by validating your Tableau fundamentals. 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 that mirror industry challenges. Certifications help you stand out; SynergisticIT ensures you stay ahead. Learn more: Job Placement Program.

Welcome to your Tableau Desktop Specialist - Test-13

Name

Phone

Q1. In Tableau, how do you change the default color properties for a specific data field?

Select 1 option(s):

Navigate to “Map“ -> “Edit Colors“ and select the color scheme.

Right-click on the data field on the “Data“ pane and select “Default Properties“ -> “Color“

Navigate to “Format“ -> “Color“ and select the color scheme

Right-click on the chart, select “Format“ -> “Color“ and choose the color scheme

Q2. Which of the following is NOT a type of join supported by Tableau?

Select 1 option(s):

Inner join

Right join

Full Outer join

Upper join

Q3. Which of the following statements is true about live connections and data security in Tableau Desktop?

Select 1 option(s):

Live connections are less secure than extract connections because they allow direct access to the data source

Live connections are more secure than extract connections because they do not store data in Tableau Desktop

Live connections and extract connections offer the same level of data security

None of the above

Q4. How do you connect to multiple data sources without joining or blending in Tableau?

Select 1 option(s):

Go to the top menu bar, select “File“ -> “Connect to Data“, and choose the new data sources to connect

Use the “Data Source“ tab, and go to the top menu bar, select “File“ -> “Add New Data Source“ and choose the new data sources to connect

Right-click an existing data source on your worksheet and choose “Add New Data Source“ and choose the new data sources to connect

Go to the top menu bar, select “Data“ -> “New Data Source“, and choose the new data sources to connect

Q5. How do you save metadata properties in a .TDS file in Tableau?

Select 1 option(s):

Select “Save As“ from the “File“ menu and choose the .TDS file format

Select “Export As“ from the “Data“ menu and choose the .TDS file format

At the top of the Data pane, right-click the name of the data source, and then select “Add to Saved Data Sources“, and choose .TDS file type, and then click “Save“

None of the above

Q6. What does the term “Dimension“ refer to in Tableau?

Select 1 option(s):

A continuous field used to measure something

A discrete field used to categorize data

A field that represents a date or time value

A field that represents a numeric value

Q7. How can you change the default aggregation for a numeric field?

Select 1 option(s):

Right-click the field and select “Default Properties“ -> “Number Format“ -> “Change Aggregation“

Right click on the data field on the “Column“ or “Row“ shelf and select “Change Aggregation Measures“

Navigate to “Format“ -> “Aggregate Measures“ and select from the dialog box

None of the above

Q8. Which of the following is NOT how to view the underlying data for a specific data point in a Tableau visualization?

Select 1 option(s):

Right-click the data point and select “View Data“

Click the data point in the view and click on the “View Data“ icon

Select the data point and choose “View Data“ from the “Data“ menu

Select the data point and choose “View Data“ from the “Analysis“ menu

Q9. How can you split a single field containing multiple values into separate fields?

Select 1 option(s):

Right-click the field in the Data pane and select “Split“

Right-click the field in the Data pane and select “Transform“ -> “Split“

Click on the field in the Data pane, then select the “Custom Split“ option from the “Analysis“ menu

Both B and C

Q10. What function would you use in a calculated field to find the difference in days between two dates?

Select 1 option(s):

DATEDIFF

DATEADD

DAYDIFF

DATEPART

Q11. Which of the following chart types is best suited for visualizing hierarchical data in Tableau?

Select 1 option(s):

Heat map

Tree map

Highlight table

Density map

Q12. What is the primary function of the Tableau Data Interpreter?

Select 1 option(s):

To automatically clean and reshape data for analysis

To interpret data types and assign appropriate roles to fields

To provide suggestions for data visualizations based on the data set

To enable natural language processing for data queries

Q13. Which of the following is NOT an Aggregate function for the Calculated Field in Tableau?

Select 1 option(s):

COLLECT

STDEVP

VARAVG

CORR

Q14. In Tableau, when creating a story, what happens when you add a sheet to a story point?

Select 1 option(s):

The sheet is disconnected from the original sheet and any changes to the original sheet will not be reflected in the story point

The sheet is copied into the story point and any changes to the original sheet will not be reflected in the story point

The sheet is linked to the original sheet and any changes to the original sheet will automatically be reflected in the story point

The sheet is moved from the original location to the story point and will no longer exist outside the story point

Q15. How can you display the top N members of a dimension in Tableau?

Select 1 option(s):

Use a table calculation

Use a context filter

Use a Top N filter

Use a parameter

Q16. What is the purpose of using the INDEX() function in Tableau?

Select 1 option(s):

To retrieve the value of a specific row in a data source

To return the index of the current row in the partition

To return the index of a specific member within a dimension

To return the position of the nth occurrence within the column

Q17. In Tableau, what does the term “granularity“ refer to?

Select 1 option(s):

The level of detail or depth of data in a dataset or a view

The process of breaking down a dimension into smaller parts

The size of the marks in a visualization

The data is aggregated or summarized by using Table Calculation

Q18. In Tableau, which chart type is best suited for showing the distribution of a single measure across different categories?

Select 1 option(s):

Gantt chart

Bar chart

Line chart

Area chart

Q19. What is the primary purpose of using a table calculation in Tableau?

Select 1 option(s):

To apply transformations on data based on what is currently in the visualization

To create a complex formulas in a calculated field based on user input

To create new dimensions based on existing measures

To create relationships between multiple measures

Q20. Which of the following is NOT on the drop-down list of the Marks card?

Select 1 option(s):

Gantt Bar

Rectangle

Map

Density

Q21. Which of the following is a file type that can be used as a data source in Tableau?

Select 1 option(s):

Spatial file

JSON file

Statistical file

All of the above

Q22. What is the primary purpose of the “Rank“ table calculation in Tableau?

Select 1 option(s):

To determine the order of values by using an Aggregate function

To calculate the difference between the highest and lowest values in a range

To order your data based on a particular measure or dimension

To calculate the percentage of total values within a specific dimension

Q23. How can you display a reference line in a Tableau visualization?

Select 1 option(s):

Drag the measure onto the Reference Line shelf on the Marks card

Right-click the axis in the view and choose “Add Reference Line“

Choose “Add Reference Line“ from the Analysis menu

Both B and C

Q24. In Tableau, which function returns the number of rows in the partition?

Select 1 option(s):

TOTAL

SIZE

LAST

LOOKUP

Q25. Which of the following is an option for customizing the “Map Layers“ in Tableau?

Select 1 option(s):

Water Labels

Terrain

Points of Interest

All of the above

Q26. In Tableau, which of the following best describes the difference between the Relationship layer and the Join layer?

Select 1 option(s):

The Relationship layer is for blending data sources, whereas the Join layer is for joining tables from the same data source.

The Relationship layer allows for flexible interactivity between tables, preserving each table‘s level of detail. The Join layer combines tables based on common fields.

The Join layer allows for flexible interaction between tables, whereas the Relationship layer combines tables based on common fields.

The Relationship layer and the Join layer perform the same function; there is no difference between the two.

Q27. In Tableau, what is the purpose of the “Show Me“ panel?

Select 1 option(s):

To display recommended visualizations based on the data fields currently in use

To show an overview of all the worksheets in a workbook

To reveal hidden worksheets or dashboards

To preview the data source before connecting to it

Q28. In Tableau, if you have two measures of different scales and you wish to create a Dual Axis chart, which of the following steps should you follow?

Select 1 option(s):

Drag the first measure to Rows, then drag the second measure to the right of the first in the Rows shelf to automatically create a combined axis chart.

Drag the first measure to Rows, and then drag the second measure directly onto the axis of the first measure in the view.

Drag the first measure to the Rows shelf, and then drag the second measure to the right of the first in the Rows shelf, and then right-click the axis of the second measure and choose ‘Dual Axis‘.

Drag the first measure to Rows, then drag the second measure to the right of the first in the Rows shelf, and then right-click the axis of the second measure and choose ‘Edit Axis‘ - > ‘Combine Axis‘.

Q29. What is the primary purpose of a parameter in Tableau?

Select 1 option(s):

To store a single value that can be referenced in calculations

To allow users to interactively change the data being displayed in a visualization

To define the fixed format and appearance of a visualization

To create a reusable filter that can be applied to multiple worksheets

Q30. Which of the following is true about blending data in Tableau?

Select 1 option(s):

It combines data from multiple data sources at the row level

It combines data from multiple data sources at the field level

It requires a common dimension to link the data sources

Both B and C

Q31. In Tableau, which of the following functions can be used to create a calculated field that determines the day of the week for a given date?

Select 1 option(s):

DAY(date)

DATEPART(‘weekday‘, date)

WEEKDAY(date)

DAYPART(‘weekday‘, date)

Q32. What is the purpose of a dashboard Action in Tableau?

Select 1 option(s):

To create a dynamic link between multiple worksheets

To perform an action, such as filtering or highlighting, when a user interacts with a visualization

To apply a specific format or style to multiple visualizations at once

To define a custom calculation that updates automatically when the data source changes

Q33. Which of the following chart types is best suited for displaying the distribution of a single continuous variable?

Select 1 option(s):

Bar chart

Line chart

Histogram

Pie chart

Q34. In Tableau, which of the following is TRUE regarding the difference between continuous and discrete dates?

Select 1 option(s):

Discrete dates can‘t be used to create time series charts

Discrete dates create headers while continuous dates create an axis

Continuous dates are always displayed as blue pills

Continuous dates can‘t be part of a hierarchy

Q35. When dealing with a large data source in Tableau, which type of filter would you use to improve performance?

Select 1 option(s):

Dimension Filter

Extract Filter

Data Source Filter

Top N Filter

Q36. Which of the following is NOT a type of “Legend“ in Tableau?

Select 1 option(s):

Color legend

Size legend

Map legend

Shading legend

Q37. In Tableau, which of the following steps should be taken when creating a device-specific dashboard for smaller screens, such as phones or tablets?

Select 1 option(s):

Remove unnecessary views, filters, titles, and legends to limit the number of objects on the dashboard

Use a “peek” to indicate when more content is available by scrolling on a scrollable dashboard

For scrollable dashboards, pin your maps and disable pan and zoom

All of the above

Q38. Which of the following is the correct sequence of steps to publish a Tableau dashboard to a Tableau server?

Select 1 option(s):

Open workbook in Tableau Desktop > Select Server > Publish Workbook > Select the project, enter a workbook name, and add search tags > Accept the default project settings for permissions > Edit data sources if needed > Configure variable publishing options > Click Publish

Open workbook in Tableau Desktop > Configure variable publishing options > Select Server > Publish Workbook > Select the project, enter a workbook name, and add search tags > Accept the default project settings for permissions > Edit data sources if needed > Click Publish

Open workbook in Tableau Desktop > Select the project, enter a workbook name, and add search tags > Select Server > Publish Workbook > Accept the default project settings for permissions > Edit data sources if needed > Configure variable publishing options > Click Publish

Open workbook in Tableau Desktop > Select Server > Publish Workbook > Edit data sources if needed > Accept the default project settings for permissions > Select the project, enter a workbook name, and add search tags > Configure variable publishing options > Click Publish

Q39. Which is an option (or options) to export a visualization to an external application format from the File menu?

Select 1 option(s):

Export As PowerPoint

Print to PDF

Export As MS Word

Both A and B

Both A and C

Q40. What is a default Duration for Animations on a Tableau worksheet?

Select 1 option(s):

0.20 seconds

0.10 seconds

0.30 seconds

0.40 seconds

Q41. In Tableau, when using a measure in the ‘Size‘ shelf of the Marks card in a scatter plot, which of the following settings is NOT an available option to customize the size of marks?

Select 1 option(s):

Sizes vary From zero

Sizes vary Automatically

Sizes vary By range

Sizes vary From Negative range to Positive range

Q42. What is the difference between a join and a union in Tableau?

Select 1 option(s):

A join combines two or more tables based on a common field, while a union combines two or more tables with the same structure

A join combines two or more tables with the same structure, while a union combines two or more tables based on a common field

A join and a union are the same thing in Tableau

A join creates a hierarchy between tables, while a union creates a flat structure

Q43. When you rename a field in Tableau, which of the following is true?

Select 1 option(s):

The new name will be applied only to the current worksheet

The new name will be applied to all worksheets that use the field

The new name will be applied to the underlying data source

The new name will be applied to all worksheets that use the field and the underlying data source

Q44. When customizing the Worksheet Summary Card in Tableau, which of the following is NOT an available option that you can select to show on the Summary Card?

Select 1 option(s):

Standard deviation

Third quartile

Totals

Skewness

Q45. In Tableau, how do you assign a geographic role to a data field?

Select 1 option(s):

In the Data pane, right-click on the field, select ‘Default Properties‘ -> ‘Geographic Role‘, and then select the desired geographic role

In the Data pane, right-click on the field, select ‘Geographic Role‘ from the ‘Map‘ dropdown menu , and then select the desired geographic role

In the toolbar, click on ‘Geographic Role‘, and select the field and the desired geographic role

In the Data pane, click the data type icon next to the field, select ‘Geographic Role‘, and then select the desired geographic role

Q46. What is the purpose of the FIXED Level of Detail (LOD) expression in Tableau?

Select 1 option(s):

To calculate an aggregation based on the dimensions specified in the expression, regardless of other dimensions in the view

To calculate an aggregation only for the dimensions included in the view

To eliminate a specific dimension in the view

To create a constant value that can be used as a reference line or benchmark

Q47. In Tableau, which of the following is NOT a Table Calculation

Select 1 option(s):

MODEL_PERCENTILE()

PREVIOUS_VALUE()

SCRIPT_REAL()

STDEVP()

Q48. In Tableau, which of the following options allows you to create a group from multiple members of a dimension?

Select 1 option(s):

Right-click the dimension and select “Create Group“

Drag the members to the Rows or Columns shelf and choose “Group“

Right-click the members in the view and select “Group“

Drag the dimension to the Group shelf on the Marks card

Q49. Which of the following chart types is best suited for visualizing the relationship between two continuous measures?

Select 1 option(s):

Scatter plot

Bar chart

Line chart

Pie chart

Q50. In Tableau, when sorting data in a visualization, what is the difference between a nested sort and a non-nested (or comparative) sort?

Select 1 option(s):

A nested sort considers each pane independently and sorts the rows per pane, while a non-nested sort considers the value across panes and has the same order of values per pane

A nested sort considers the value across panes and has the same order of values per pane, while a non-nested sort considers each pane independently and sorts the rows per pane

A nested sort only sorts data alphabetically, while a non-nested sort sorts data based on numerical values

A nested sort only sorts data based on numerical values, while a non-nested sort sorts data alphabetically

Q51. What type of join should you use if you want to keep all the records from both tables, with null values for non-matching records?

Select 1 option(s):

Inner join

Left join

Right join

Full outer join

Q52. Which of the following is a method for improving the interactivity of a Tableau dashboard?

Select 1 option(s):

Creating dashboard actions

Extracting data instead of using a live connection

Adding a hierarchy to a dimension

Using a table calculation

Q53. In Tableau, when showing grand totals in a visualization, which of the following conditions must be met?

Select 1 option(s):

The view must have at least one header

Measures must be aggregated

Grand totals can be applied to continuous dimensions

All of the above

A and B only

Q54. Which of the following is NOT a type of geographic role that can be assigned to a dimension in Tableau?

Select 1 option(s):

Airport

NUTS Europe

Congressional District

Continent

Q55. How can you display data labels for a specific measure in a Tableau visualization?

Select 1 option(s):

Drag the measure to the Rows or Columns shelf

Drag the measure to the Label shelf on the Marks card

Right-click the axis and select “Show Data Labels“

Use the “Show Me“ panel to add data labels

Q56. What is the primary purpose of Tableau Accelerators?

Select 1 option(s):

To create custom visualizations using programming languages

To speed up the performance of Tableau Server

To provide pre-built solutions for common business use cases

To automate the creation of Tableau dashboards for complex business use cases

Q57. In Tableau, when creating bins from a continuous measure, which of the following statements is true?

Select 1 option(s):

You can bin data for both relational and non-relational data sources

Binned fields can be used in calculations

When you create bins from a measure, you create a new dimension

Once a dimension is created from bins, it cannot be converted to a continuous dimension

Q58. Which of the following is NOT an option from the ‘Show View Toolbar‘ under the Worksheet menu

Select 1 option(s):

Automatic

Unhide

Show on Hover

Hide

Q59. In Tableau, when creating a density map, which of the following steps is NOT part of the process?

Select 1 option(s):

Assigning a geographic role to your latitude and longitude fields

Adding distinct marks to the view

Changing the mark type to density

Adjusting the color, intensity, and size of your marks

Assigning a numeric role to your latitude and longitude fields

Q60. In Tableau, when creating maps from spatial files, which of the following statements is NOT correct?

Select 1 option(s):

Tableau can connect to Shapefiles, MapInfo tables, KML files, GeoJSON files, TopoJSON files, and Esri File Geodatabases

To connect to spatial files, you must include all of the necessary files in the same directory

When you connect to spatial data, Tableau creates a Geometry field for your point geometries or your polygons

You can connect to mixed geometry types

Q61. What is the purpose of blending data in Tableau?

Select 1 option(s):

To create a new data source by combining data from two or more data sources

To perform real-time analysis on a data source

To improve workbook performance

To visualize data from multiple data sources in a single view

Q62. What is the primary purpose of using a diverging color palette in Tableau?

Select 1 option(s):

To highlight data points that are equidistant from a central value

To group data points based on their categorical values

To create a sequential color scheme for ordinal data

To use a single color to represent all data points in a view

Q63. Which of the following is NOT a type of dashboard action in Tableau?

Select 1 option(s):

Go to URL

Change Set Values

Change Parameter

Change Group Values

Q64. In Tableau, how do you merge two sets together to create a combined set?

Select 1 option(s):

Select both sets, right-click and choose “Create Merged Set“

Use the UNION function in a calculated field

Select both sets, right-click and choose “Create Combined Set“

Create a combined set by dragging one set onto another in the Data pane

Q65. In Tableau, when using custom fonts, which of the following statements is true?

Select 1 option(s):

Custom fonts are downloaded with the workbook when it is downloaded from Tableau Server

Custom fonts do not need to be installed on the computers running Tableau Desktop or Tableau Server

If a custom font is not installed on Tableau Server, the font will be replaced with a default font upon publishing

Custom fonts can be used in Tableau without appearing in the formatting pane in Tableau Desktop

[/ppwp]