Desktop-Specialist Tableau Desktop Specialist Exam Free Practice Exam Questions (2025 Updated)

You should change the mark type of the view to configure the visualization as a density map. A density map is a type of mark that shows how data points are distributed in a two-dimensional space. To change the mark type, you can use the Marks card or Show Me. Changing the mark shape, creating a custom color palette, or selecting heat maps from Show Me will not create a density map2

When dealing with a union of two tables in Tableau, using logical tables with a single table extract is the most appropriate approach. Logical tables allow for the integration of data from multiple tables in a way that is seamless and efficient for analysis. By using a single table extract, Tableau consolidates the data from the union into one extract, optimizing performance and enabling faster data processing. This approach is particularly beneficial when working with large datasets or complex unions.

By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

The type of aggregation applied varies depending on the context of the view.

You should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. A relationship is a way of combining data from different tables based on common fields without creating a single table with all fields. A relationship allows you to query data from multiple tables as needed and preserve the level of detail of each table. A relationship is useful when you have data sets that are aggregated at different levels of detail, such as sales by region and sales by product. A relationship can match data from different levels of detail without creating null values or duplicate rows. The other options are not valid situations for using a relationship instead of a join for two data sets. The data sets include similar data aggregated up to the highest level is not correct, because a relationship is not needed when both data sets have the same level of detail. You can use either a relationship or a join in this case, depending on your preference and performance. The data sets are in two separate tables within a single spreadsheet is not correct, because a relationship is not limited by the location or format of the data sets. You can use a relationship to combine data from different sources or connections, such as databases, files, or web services. To use both data sets across multiple sheets in a visualization is not correct, because a relationship does not affect how you use data in your visualization. You can use either a relationship or a join to create multiple sheets and dashboards with your data sets.

According to the official Tableau documentation:

Graphical user interface, text, application Description automatically generated

From the official Tableau documentation:

As we can see below, Bar charts can be used as a floating object.

1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT) - this will modify only the selected axis (row or column)

2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT) - this modifies both rows and columns at the same time

3) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option (CORRECT) -  this will modify only the selected axis (row or column)

4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT) - no such option exists

Scaled is NOT a valid size options when creating Dashboards in Tableau!

After you create a dashboard, you might need to resize and reorganize it to work better for your users.

Explanation

Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source. They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.

Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/

Using the Sample superstore as a reference, click on the manage metadata icon as follows:

We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source. The remote field name let's us see what the name of the column is in the ORIGINAL Data source.

You can change the scope of a reference line by choosing one of the following options: Per Pane, Entire Table, or Per Cell. The scope determines how many reference lines are added to the view and how they are calculated. Per Pane adds one reference line for each pane in the view. Entire Table adds one reference line for the entire table in the view. Per Cell adds one reference line for each cell in the view

In the context of Tableau, "Migrated Data" typically refers to data or workbooks that have been upgraded from a previous version of Tableau Desktop. When you open a workbook in a newer version of Tableau, the data sources within that workbook might be labeled as "Migrated Data," indicating that they have undergone a conversion process to be compatible with the new version's features and architecture.

Two use cases for creating hierarchies from the Data pane are to add drilldown functionality for fields and to organize related fields together. A hierarchy is a way of organizing data into different levels of detail. For example, a date hierarchy can have year, quarter, month, and day levels. A geographic hierarchy can have country, state, city, and zip code levels. By creating hierarchies from the Data pane, you can quickly drill down or up in a hierarchy to add or subtract more levels of detail in the view. You can also use hierarchies to group related fields together in the Data pane, making it easier to find and use them14 The other options are not valid use cases for creating hierarchies from the Data pane. To concatenate all fields into a single field, you need to use a calculated field or a join, not a hierarchy. To create faster-performing queries, you need to optimize your data source, filters, calculations, or extracts, not create hierarchies

An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.

Example:

In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

Explanation

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

Further,

Explanation

According to Tableau's official documentation -

According to the Tableau Help, a highlight table is “a cross-tabulation that uses color to encode values”. The help also states that “Highlight tables use the Square mark type” (page 1).

When the Physical Tables option is selected for an extract in Tableau, an individual table is created for each physical table in the extract. This means that the extract will include a separate table for each underlying table in your database, maintaining the database's structure within the extract. This can be useful when you need to preserve the original granularity of the data or when working with certain database optimizations.

Explanation

Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.