synergisticit

The Tableau Desktop Specialist mock test acts as a door opener. It validates your Tableau fundamentals and demonstrates initiative. Yet, door openers alone don’t guarantee employment. Employers want developers who can design scalable solutions using Tableau and Power BI, query with SQL, and leverage SAS and Azure. They also expect data engineering proficiency in Snowflake, Databricks, and PySpark, plus data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI.

SynergisticIT’s Data Science JOPP program ensures your door opener leads to career success. Learn more: Data Science JOPP.

Welcome to your Tableau Desktop Specialist - Test-3

Name

Phone

Q1. You can create _____________ for members in a dimension so that their labels appear differently in the view.

Select 1 option(s):

renames

copies

aliases

duplicates

Q2. Which of the following are valid ways to copy a worksheet visualisation as an image?

Select 2 option(s):

By simply clicking Control + V on the keyboard

Using the Marks shelf and choosing Copy->Image

By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image

By right clicking on the worksheet visualisation and selecting Copy->Image

Q3. Which of the following is NOT a valid official data source in Tableau Desktop?

Select 1 option(s):

PostgreSQL

SAP HANA

Google Firebase

Amazon Redshift

Q4. What is the following icon in the Data pane used to do?

Select 1 option(s):

Extract Data

Sort Data

View Data

Clean Data

Q5. __ can only create header. _ will create header and axis both.

Select 1 option(s):

Dates, Strings

Groups, Sets

Measures, Dimensions

Dimensions, Measures

Q6. To connect Tableau to a CSV data source what type of connection should you use?

Select 1 option(s):

JSON

Text

Excel

Spatial

Q7. _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

Select 1 option(s):

Area

Line

Bullet

Gantt

Q8. Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Select 1 option(s):

Analytics Pane

Marks Card

Filter Shelf

Data Pane

Q9. How can you format numbers in Tableau as currency?

Select 1 option(s):

Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Q10. ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Select 1 option(s):

Combining

Blending

Unioning

Joining

Q11. Which of the following fields would be best used as Dimensions?

Select 2 option(s):

Names

Sales

Q12. Which of the following are valid ways to show Mark Labels in the visualisation?

Select 3 option(s):

Click on Analysis in the Menu bar and choose Show Mark Labels

Click on Data in the Menu bar and Choose Show Mark Labels

Drag the measure to the Text label in the Marks Card

Click on the Show mark labels icon in the Toolbar

Q13. True or False: We get different colour pallete options if we drop a discrete field on “Color” in the marks card compared to if we drop a continous field on Color.

Select 1 option(s):

TRUE

FALSE

Q14.

You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Select 1 option(s):

Preview the data

Clean the data

Create visualisations to analyze your data

Rename the fields and change data types

Q15. _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that dont allow relationships or joins

Select 1 option(s):

Data segregation

Data Blending

Union

Data Joining

Q16. Dragging a to colour creates distinct colours for each item whereas dragging a to colour creates a gradient

Select 1 option(s):

Discrete value, Continuous Value

Geographic Value, Discrete Value

Continuous Value, Discrete Value

Longitude, Latitude

Q17. Data blending simulates a traditional _________________ Join

Select 1 option(s):

Left

Inner

Right

Full Outer

Q18. How can you change the default Tableau repository location?

Select 1 option(s):

By clicking on File -> Repository Location and choosing a new location

By clicking on Help -> Change Repository Location

By clicking on Window -> Repository Location

By Moving the repository location manually to wherever we want

Q19. Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Select 1 option(s):

Yes

Q20. When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Select 3 option(s):

JPEG Image (.JPG, .JPEG)

Windows Bitmap (.BMP)

Portable Network Graphic (.PNG)

Tagged Image File Format (TIFF)

Q21. What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Select 1 option(s):

The calculated fields created in Blends cannot be edited once created

Fields used in Blends must first be aggregated

No difference, calculated fields cannot be created in Blends

The calculated fields created in Blends cannot use more than 2 fields

Q22. Which of these is NOT a type of Quick Filter available in Tableau?

Select 1 option(s):

Single Value (slider)

Multiple Values (dropdown)

Wildcard Match

Regex Match

Q23. By default, what does Tableau do when you connect to a data source?

Select 1 option(s):

Creates an extract of the data

Loads your actual file into Tableau

Creates a live connection to the data

Sorts the data in descending order

Q24. How can you MANUALLY assign geographic roles to a dimension from the data pane?

Select 1 option(s):

Edit the config file in My Documents -> MyTableauRepository for a quick fix

Right click it -> Geographic role -> and then assign the appropriate geographic role

Edit the data source manually for a quick resolution

Right click it -> Edit Default properties -> Assign geographic roles

Q25. When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Select 1 option(s):

Fading

Discrete

Continuous

Mixed

Q26. Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Select 1 option(s):

Yes

Q27. Which one of the following is a dimension?

Select 1 option(s):

Latitude

Longitude

Number of records

Measure Names

Q28. When field names in the Union do not match, then:

Select 1 option(s):

Both field names are present in the Union, but contain several null values

Only one field name is present in the Union with null values

Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch

An error is raised and both fields are dropped from the resulting Union

Q29. Which of the following are valid Layout Container types when using Dashboards in Tableau?

Select 2 option(s):

Vertical Container

Split Container

Horizontal Container

Diagonal Container

Q30. Is it possible to make a Measure discrete?

Select 1 option(s):

Yes

Q31. Which of the following are valid ways to italicize Tooltip content in Tableau?

Select 3 option(s):

Click on Tooltip in the Marks card, select the text, and then use the Italics option

Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option

Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option

Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font

Q32. Which of the following are true about Dashboards in Tableau?

Select 3 option(s):

None of these

Tiled items don't overlap

A bar chart can be used a floating item

Floating items can be layered over other objects

Q33. Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Select 1 option(s):

Trick question! It is not possible to group by labels.

A new mark (bar) is created, which consolidates all members of the group.

Nothing changes in the view, but a group is created in the Dimensions shelf.

The colours of the members selected are now the same, and different for the rest of the members.

Q34. Which of the following describes the best way to change the formatting at a workbook level?

Select 1 option(s):

Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.

Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.

Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.

It is only possible to specify formatting at a worksheet level, not at the workbook level.

Q35. How can you add color to marks in the view in Tableau?

Select 1 option(s):

Click on Data in the main menu above, and click on choose color.

From the Data pane, drag a field to Color on the Marks card.

In the column/row shelf, right click the field and click on edit in shelf to select the color.

From the Analytics pane, drag a model to Color on the Marks card.

Q36. Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

Select 1 option(s):

Right click on the dashboard, and choose Copy, then image.

Using the floating export worksheet option on the Dashboard

Click on Worksheet in the Menu bar followed by Export, then choose Image

Click on Dashboard in the Menu bar followed by Copy Image

Q37. Which of the following points are True about Viz Animations?

Select 3 option(s):

They can be turned on for certain worksheets only

Animations work well with maps, polygons, and density marks in web browsers

Sequential animations take more time but make complex changes clearer by presenting them step-by-step

It is possible to turn them on for the entire workbook at once

Q38. If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Select 2 option(s):

To make the context filter a dependent filter

Improve query performance

To help clean the data

To include only the data of interest

Q39. Which of the following are valid ways to Bold the Tooltip content in Tableau?

Select 3 option(s):

Click on Analysis, Tooltip options, and select bold.

Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option

Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.

Click on Tooltip in the Marks card, and select bold.

Q40. Which of the following options best describe measures?

Select 1 option(s):

They are categorical, qualitative

They are numerical, quantitative

They are numerical, qualitative

They are categorical, quantitative

Q41. Which of the following can you add a reference line to?

Select 2 option(s):

Groups

Dimensions

Measures

Calculated Fields

Q42. How can you format an axis as Bold in Tableau?

Select 1 option(s):

By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.

By choosing the axis and selecting Command/Control + B on your keyboard

By right clicking on the axis, choosing format, and then setting its font to bold.

By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.

Q43. When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Select 1 option(s):

Pattern Search

Union Search

Wildcard Search

Regex Search

Q44. In which of the following scenarios would having a live connection be more beneficial than using an extract?

Select 3 option(s):

Analyzing historical housing prices

Analyzing real time data from production systems

Analyzing a subset of a dataset having 1 billion rows

Analyzing and tracking real time flight updates

Analyzing real time stock prices

Q45. When is an axis created for the visualisation in Tableau?

Select 1 option(s):

When we drag a measure to the row/column shelf

When we drag a continuous field to the row/column shelf

When we drag a dimension to the row/column shelf

When we drag a discrete field to the row/column shelf

Q46. Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Select 1 option(s):

If we want to use filters in the visualisation.

If we want to interact with the visualisation.

If we want to dynamically enter parameters to the visualisation.

If we want a static view of the visualisation.

Q47. A union of two tables usually results in an _____________________

Select 1 option(s):

increase in the number of rows

decrease in the number of rows

decrease in the number of columns

increase in the number of columns

Q48. If you have a dashboard and are displaying its filter, how can you rearrange it?

Select 1 option(s):

By clicking on the dropdown and dragging the filter

By clicking on the filter title and dragging it.

By clicking anywhere inside the filter and dragging it.

By clicking on the 2 lines on top and dragging the filter.

Q49. What does the following marker/icon do in Tableau?

Select 1 option(s):

Format the Legends

Edit the Colors

Highlight the largest value

Toggle the highlighting on/off.

Q50. Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

Select 1 option(s):

.tds

.hyper

.tdex

.twbx

Q51. Which of the following lets you group related dashboard items together so you can quickly position them?

Select 1 option(s):

Layout Positioners

Layout Blanks

Layout Extensions

Layout Containers

Q52. If you see a Blue field, generally it will add _____________ to the view

Select 1 option(s):

axis

both

none

headers

Q53. What do the colours Blue and Green represent in Tableau?

Select 1 option(s):

Continuous and Discrete

Measures and Dimensions

Discrete and Continuous

Dimensions and Measures

Q54. Which of the following sets would you use to compare the members?

Select 1 option(s):

None of these

Dynamic Sets

Combined Sets

Static Sets

Q55. What is a story point in Tableau?

Select 1 option(s):

A single worksheet or dashboard

A collection of worksheets

A collection of both worksheets and dashboards

A collection of dashboards

Q56. A Tableau Data Source File (.tds) contains which of the following?

Select 3 option(s):

Copy of any local file-based data

Data Source Type

Default Field Properties

Calculated Fields

Q57. Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Select 3 option(s):

Fast to create

To support additional functionality such as count distinct

To have access to the freshest possible data at all times

Help improve performance

Q58. For which of the following charts, does the Size option on the Marks card not work?

Select 1 option(s):

Bar Chart

Pie Chart

Gantt Chart

Tree Map

Q59. Creating a scatter plot requires a minimum of how many measures?

Select 1 option(s):

Q60. Which of the following are valid ways to make the font more readable in Tableau?

Select 3 option(s):

Use a clear and readable font

Make the Font color sharper / darker than the background

Don't use backgrounds

Increase the font size

Decrease the font size

Q61. Are animations enabled by default in Tableau?

Select 1 option(s):

Yes

Q62. When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Select 1 option(s):

stepped

converging

diverging

reversed

Q63. Which of the following are benefits of combining sheets using dashboards?

Select 3 option(s):

It is mandatory to combine sheets when using Tableau

Easier to compare visualisations side by side

Helps in faster analysis

Provides the ability to use one sheet as a filter for other

Q64. Which of the following are true about dimensions?

Select 3 option(s):

They contain contain numeric, quantitative values

They affect the level of detail in the view

They contain qualitative values (such as names, dates, or geographical data)

Dates are mostly placed in dimensions by default for relational data sources

Q65. Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

Select 2 option(s):

Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option

Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold.

Right click on Rows or Columns, and choose format. In the Font option click on Bold.

Choose Format then Font from the Menu bar, and select Bold under the Header option

[/ppwp]

synergisticit

Q1. You can create _____________ for members in a dimension so that their labels appear differently in the view.

Q2. Which of the following are valid ways to copy a worksheet visualisation as an image?

Q3. Which of the following is NOT a valid official data source in Tableau Desktop?

Q4. What is the following icon in the Data pane used to do?

Q5. ________________ can only create header. _______________ will create header and axis both.

Q6. To connect Tableau to a CSV data source what type of connection should you use?

Q7. _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

Q8. Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Q9. How can you format numbers in Tableau as currency?

Q10. ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Q11. Which of the following fields would be best used as Dimensions?

Q12. Which of the following are valid ways to show Mark Labels in the visualisation?

Q13. True or False: We get different colour pallete options if we drop a discrete field on “Color” in the marks card compared to if we drop a continous field on Color.

Q14.

Q15. _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that dont allow relationships or joins

Q16. Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

Q17. Data blending simulates a traditional _________________ Join

Q18. How can you change the default Tableau repository location?

Q19. Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Q20. When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Q21. What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Q22. Which of these is NOT a type of Quick Filter available in Tableau?

Q23. By default, what does Tableau do when you connect to a data source?

Q24. How can you MANUALLY assign geographic roles to a dimension from the data pane?

Q25. When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Q26. Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Q27. Which one of the following is a dimension?

Q28. When field names in the Union do not match, then:

Q29. Which of the following are valid Layout Container types when using Dashboards in Tableau?

Q30. Is it possible to make a Measure discrete?

Q31. Which of the following are valid ways to italicize Tooltip content in Tableau?

Q32. Which of the following are true about Dashboards in Tableau?

Q33. Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Q34. Which of the following describes the best way to change the formatting at a workbook level?

Q35. How can you add color to marks in the view in Tableau?

Q36. Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

Q37. Which of the following points are True about Viz Animations?

Q38. If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Q39. Which of the following are valid ways to Bold the Tooltip content in Tableau?

Q40. Which of the following options best describe measures?

Q41. Which of the following can you add a reference line to?

Q42. How can you format an axis as Bold in Tableau?

Q43. When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Q44. In which of the following scenarios would having a live connection be more beneficial than using an extract?

Q45. When is an axis created for the visualisation in Tableau?

Q46. Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Q47. A union of two tables usually results in an _____________________

Q48. If you have a dashboard and are displaying its filter, how can you rearrange it?

Q49. What does the following marker/icon do in Tableau?

Q50. Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

Q51. Which of the following lets you group related dashboard items together so you can quickly position them?

Q52. If you see a Blue field, generally it will add _____________ to the view

Q53. What do the colours Blue and Green represent in Tableau?

Q54. Which of the following sets would you use to compare the members?

Q55. What is a story point in Tableau?

Q56. A Tableau Data Source File (.tds) contains which of the following?

Q57. Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Q58. For which of the following charts, does the Size option on the Marks card not work?

Q59. Creating a scatter plot requires a minimum of how many measures?

Q60. Which of the following are valid ways to make the font more readable in Tableau?

Q61. Are animations enabled by default in Tableau?

Q62. When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Q63. Which of the following are benefits of combining sheets using dashboards?

Q64. Which of the following are true about dimensions?

Q65. Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

Q5. __ can only create header. _ will create header and axis both.

Q15. _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that dont allow relationships or joins

Q16. Dragging a to colour creates distinct colours for each item whereas dragging a to colour creates a gradient