2022 Updated Verified Pass Desktop-Specialist Exam – Real Questions & Answers [Q72-Q96]

Posted On June 4, 2022

2022 Updated Verified Pass Desktop-Specialist Exam – Real Questions and Answers

Dumps Moneyack Guarantee – Desktop-Specialist Dumps Approved Dumps

How much Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Cost

The cost of the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is $150. For more information related to exam prices, please visit the official website Tableau Website as the cost of exams may be subjected to vary county-wise.

NO.72 When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Red, Blue

Orange, Blue

Blue, Red

Blue, Orange

Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:

NO.73 A field that shows average home values for the United States in 2016 is most likely :

A discrete date part dimension

A continuous date value dimension

A geographical dimension

An aggregated measure

Explanation
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we’re working with MEASURES.
Date part and Date values don’t really make much sense given the question, and neither does geography.
Therefore, the answer naturally is “An aggregated measure”.

NO.74 For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Random

Manual

Topological

Hierarchical

Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:

NO.75 True or False: The Highlighting action can be disabled for the entire workbook.

True

False

Explanation
Yes, it is possible to disable highlighting for the entire workbook.

For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

NO.76 Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

5,129 and 88,872

52,678 and 311,404

1,807 and 34,571

4,888 and 17,817

Explanation
To reach the correct answer, follow these steps:
1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS
The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that’s your choice:

THEREFORE,
2012 = 4,888
2011 -> 2014 = 17,817

NO.77 Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

Explanation
Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

NO.78 What is a story point in Tableau?

A single worksheet or dashboard

A collection of dashboards

A collection of both worksheets and dashboards

A collection of worksheets

Explanation
In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.

NO.79 Which of the following is a good reason for using a bullet graph?

Comparing the actual sales against the target sales

Analysing the trend over a given time period

Forecasting future sales

Displaying the year-on-year growth in sales

Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

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

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

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.

Explanation
You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

NO.81 True or False: Trend lines can only be used with numeric or date fields

True

False

Explanation
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

NO.82 A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.

.twbx file

.tbm file

.twb file

.tde file

Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more information, see Packaged Workbooks.

NO.83 The icon associated with the field that has been grouped is a ______________

Paper Clip

Globe

Intersection

Explanation
You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

NO.84 Which of the following are benefits of using Data Extracts in Tableau?

Improved Performance

Ability to use the data offline

Working with freshest data at all times

Faster to work with

Explanation
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you’re working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that’s not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!

NO.85 Which Sub-Category had the least Profit in the Office Supplies category?

Fasteners

Labels

Envelopes

Binders

Explanation
To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the ‘Show mark labels icon’

As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

NO.86 True or False: Context Filters are executed after Data Source filters

True

False

Explanation
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau’s Order of Operations. See below and remember this always:

NO.87 We can join a maximum of ______ tables in Tableau

128

Explanation
It is possible to join a maximum of 32 tables in Tableau!

NO.88 Which of the following is not a Trend Line Model?

Linear Trend Line

Exponential Trend Line

binomial Trend Line

Logarithmic Trend Line

Explanation
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:

For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm

NO.89 Data blending simulates a traditional _________________ Join

Inner

Right

Full Outer

Left

Explanation
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:

NO.90 The calculation [Ship Date] – [Order Date] will return _______________

Number of orders placed in that duration

Number of days between these dates

Number of unique orders placed between these dates

Number of orders shipped between these dates

Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

NO.91 How can you change the Default Aggregation for a measure in Tableau?

By changing its properties manually every time we need to use it

By right clicking the dimension -> Default properties and choosing Aggregation

By right clicking the measure -> Default properties and choosing Aggregation

By double clicking on the measure, and then choosing Window -> Default Aggregation

Explanation
According to the official Tableau documentation:

Dimensions don’t have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn’t have any default aggregation option!

NO.92 What will the following function return?
LEFT(“Tableau”, 3)

An error

Tab

eau

ble

Explanation
The following is the official documentation for the String function LEFT:

NO.93 Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

584

901

Correct)

205

660

Explanation
Follow along the steps below:
* Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:

NO.94 True or False: A reference line cannot be added from the Analytics Pane

True

False

Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:

NO.95 Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

96.46%

95.12%

97.12%

99.46%

Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :

NO.96 What is the one most important thing you should do after creating a Dual-axis chart?

Synchronise the axis

Change the colours

Edit the labels

Hide the axis

Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.