Ultimate Guide to the Desktop-Specialist - Latest Jul 09, 2023 Edition Available Now
2023 Updated Verified Pass Desktop-Specialist Exam - Real Questions and Answers
Tableau Desktop-Specialist certification exam is a valuable tool for individuals who want to demonstrate their expertise and proficiency in using Tableau Desktop software. Desktop-Specialist exam covers a wide range of topics related to Tableau Desktop, and successful candidates are recognized as certified professionals in the field of data analysis and visualization. Tableau Desktop Specialist Exam certification can lead to better job opportunities and higher salaries, making it a worthwhile investment for individuals who want to advance their careers in the field of data analysis and visualization.
NEW QUESTION # 62
Which of the following can you use to create a Histogram?
- A. 2 dimensions
- B. 1 measure
- C. 2 measures
- D. 1 dimension
Answer: B
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
The basic building blocks for a histogram are as follows:
Demo :
NEW QUESTION # 63
A field that shows average home values for the United States in 2016 is most likely :
- A. A geographical dimension
- B. A continuous date value dimension
- C. A discrete date part dimension
- D. An aggregated measure
Answer: D
Explanation:
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".
NEW QUESTION # 64
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
- A. False
- B. True
Answer: B
Explanation:
Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.
Inner join
Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.
NEW QUESTION # 65
Which of the following are valid ways of Grouping Data?
- A. From the Dimensions Shelf
- B. From the Analytics Pane
- C. Using Labels in the View
- D. Using Marks in the view
Answer: A,C,D
Explanation:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:
Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:
They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):
Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:
Finally, we can group directly from the Dimensions shelf as follows:
Now choose Phones, Chairs and Storage and Click Group:
You will now automatically have a new Dimension as follows:
NEW QUESTION # 66
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?
- A. If we want to interact with the visualisation.
- B. If we want to use filters in the visualisation.
- C. If we want a static view of the visualisation.
- D. If we want to dynamically enter parameters to the visualisation.
Answer: C
Explanation:
Explanation
Exporting the visualisation gives us a static view of the visualisation.
It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.
In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)
NEW QUESTION # 67
What term is used to describe the following picture?
- A. Hierarchy
- B. Larger image
- C. Parameter
- D. Group
- E. Set
Answer: E
Explanation:
Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
NEW QUESTION # 68
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Sales / Profit
- B. SUM(Profit) / SUM(Sales)
- C. Profit / Sales
- D. SUM(Sales)/SUM(Profit)
Answer: B
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:
NEW QUESTION # 69
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)
- A. 4.87
- B. 65.67
- C. 76.25
- D. 68.77
Answer: C
Explanation:
Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:
2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:
3) Now, let's create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
NEW QUESTION # 70
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. 592,593
- B. 336,908
- C. 293,202
- D. 416,702
Answer: D
Explanation:
Explanation
Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:
NEW QUESTION # 71
What will the following function return?
LEFT("Tableau", 3)
- A. ble
- B. Tab
- C. An error
- D. eau
Answer: C
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION # 72
If you see the following Filter, then you're working with _______________________ Larger image
- A. Date Parts
- B. Grouped Dates
- C. Date Functions
- D. Date Values
Answer: D
Explanation:
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.
NEW QUESTION # 73
Which of the following is not a Trend Line Model?
- A. Linear Trend Line
- B. binomial Trend Line
- C. Logarithmic Trend Line
- D. Exponential Trend Line
Answer: C
Explanation:
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
NEW QUESTION # 74
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
- A. Sets
- B. Groups
- C. Calculation
- D. Parameters
Answer: D
Explanation:
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -
NEW QUESTION # 75
A Tableau Support case can be opened in which of the following valid ways?
- A. Using the Developer Community Forum
- B. Contacting Salesforce using their website
- C. Using the Tableau learn website
- D. Using the support option on the Tableau website
Answer: D
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION # 76
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
This is a tricky question. We are talking about story POINTS, and not entire stories in the question.
To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.
I can simply drag the dashboard into the view to create a new story point.
Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:
The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.
Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm
NEW QUESTION # 77
Which of the following is a good reason for using a bullet graph?
- A. Analysing the trend over a given time period
- B. Forecasting future sales
- C. Comparing the actual sales against the target sales
- D. Displaying the year-on-year growth in sales
Answer: C
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 # 78
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
NEW QUESTION # 79
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION # 80
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Data Pane
- C. Analytics Pane
- D. Marks Card
Answer: D
Explanation:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!
The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.
You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.
In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.
NEW QUESTION # 81
Which data type in Tableau does this icon represent?
Larger image
- A. Geographic
- B. String
- C. Boolean
- D. True or False
Answer: A
Explanation:
Explanation
The following is the table for the data types in Tableau along with their icons:
NEW QUESTION # 82
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
- A. (Correct)
- B. $33,768
- C. $48,115
- D. $147,950
- E. $16,581
Answer: E
Explanation:
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:
2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, drag State ID to Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
NEW QUESTION # 83
Which of the following is NOT a new feature introduced in Tableau 2020.1?
- A. Dynamic Paramaters
- B. Set Control
- C. Viz Animations
- D. Buffer Calculations
Answer: B
Explanation:
Explanation
Your Tableau Desktop Specialist exam will be based on the 2020.1 version.
Set controls are a new feature introduced in the 2020.2 version, and hence is the correct answer - it is not a part of 2020.1 For the 2020.1 version the new features were:
1) Viz animations:
Viz animations help you see and understand your changing data. It's easy to track the logical steps behind data's evolution and tell powerful data stories. Sorting, filtering, adding fields, and other actions will now smoothly animate your visualizations. Choose whether to turn Viz Animations on or off, and decide how you'd best like to apply animations to your new workbooks.
2) Dynamic Parameters:
Say goodbye to republishing workbooks with parameters every time the underlying data changes. Set your parameter once, and Tableau will automatically update the parameter's list of values every time someone opens the workbook.
3) Buffer Calculations:
Buffer calculations allow you to visualize the distance around point locations. Give Tableau three parameters-location, distance, and a unit of measure-and a buffer, or boundary is instantly created.
Answering complex spatial questions becomes easier than ever before-visualize what properties are within
200 meters of a proposed transit site, or how many competitors' stores are within 1 mile of their store, and more.
NEW QUESTION # 84
How can you format numbers in Tableau as currency?
- A. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: B
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 85
......
By passing the Tableau Desktop-Specialist exam, candidates can demonstrate their proficiency in using Tableau Desktop to create compelling visualizations and insights that can help organizations make data-driven decisions. Tableau Desktop Specialist Exam certification can also enhance their credibility and career prospects in the field of data analytics and business intelligence.
Tableau Desktop-Specialist certification is ideal for individuals who want to showcase their skills in data visualization and analysis using Tableau Desktop. Tableau Desktop Specialist Exam certification can help individuals advance their career in data analytics, business intelligence, and data visualization.
Dumps Moneyack Guarantee - Desktop-Specialist Dumps Approved Dumps: https://pass4sure.exam-killer.com/Desktop-Specialist-valid-questions.html
