Pass Tableau Desktop Specialist Desktop-Specialist exam [Feb 24, 2024] Updated 150 Questions

Tableau Desktop-Specialist Actual Questions and 100% Cover Real Exam Questions

The Tableau Desktop Specialist Exam certification exam consists of 36 multiple-choice questions and has a duration of 120 minutes. It is a computer-based exam that can be taken online or at a test center. Desktop-Specialist exam tests your knowledge of Tableau Desktop and its applications, including data preparation, data connection, data blending, calculations, mapping, and dashboard creation. Desktop-Specialist exam also tests your ability to interpret and analyze data to make informed business decisions.

To take the exam, individuals must have a good understanding of Tableau Desktop and its features. They should be familiar with the different data sources that Tableau Desktop supports and should be able to connect to and prepare data for analysis. They should also be able to create visualizations and dashboards that effectively communicate insights and trends in the data.

 

NEW QUESTION # 12
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

• A. Extract Filter
• B. Context Filter
• C. None of the these
• D. Data source Filter

Answer: B

Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

NEW QUESTION # 13
Which of the following is a good reason for using a bullet graph?

• A. Analysing the trend over a given time period
• B. Displaying the year-on-year growth in sales
• C. Forecasting future sales
• D. Comparing the actual sales against the target sales

Answer: D

Explanation:
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.

NEW QUESTION # 14
When is an axis created for the visualisation in Tableau?

• A. When we drag a measure to the row/column shelf
• B. When we drag a discrete field to the row/column shelf
• C. When we drag a continuous field to the row/column shelf
• D. When we drag a dimension to the row/column shelf

Answer: C

Explanation:
Explanation
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).

NEW QUESTION # 15
Which of the following charts types always includes bars sorted in descending order?

• A. Stacked Bar Chart
• B. Gantt Chart
• C. Pareto Chart
• D. Pie Chart

Answer: C

Explanation:
Explanation
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.

NEW QUESTION # 16
For a relative date filter, the default anchor is _________________

• A. Today's date
• B. The target date
• C. The date we specify
• D. The current time

Answer: B

Explanation:
Explanation
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

NEW QUESTION # 17
Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

• A. 416,702
• B. 336,908
• C. 592,593
• D. 293,202

Answer: A

Explanation:
Explanation
Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:

NEW QUESTION # 18
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

• A. top right, bottom left
• B. top left bottom left
• C. top left, bottom right
• D. top right, bottom right

Answer: A

Explanation:
Explanation
Tree maps size begins from maximum in top left to smallest in bottom right.

See below to learn how to create a TreeMap and add colours to it:

NEW QUESTION # 19
Which of the following returns the Absolute Value of a given number?

• A. ABS(Number)
• B. FLOOR(Number)
• C. CEILING(Number)
• D. ZN(Number)

Answer: A

Explanation:
Explanation
From the official Tableau website:

NEW QUESTION # 20
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

• A. Tableau Desktop
• B. Tableau Server
• C. Tableau Online
• D. Tableau Reader

Answer: D

Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :

NEW QUESTION # 21
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

• A. 112,256
• B. 111,060
• C. 1,461
• D. 1,222

Answer: A

Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!


* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

NEW QUESTION # 22
True or False: The Highlighting action can be disabled for the entire workbook.

• A. True
• B. False

Answer: A

Explanation:
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

NEW QUESTION # 23
Is it possible to make a Measure discrete?

• A. Yes
• B. No

Answer: A

Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:

Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

NEW QUESTION # 24
Larger image

What is this entire view referred to as in Tableau?

• A. Summary Pane
• B. Distribution Pane
• C. Analytics Pane
• D. Data pane

Answer: C

Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:

NEW QUESTION # 25
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

• A. Local Field, Global Field
• B. Remote Field Name, Field Name
• C. Column Name, Actual Name
• D. Local Name, Actual Name

Answer: B

Explanation:
Explanation
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.

NEW QUESTION # 26
True or False: To concatenate fields, they must be of same data type

• A. True
• B. False

Answer: A

Explanation:
Explanation
Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use
- Type casting. See below:

Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!

NEW QUESTION # 27
Is SUM a table calculation?

• A. No
• B. Yes

Answer: A

Explanation:
Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile


These can be calculated using : Table(across), Cell, or Specific dimensions!

NEW QUESTION # 28
The icon associated with the field that has been grouped is a ______________

• A. Intersection
• B. =#
• C. Globe
• D. Paper Clip

Answer: D

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

NEW QUESTION # 29
For Bullet Graphs we need at least ____________ measures

• A. 0
• B. 1
• C. 2
• D. 3

Answer: A

Explanation:
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.
Therefore, we need at least 2 measures for creating bullet graphs.

NEW QUESTION # 30
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?

• A. 0.739284
• B. 0.783262
• C. 0.748472
• D. 0.759329

Answer: B

Explanation:
Explanation
Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:

c
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):

3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:


4) The following is our view. Hover over the trend line to see the R-squared value:

NEW QUESTION # 31
......

Tableau Desktop-Specialist exam is divided into two parts: a knowledge-based section and a skills-based section. The knowledge-based section covers topics such as data connections, data blending, calculations, and basic visualization design principles. The skills-based section requires candidates to complete a series of tasks that demonstrate their ability to use Tableau Desktop to create actionable insights from data.

 

Tableau Desktop-Specialist Real 2024 Braindumps Mock Exam Dumps: https://www.testsimulate.com/Desktop-Specialist-study-materials.html