Tableau Desktop Specialist Test - 7

The Tableau Desktop Specialist mock test is a marker of growth in your analytics journey. It validates your Tableau knowledge and demonstrates commitment to learning. Yet, growth markers alone don’t secure jobs. Employers want professionals who can combine 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 equally vital. Project work is the ultimate proof of employability. SynergisticIT’s Data Science JOPP program ensures your growth translates into career success. Learn more: Data Science JOPP.

Welcome to your Tableau Desktop Specialist - Test-7

Name

Phone

Q1. Which of the following is not a Trend Line model?

Select 1 option(s):

Linear

Logarithmic

Cluster

Power

Q2. In which case you will merge the mismatched fields? Select the most appropriate one.

Select 1 option(s):

Blend

Union

Inner Join

Left Join

Q3. Which feature of the Tableau can be useful when you want to show more relevant or descriptive dimension values in your view than what the original data provides?

Select 1 option(s):

Set

Group

Rename

Alias

Q4. Which of the following is not a default property that can be set for a dimension?

Select 1 option(s):

Color

Shape

Sort

Aggregation

Q5. If you have the Date field (year and quarter) in the columns shelf and total profit in the Text marks card. You apply the difference table calculation with default configurations. What is the very first quarter value you will get?

Select 1 option(s):

Zero (0)

null

Same as the Q2 value

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

Select 1 option(s):

Dimension Filters

Table Calculation Filters

Context Filters

Measure Filters

Q7. You want to show the average profit on the reference line, but the profit field is not available. How you will do without making any changes in visualization?

Select 1 option(s):

Drop the profit to Size Marks card

Drop the profit to Detail Marks card

Drop the profit to Colour Marks card

Drag profit to the view

Q8. Which scope and direction you will use to compute the Percent of total Table calculation that sums up to 100% at the end of each column in crosstab?

Select 1 option(s):

Table (down)

Table (across)

Cell

Pane

Q9. How the tds file can be created?

How the tds file can be created?

Select 1 option(s):

Go to the Data menu, select the data source, and then select Add to Saved Data Sources.

Go to the Worksheet menu, right-click the name of the data source, and then select Add to Saved Data Sources.

Go to the Server menu, right-click the name of the data source, and then select Add to Saved Data Sources.

Go to the File menu, right-click the name of the data source, and then select Add to Saved Data Sources.

Q10. When using a Blend, the primary and secondary data sources have tick marks and they are represented using which color?

Select 1 option(s):

Primary - Blue, Secondary - Orange

Primary - Orange, Secondary - Blue

Primary - Green, Secondary - Yellow

The primary data source shows tick mark only and not represented by any color.

Q11. When working with Excel, text file data, JSON file, .pdf file data, you can also use _____________ to union files across folders, and worksheets across workbooks.

Select 1 option(s):

wildcard search

logarithmic search

fast search

text search

Q12. Which of the following are true for relationships in Tableau?

Select 2 option(s):

Relationships can be only one-to-many

It requires you to select join types

Require you to select matching fields between two logical tables

Are displayed as flexible noodles between logical tables

Q13. What are the Animation styles in Tableau? (Select all that apply)

Select 2 option(s):

Sequential

Parallel

Simultaneous

Linear

Q14. Which of the following is reasons to build a dashboard? (Select all that apply)

Select 3 option(s):

Explore relationships in data.

Display multiple worksheets at once.

Reduce the size of the workbook.

Views can interact with one another.

Q15. In Tableau, how to convert the number to currency?

Select 1 option(s):

Right-click on the View and select Format. Then in the Format pane, click on Number format

Right-click on the measure, click on default properties and click on Number format

Go to the Format menu, click on default properties and click on Number format

None of the above

Q16. A manager wants to build a view showing employees who are in his project that also provide the training to the junior staff in the company. The employee table is on the left and contains data for all the employees of his project. The staff training is on the right and contains data for all the employees who work as instructors in training programs. You will use which join type to create the chart in this scenario?

Select 1 option(s):

Inner Join

Left Join

Right Join

Full Outer Join

Q17. Which of these are Tableau-generated fields? (Select all that apply)

Select 3 option(s):

Measure Name

Measure Value

Country

Latitude

Q18. Groups can be used in a calculated field.

Select 1 option(s):

TRUE

FALSE

Q19. We have a graph that shows the profit recorded for each region. Now we want to change it to a Combined Axis chart by dropping sales to the Y-axis (Profit). Now, what will be the field(s) added to the Columns and Rows shelves?

Select 1 option(s):

Measure Value to the Columns and Measure Names to the Rows

Measure Names to the Columns and Measure Values to the Rows

Both the Measure Names and the Measure Values to the Rows

SUM(Sales) to the Rows

Q20. You need to create a filled map using the City field, you drop the City field to your view. And you get the error 353 unknown, what does it mean, and how you will fix this issue?

Select 1 option(s):

The city name must be misspelled. Correct the spelling to fix the issue.

More than one city has that name. Update the data type of the field to fix this issue.

More than one city has that name. Drop the State field to the view

Click on the Reset matches button to fix this issue.

Q21. You want to open http://www.google.com in one of the containers in your dashboard. How you can achieve it?

Select 1 option(s):

Using Embedded Object

Using HTML page object

Using Web page object

Using Webpart object

Q22. You have created a scatter plot that shows the relationship between Sales and Profit for each sub-category. Now you want to add another continuous measure ‘Quantity‘. On which marks card, you will drop the ‘Quantity‘? Select the most appropriate one.

Select 1 option(s):

Size

Label

Tooltip

All of the above

Q23. What will happen when you drag and drop a continuous field to the columns shelf in your newly created worksheet?

Select 1 option(s):

It will create the vertical axis.

It will create the horizontal axis.

It will create the vertical header.

It will create the horizontal header.

Q24. In Trend lines, which statistical measure defines how well the trend fits the data?

Select 1 option(s):

R-squared

P-value

P-squared

R-value

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

Select 2 option(s):

Measures are always aggregated by default

Dimension increases the granularity of the view

Quick table calculations can be applied to dimensions

Measure can never be discrete

Q26. Which of the following fields will not be aggregated when you add it into the view?

Select 1 option(s):

Calculated Field SUM(Sales)

A continuous measure [Profit]

Calculated Field [Profit]*10

None of the above

Q27. Tableau computes Attribute using the following formula:

Select 1 option(s):

IF MIN([dimension]) = MAX([dimension]) THEN MAX([dimension]) ELSE “*“ END

IF MIN([dimension]) = MAX([dimension]) THEN MIN([dimension]) ELSE MAX([dimension]) END

IF MIN([dimension]) = MAX([dimension]) THEN ELSE MAX([dimension]) MIN([dimension]) END

IF MIN([dimension]) = MAX([dimension]) THEN MIN([dimension]) ELSE “*“ END

Q28. In your dataset, you have a column ‘Product ID‘ that contains all unique values but few Null values as well. You need to count the number of products. Which of the scenario is true?

Select 1 option(s):

COUNTD([Product ID]) will ignore the Null values, but COUNT([Product ID]) will count the Null values as well

Both COUNTD([Product ID]) and COUNT([Product ID]) will ignore the Null values

COUNT([Product ID]) will ignore the Null values, but COUNTD([Product ID]) will count the Null values as well

Both COUNTD([Product ID]) and COUNT([Product ID]) will count the Null values as well

Q29. What this calculation will return if the order date is 6/13/2021 and the ship date is 9/19/2021?

Select 1 option(s):

DATEDIFF(‘month‘,[Order Date],[Ship Date])

Q30. In a scatter plot, we are showing the quantity sold and the profit by Region. Which of the following would help us to determine the relationship between the quantity sold and profit?

Select 1 option(s):

Reference Line

Trend Line

Average Line

Forecast

Q31. You want to divide your products into two parts, one that costs more than $500 and the other that costs less than $500. Which feature of Tableau can help you to achieve it?

Select 1 option(s):

Sets

Parameter

Hierarchies

Context filter

Q32. How you can assign geographic roles to a dimension?

Select 1 option(s):

In a data pane, right-click the dimension -> Geographic Role -> assign the geographic role from the list

In a view, right-click the dimension -> Geographic Role -> assign the geographic role from the list

Go to the Format menu -> Dimensions -> Select the Dimension -> Geographic Role -> assign the geographic role from the list

All of the above

Q33. What is the output of the following function? SPLIT(‘Tableau Specialist‘ , ‘ ‘, 2)

Select 1 option(s):

Tableau

Specialist

None of the above

Q34. A tableau story can contain both worksheets and dashboards.

Select 1 option(s):

TRUE

FALSE

Q35. We want to compare the sales data by category in two charts in a dashboard. The chart contains the data from Superstore and local stores. Both of these worksheets (superstore and local store) contain the Category Filter so in the dashboard we are getting two Category filters that are working independently. We want if we interact with one filter both the charts should be updated. How we can achieve it?

Select 1 option(s):

The Category filter is set as a Context filter

The Category filter must be applied to all the worksheets

The Category filter must be applied to these two worksheets

Use as filter must be selected on both the charts

Q36. Size of the following mark types cannot be adjusted?

Select 2 option(s):

Area

Square

Polygon

Text

Q37. Can we use the same dashboard in more than one story point in the same Tableau story?

Select 1 option(s):

TRUE

FALSE

Q38. Which two interactive elements can you add to a dashboard?

Select 2 option(s):

URL actions

Filter actions

Add tooltip options

Animations

Q39. In a dashboard, you can use _______ actions to create an email or link to additional information about your data.

Select 1 option(s):

filter

URL

navigate

highlight

Q40. The data sources need a common ______________ if we want to blend data from the multiple data sources.

Select 1 option(s):

Measure

Dimension

Name

None of the above

Q41. Which of the following will remove a legend from the worksheet?

Select 1 option(s):

Click the arrow on the legend and select ‘Hide card‘

Click the x on the legends card to remove it from the worksheet

Click the arrow on the legend and select ‘Remove Legend‘

Drag and drop the legend to the Data pane

Q42. Relative date filters can also be relative to a specific anchor date rather than today.

Select 1 option(s):

TRUE

FALSE

Q43. Use __________ to compare categorical data using color.

Select 1 option(s):

cross tables

highlight tables

density map

scatter plot

Q44. You created a group by using field labels in a view. You need to remove several members from a group. What should you do?

Select 1 option(s):

From the view, right-click the group members and select Exclude

From the Data pane, right-click the group and select Edit Group.

From the view, right-click the group members and select Format.

From the color legend, right-click the group members and select Format legends.

Q45. What is the output of the following function? MAX (“QlikView“,“Tableau“)

Select 1 option(s):

Error, as you cannot use the MAX function with String

QlikView

Tableau

Null

Q46. You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?

Select 1 option(s):

Using Union

Using Blend

Using Join Calculations

Using cross-database join

Q47. We have a view that shows profit recorded for each sub-category. We want to use the color gradient on a profit field in a way that all negative values are shown in one color and all positive values are shown in another color. As a Tableau specialist, how you would adjust the colors so that your final view will look like this?

Select 1 option(s):

Click on Color marks card, Edit colors, check stepped color with 2 steps

Click on Color marks card, select 2 color palette, check reversed color with 2 steps

Click on Color marks card, Edit colors, Use full color range with 2 steps

Click on Color marks card, select opacity as 50%

Q48. Using the below dataset:

You need to create the following piechart. How should you configure the marks for the pie chart?

Select 1 option(s):

Drag Sales to Color, Region to Label, and Region to Angle.

Drag Region to Color, Region to Label, and Sales to Angle.

Drag Region to Size, Region to Label, and Sales to Detail.

Drag Sales to Color, Sales to Label, and Region to Detail.

Q49. To explore the relationship between two measures in the dataset, which chart is best to use?

Select 1 option(s):

Bar Chart

Line Chart

Scatter plot

Area Chart

Q50. Which of the following are table calculations? (Select all that apply)

Select 3 option(s):

Moving Calculation

Std. Deviation

Percentile

Rank

Q51. Which of the following chart types best determine the distribution of medals among various age groups in a competition?

Select 1 option(s):

Scatter plot

Treemap

Histogram

Pie chart

Q52. Which is the best chart to show the profit recorded over time?

Select 1 option(s):

Scatter plot

Line Chart

Bullet graphs

Histogram

Q53. What is the default filter format when you add a filter from the discrete measure?

Select 1 option(s):

Range of Values

Multiple Values list

Single Value slider

Single Value list

Q54. When it is recommended to create multiple table extracts?

Select 1 option(s):

If incremental refresh is configured

If we are using extract filters to limit the data

If row-level security needs to be enforced

None of the above

Q55. Which of the following is true?

Select 1 option(s):

The discrete field creates the color gradient whereas the Continuous field creates the color palette

The continuous field creates the color gradient whereas the Discrete field creates the color palette

Discrete and Continuous fields both creates the color palette

Discrete and Continuous fields both creates the color gradient

Q56. Bar chart is most appropriate to use when?

Select 1 option(s):

View trends in data over time

Show the relationship between two measures

Compare data across categories

Show duration over time

Q57. What is the selected mark type to create the highlight table?

Select 1 option(s):

Circle

Square

Text

Shape

Q58. What is the default join type when you blend two data sources?

Select 1 option(s):

Inner join

Outer join

Left outer join

Right join

Q59. You can ___________ your data to combine two or more tables by appending rows from one table to another.

Select 1 option(s):

Blend

Union

Inner Join

Left Join

Q60. The paper clip icon associated with the field denotes?

Select 1 option(s):

Sets

Hierarchies

Groups

Calculated fields

[/ppwp]

Tableau Desktop Specialist Test - 7

Q1. Which of the following is not a Trend Line model?

Q2. In which case you will merge the mismatched fields? Select the most appropriate one.

Q3. Which feature of the Tableau can be useful when you want to show more relevant or descriptive dimension values in your view than what the original data provides?

Q4. Which of the following is not a default property that can be set for a dimension?

Q5. If you have the Date field (year and quarter) in the columns shelf and total profit in the Text marks card. You apply the difference table calculation with default configurations. What is the very first quarter value you will get?

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

Q7. You want to show the average profit on the reference line, but the profit field is not available. How you will do without making any changes in visualization?

Q8. Which scope and direction you will use to compute the Percent of total Table calculation that sums up to 100% at the end of each column in crosstab?

Q9. How the tds file can be created?

Q10. When using a Blend, the primary and secondary data sources have tick marks and they are represented using which color?

Q11. When working with Excel, text file data, JSON file, .pdf file data, you can also use _____________ to union files across folders, and worksheets across workbooks.

Q12. Which of the following are true for relationships in Tableau?

Q13. What are the Animation styles in Tableau? (Select all that apply)

Q14. Which of the following is reasons to build a dashboard? (Select all that apply)

Q15. In Tableau, how to convert the number to currency?

Q17. Which of these are Tableau-generated fields? (Select all that apply)

Q18. Groups can be used in a calculated field.

Q19. We have a graph that shows the profit recorded for each region. Now we want to change it to a Combined Axis chart by dropping sales to the Y-axis (Profit). Now, what will be the field(s) added to the Columns and Rows shelves?

Q20. You need to create a filled map using the City field, you drop the City field to your view. And you get the error 353 unknown, what does it mean, and how you will fix this issue?

Q21. You want to open http://www.google.com in one of the containers in your dashboard. How you can achieve it?

Q22. You have created a scatter plot that shows the relationship between Sales and Profit for each sub-category. Now you want to add another continuous measure ‘Quantity‘. On which marks card, you will drop the ‘Quantity‘? Select the most appropriate one.

Q23. What will happen when you drag and drop a continuous field to the columns shelf in your newly created worksheet?

Q24. In Trend lines, which statistical measure defines how well the trend fits the data?

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

Q26. Which of the following fields will not be aggregated when you add it into the view?

Q27. Tableau computes Attribute using the following formula:

Q28. In your dataset, you have a column ‘Product ID‘ that contains all unique values but few Null values as well. You need to count the number of products. Which of the scenario is true?

Q29. What this calculation will return if the order date is 6/13/2021 and the ship date is 9/19/2021?

Q30. In a scatter plot, we are showing the quantity sold and the profit by Region. Which of the following would help us to determine the relationship between the quantity sold and profit?

Q31. You want to divide your products into two parts, one that costs more than $500 and the other that costs less than $500. Which feature of Tableau can help you to achieve it?

Q32. How you can assign geographic roles to a dimension?

Q33. What is the output of the following function? SPLIT(‘Tableau Specialist‘ , ‘ ‘, 2)

Q34. A tableau story can contain both worksheets and dashboards.

<img decoding="async" class="" src="https://skillcertpro.com/wp-content/uploads/2022/i/04/word-image-214.jpeg" width="524" height="664" data-pagespeed-url-hash="2241387612" />Select 1 option(s):

Q36. Size of the following mark types cannot be adjusted?

Q37. Can we use the same dashboard in more than one story point in the same Tableau story?

Q38. Which two interactive elements can you add to a dashboard?

Q39. In a dashboard, you can use _______ actions to create an email or link to additional information about your data.

Q40. The data sources need a common ______________ if we want to blend data from the multiple data sources.

Q41. Which of the following will remove a legend from the worksheet?

Q42. Relative date filters can also be relative to a specific anchor date rather than today.

Q43. Use __________ to compare categorical data using color.

Q44. You created a group by using field labels in a view. You need to remove several members from a group. What should you do?

Q45. What is the output of the following function? MAX (“QlikView“,“Tableau“)

Q46. You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?

Q48. Using the below dataset:

Q49. To explore the relationship between two measures in the dataset, which chart is best to use?

Q50. Which of the following are table calculations? (Select all that apply)

Q51. Which of the following chart types best determine the distribution of medals among various age groups in a competition?

Q52. Which is the best chart to show the profit recorded over time?

Q53. What is the default filter format when you add a filter from the discrete measure?

Q54. When it is recommended to create multiple table extracts?

Q55. Which of the following is true?

Q56. Bar chart is most appropriate to use when?

Q57. What is the selected mark type to create the highlight table?

Q58. What is the default join type when you blend two data sources?

Q59. You can ___________ your data to combine two or more tables by appending rows from one table to another.

Q60. The paper clip icon associated with the field denotes?

Select 1 option(s):