Tableau Desktop Specialist Test - 9

The Tableau Desktop Specialist mock test is a catalyst for career growth. It validates your Tableau knowledge and prepares you for certification.

Yet, catalysts alone don’t guarantee employment. 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 catalyst leads to career success by combining certification-level knowledge with advanced training and project-based learning.

Welcome to your Tableau Desktop Specialist - Test-9

Name

Phone

Q1. When creating a dashboard for multiple devices, which of the following Device type are available in the Device Preview section?

Select 1 option(s):

Desktop, Tablet, Phone, Default

Desktop, Tablet, Mobile, Default

Monitor, Tablet, Phone, Default

Screen, Tablet, Phone, Default

Q2. Which statement is true about calculated fields created in the view?

Select 1 option(s):

They can only be saved when creating it using a data pane

Create a duplicate calculated field which refer this field

They can be saved by dragging them into the data pane

None of the above

Q3. A __________ is a single zip file that contains a workbook along with any supporting local file data and background images.

Select 1 option(s):

.twb file

.twbx file

.tde file

.tds file

Q4. Why isn‘t the discount is aggregated in this view?

Select 1 option(s):

Discount is a continuous field

The Aggregate measure option is unchecked

Discount is discrete field,and discrete field is never aggregated

The stack marks option is set as Off

Q5. Which of the following is a date value?

Select 1 option(s):

May

Friday

9/21/2021

Q6. What analytic functions reveal the prevailing direction or line of best fit for a series of data points?

Select 1 option(s):

Trend Lines

Reference Line

Average Line

Constant Line

Q7. In table calculations, partitioning fields define the direction of the calculation.

Select 1 option(s):

TRUE

FALSE

Q8. In the below view, we have dragged the City Column to the view. How you will resolve the Unknown location issue?

Select 1 option(s):

Go to the Map menu -> Edit Locations then Select Country/Region to None

Go to the Map menu -> Edit Locations then Select State/Province to None

Go to the Map menu -> Edit Locations then click on Reset Matches

Add the State column to the View

Q9. As per the Tableau order of operations, which filters are executed before the context filter?

Select 2 option(s):

Extract filter

Dimension filter

Data Source filters

Sets

Q10. While using Animations in a Tableau, which is the default duration for animations?

Select 1 option(s):

0.3 seconds

0.2 seconds

0.25 seconds

0.4 seconds

Q11. Which is not true about date filters?

Select 1 option(s):

You can select the range of dates

They cannot update relative to today‘s date

You can exclude the null dates

You can exclude the Non-null dates

Q12. Which of these dashboard actions do not have target sheets?

Select 3 option(s):

Change Parameters

Change Set Values

Filter

Go to URL

Q13. Which feature of the dashboard layout pane provides extra white space around objects?

Select 1 option(s):

Position

Inner/Outer Padding

Size

Border

Q14. Why do we convert a numeric measure to a dimension?

Select 1 option(s):

To aggregate the field

To enable this field to use as a filter

To use this field in LOD

To disaggregate the field

Q15. Which are the most common type of discrete and continuous fields?

Select 1 option(s):

Discrete Dimension, Continuous Measure

Discrete Measure, Continuous Dimension

Discrete Measure, Discrete Dimension

Continuous Measure, Continuous Dimension

Q16. A dashboard action can be run on?

Select 1 option(s):

Hover

Select

All of the above

Q17. Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?

Select 2 option(s):

Click the open lock icon on right of your phone layout option

Click the 3 dots on right of your phone layout option and select Optimize Layout

Click the 3 dots on right of your phone layout option and select Auto-Generate Layout

All of the above

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

Select 1 option(s):

Floating

Fixed

Tiled

Freeze

Q19. Parameters can be used in? (Select all that apply)

Select 3 option(s):

Filters

Reference Lines

Groups

Sets

Q20. In Tableau, when you perform a blend, it is most similar to which type of join?

Select 1 option(s):

Right Join

Left Join

Full Outer Join

Inner Join

Q21. What is one of the most common use cases for context filters?

Select 1 option(s):

Top N filters

Wildcard Search

Any scenario involving geographic fields

Any scenario involving date fields

Q22. Which type of join includes all the values from both the tables?

Select 1 option(s):

Left

Right

Inner

None of the above

Q23. Which of the following fields when you add it to the view will have AGG in front of it?

Select 1 option(s):

SUM([Sales])

Discount

Date field

Geography field

Q24. What feature is used to combine multiple axis in a sheet?

Select 1 option(s):

Dual Axis

Merge Axis

Double Axis

None of the above

Q25. Which of the following uses a primary and secondary data source?

Select 1 option(s):

Blending

Relationship

Cross-database joins

Unions

Q26. What is the difference between Measure Names and Measure Values?

Select 1 option(s):

Measure Names are continuous whereas Measure Values are discrete.

Measure Name contains the name of each measure where as Measure Value contains the value of each measure

Measures Names are Tableau generated field where as Measure Values are user defined field.

None of the above

Q27. When creating a union between tables, what happens if the field names do not match?

Select 1 option(s):

It will throw an error stating the field mismatch issue

Tableau will create the Union and fields that do not have matching field names will contain null values

Tableau will merge the fields

The fields which are not matched will not be included in the Union

Q28. Which of the following statement are true? (Select all that apply)

Select 2 option(s):

Continuous fields are shown in green

Discrete fields are shown in green

Continuous fields are shown in blue

Discrete fields are shown in blue

Q29. Which of the following are true regarding the .TDS file?

Select 3 option(s):

It saves the default field properties; for example, number formats, aggregation, and sort order

It saves the calculated fields

It saves the groups, sets, bins

It saves the copy of any local file-based data or extracts

Q30. When we blend the data, sometimes a Null value appears in place of data. What could be the possible reasons for the same?

Select 3 option(s):

The data to combine is at different level of detail.

The values in the primary and secondary data sources use different casing.

The secondary data source does not contain values for the corresponding values in the primary data source.

The data types of the fields you are blending on are different.

Q31. Which of the below filter apply in the last when you build the view?

Select 1 option(s):

Dimension Filters

Context Filters

Measure Filters

Table Calculation Filters

Q32. You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?

Select 1 option(s):

Inner join

Outer join

Left join

Right join

Q33. Which marks card property controls popup data points when you hover over a mark?

Select 1 option(s):

Label

Detail

Tooltip

Color

Q34. Which layer represents the canvas for creating relationships between tables in Tableau‘s data model?

Select 1 option(s):

Physical Layer

Logical Layer

Data Layer

Extract Layer

Q35. How to rename the Measure Names field in Tableau?

Select 1 option(s):

Right Click on Measure Names, and select Rename

Rename the field from Data Source page

Rename the field from Metadata grid

None of the above

Q36. Which of the following are Table Calculations?

Select 3 option(s):

Rank

First

Last

MAX

Q37. Which of the following are true regarding extracts? (Select all that apply)

Select 3 option(s):

Can be accessed offline

Uses Tableau Data engine to perform queries

Refresh automatically

May include only subset of the data

Q38. How to add custom shapes in Tableau?

Select 1 option(s):

Go to the Tableau folder in Program files and click on defaults folder and then click Shape folder and copy your custom image.

Go to My Tableau Repository in the Documents folder and copy the custom image in Shapes folder.

On the Marks card, click on the Shapes and then select More shapes and copy your custom image.

It is not possible to add custom images in Tableau.

Q39. In the superstore dataset, we have Customer Country, Customer State, and Customer City. Using which functionality of Tableau we can quickly drill down between levels in the viz:

Select 1 option(s):

Hierarchy

Sets

Groups

Parameters

Q40. You have connected to an excel sheet that has two tables “orders“ and “returns“.You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?

Select 1 option(s):

It will only be enabled once you perform the union

It will only be enabled once you perform the join

It will only be enabled once you perform the data blending

It will only be enabled once you save the visualization to Tableau Server

Q41. _________ chart type reveals the patterns or relative concentrations that might otherwise be hidden due to an overlapping mark on a map.

Select 1 option(s):

Symbol maps

Filled maps

Density maps

Choropleth maps

Q42. What happens when you drop a continuous measure to a view?

Select 1 option(s):

It creates the label with disaggreagated values

It creates the label and aggregate the values

It creates an axis with disaggreagated values

It creates an axis and aggregate the values

Q43. Which of these chart types can be created using a single measure?

Select 1 option(s):

Treemaps

Line chart

Histogram

Stacked bars

Q44. How to save the workbook as a PDF?

Select 1 option(s):

Go to Data Source, right click on the connection and select save to PDF

Go to Worksheet, Click on export and select save as PDF

Go to File, Click on Print to PDF

None of the above

Q45. In our data set, we have the fields Region (Central, East, South, West), Segment (Consumer, Corporate, Home Office), Sales. How we can create the following view?

Select 1 option(s):

Drop Region & Segment to Columns, and Sales to Rows. Drop Region to colors

Drop Sales to Columns and Region & Segment to Rows. Drop Region to colors

Drop Region & Segment to Columns, and Sales to Rows. Drop Segment to colors

Drop Sales to Columns and Region & Segment to Rows. Drop Segment to colors

Q46. Which connection type you will use to connect Tableau to a CSV file?

Select 1 option(s):

JSON

PDF

Excel

Text

Q47. The Student field has the format “ID-Name-Class“. School staff wants to fetch the class only from the Student field. Which of the following will work here?

Select 1 option(s):

Custom split the last 1 column of the student field with “-“ as an operator

Custom split the first column of the student field with “-“ as an operator

Go to the column in Data Source tab and click on split in the dropdown

None of the above

Q48. In a combined axis chart, using which field do we get multiple measures on a single axis?

Select 1 option(s):

Measure Names

Measure Values

Number of records

None of the above

Q49. Which of the following are valid date functions?

Select 1 option(s):

DATEADD

DATESUBTRACT

ISDATE

DATENAME

Q50. You want to find out the top 10 products on the basis of the sales for the Central region. But your view is showing only 5 products. How to solve this issue?

Select 1 option(s):

Use Table Calculation

Apply Context filter to region

Add Product Name to Context filter

Add Sales to Context filter

Q51. You are using a relative date filter in your visualization, and it is set as the Last 3 months‘ data. Which 3 months data Tableau will show?

Select 1 option(s):

Last 3 months from the date you created the visualization

Last 3 months relative to the anchor date

Last 3 month from the day you open the workbook

Last 3 months from the day you last updated the view

Q52. Which of the following is true for a live connection?

Select 2 option(s):

If your data source is a database, then you need to enter the username and password to access the underlying data

Uses Tableau Data engine to perform queries

Refresh automatically

Can be accessed offline

Q53. When you want to share a workbook that contains sensitive data with your colleagues, you can publish it to __________? Select all that apply.

Select 2 option(s):

Tableau Server

Tableau Public

Tableau Reader

Tableau Online

Q54. Which of the following geographic roles are available in Tableau?

Select 3 option(s):

City

Street

Airport

County

Q55. In the following view, how you can format the profit value so that it can be shown in 2 decimal places?

Select 1 option(s):

Right Click on SUM(Profit) in the marks card, and select Format. In the header tab, go to the Numbers and select Number (Custom).

Right Click on SUM(Profit) in the marks card, and select Format. In the pane tab, go to the Numbers and select Number (Custom).

Right Click on the view and select Format. In the sheet tab, select Header and go to the Numbers and select Number (Custom).

Right Click on the view and select Format. In the row tab, select Header and go to the Numbers and select Number (Custom).

Q56. Which of the following navigation styles are available in Story ? (Select all that apply)

Select 3 option(s):

Arrows Only

Caption boxes

Numbers

Alphabets

Q57. How you can export the underlying data as a CSV file?

Select 1 option(s):

Go to the Data Menu, Select your table name and choose Export data to CSV

Right-click on the view and select Export data to CSV

Go to the Server Menu, Select your table name and choose Export data to CSV

Go to the Format Menu, Select your table name and choose Export data to CSV

Q58. Which of the following are true regarding parameter actions?

Select 3 option(s):

While creating the parameter action, you must specify the aggregation.

The aggregation that you choose for the parameter action can be different than the aggregation used for the field in the view.

You can create multiple parameter actions in your dashboard.

Using parameter action, you can update the reference line.

Q59. Which of the following are the dashboard objects?

Select 3 option(s):

Web Part

Web Page

Image

Extension

[/ppwp]

Tableau Desktop Specialist Test - 9

Q1. When creating a dashboard for multiple devices, which of the following Device type are available in the Device Preview section?

Q2. Which statement is true about calculated fields created in the view?

Q3. A __________ is a single zip file that contains a workbook along with any supporting local file data and background images.

Q4. Why isn‘t the discount is aggregated in this view?

Q5. Which of the following is a date value?

Q6. What analytic functions reveal the prevailing direction or line of best fit for a series of data points?

Q7. In table calculations, partitioning fields define the direction of the calculation.

Q8. In the below view, we have dragged the City Column to the view. How you will resolve the Unknown location issue?

Q9. As per the Tableau order of operations, which filters are executed before the context filter?

Q10. While using Animations in a Tableau, which is the default duration for animations?

Q11. Which is not true about date filters?

Q12. Which of these dashboard actions do not have target sheets?

Q13. Which feature of the dashboard layout pane provides extra white space around objects?

Q14. Why do we convert a numeric measure to a dimension?

Q15. Which are the most common type of discrete and continuous fields?

Q16. A dashboard action can be run on?

Q17. Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?

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

Q19. Parameters can be used in? (Select all that apply)

Q20. In Tableau, when you perform a blend, it is most similar to which type of join?

Q21. What is one of the most common use cases for context filters?

Q22. Which type of join includes all the values from both the tables?

Q23. Which of the following fields when you add it to the view will have AGG in front of it?

Q24. What feature is used to combine multiple axis in a sheet?

Q25. Which of the following uses a primary and secondary data source?

Q26. What is the difference between Measure Names and Measure Values?

Q27. When creating a union between tables, what happens if the field names do not match?

Q28. Which of the following statement are true? (Select all that apply)

Q29. Which of the following are true regarding the .TDS file?

Q30. When we blend the data, sometimes a Null value appears in place of data. What could be the possible reasons for the same?

Q31. Which of the below filter apply in the last when you build the view?

Q32. You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?

Q33. Which marks card property controls popup data points when you hover over a mark?

Q34. Which layer represents the canvas for creating relationships between tables in Tableau‘s data model?

Q35. How to rename the Measure Names field in Tableau?

Q36. Which of the following are Table Calculations?

Q37. Which of the following are true regarding extracts? (Select all that apply)

Q38. How to add custom shapes in Tableau?

Q39. In the superstore dataset, we have Customer Country, Customer State, and Customer City. Using which functionality of Tableau we can quickly drill down between levels in the viz:

Q40. You have connected to an excel sheet that has two tables “orders“ and “returns“.You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?

Q41. _________ chart type reveals the patterns or relative concentrations that might otherwise be hidden due to an overlapping mark on a map.

Q42. What happens when you drop a continuous measure to a view?

Q43. Which of these chart types can be created using a single measure?

Q44. How to save the workbook as a PDF?

Q45. In our data set, we have the fields Region (Central, East, South, West), Segment (Consumer, Corporate, Home Office), Sales. How we can create the following view?

Q46. Which connection type you will use to connect Tableau to a CSV file?

Q47. The Student field has the format “ID-Name-Class“. School staff wants to fetch the class only from the Student field. Which of the following will work here?

Q48. In a combined axis chart, using which field do we get multiple measures on a single axis?

Q49. Which of the following are valid date functions?

Q50. You want to find out the top 10 products on the basis of the sales for the Central region. But your view is showing only 5 products. How to solve this issue?

Q51. You are using a relative date filter in your visualization, and it is set as the Last 3 months‘ data. Which 3 months data Tableau will show?

Q52. Which of the following is true for a live connection?

Q53. When you want to share a workbook that contains sensitive data with your colleagues, you can publish it to __________? Select all that apply.

Q54. Which of the following geographic roles are available in Tableau?

Q55. In the following view, how you can format the profit value so that it can be shown in 2 decimal places?

Q56. Which of the following navigation styles are available in Story ? (Select all that apply)

Q57. How you can export the underlying data as a CSV file?

Q58. Which of the following are true regarding parameter actions?

Q59. Which of the following are the dashboard objects?

Q6. What analytic functions reveal the prevailing direction or line of best fit for a series of data points?