[Nov 14, 2023] Pass Tableau Desktop Specialist Desktop-Specialist Exam With 150 Questions
Ultimate Guide to Prepare Free Tableau Desktop-Specialist Exam Questions and Answer
For more info read reference:
NEW QUESTION # 58
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A. Fast to create
- B. To support additional functionality such as count distinct
- C. To have access to the freshest possible data at all times
- D. Help improve performance
Answer: A,B,D
Explanation:
Explanation
From the official documentation, the following are the major advantages of using Tableau Data Extracts:
From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
NEW QUESTION # 59
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 # 60
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.4s
- B. 0.3s
- C. 0.2s
- D. 0.5s
Answer: B
Explanation:
Explanation
The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!
NOTE: Animations are DISABLED by default and must be manually enabled.
You can also reset all settings to default by clickin on 'Reset All'
NEW QUESTION # 61
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.
- A. 99.46%
- B. 97.12%
- C. 95.12%
- D. 96.46%
Answer: B
Explanation:
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 :
NEW QUESTION # 62
Which of the following are valid ways of Grouping Data?
- A. Using Labels in the View
- B. Using Marks in the view
- C. From the Dimensions Shelf
- D. From the Analytics Pane
Answer: A,B,C
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 # 63
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Number of Records
- C. Measure Names
- D. Calculated Fields
Answer: A,C
Explanation:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
NEW QUESTION # 64
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. False
- B. True
Answer: B
Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
NEW QUESTION # 65
Which of the following can you use to create a Histogram?
- A. 2 measures
- B. 1 dimension
- C. 2 dimensions
- D. 1 measure
Answer: D
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 # 66
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. $147,950
- B. $16,581
- C. (Correct)
- D. $48,115
- E. $33,768
Answer: B
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 # 67
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,222
- D. 1,461
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 # 68
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A. Nothing changes in the view, but a group is created in the Dimensions shelf.
- B. Trick question! It is not possible to group by labels.
- C. The colours of the members selected are now the same, and different for the rest of the members.
- D. A new mark (bar) is created, which consolidates all members of the group.
Answer: D
Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
NEW QUESTION # 69
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 5,000
- B. 15,000
- C. 10,000
- D. 20,000
Answer: C
Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
NEW QUESTION # 70
Which data type in Tableau does this icon represent?
Larger image
- A. True or False
- B. Boolean
- C. String
- D. Geographic
Answer: D
Explanation:
Explanation
The following is the table for the data types in Tableau along with their icons:
NEW QUESTION # 71
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?
- A. 3.840
- B. 3.500
- C. 3.000
- D. 3.704
Answer: D
Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.
2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:
Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)
NEW QUESTION # 72
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Analytics Pane
- C. Data 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 # 73
Dates in Tableau are typically treated as ______________
- A. Measures
- B. Dimensions
Answer: B
Explanation:
Explanation
For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:
When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.
NEW QUESTION # 74
True or False: It is possible to add a field to more than one hierarchy
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
NEW QUESTION # 75
To use a quick table calculation, which of the following programming languages do you need to know?
- A. None of these
- B. Javascript
- C. ython
- D. Java
Answer: A
Explanation:
Explanation
You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
NEW QUESTION # 76
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([GDP]*[POPULATION])
- C. SUM([Population]/[GDP]])
- D. SUM([GDP]/[POPULATION])
Answer: A
Explanation:
Explanation
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION # 77
What term is used to describe the following picture?
- A. Hierarchy
- B. Larger image
- C. Set
- D. Parameter
- E. Group
Answer: C
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 # 78
What does the box in a box plot represent?
- A. The interquartile range
- B. Maximum value of the data
- C. The median of the middle half of the data points
- D. Minimum value of the data
Answer: A
Explanation:
Explanation
In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
NEW QUESTION # 79
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A. False
- B. rue
Answer: A
Explanation:
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, 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.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
NEW QUESTION # 80
......
Tableau Desktop Specialist Certification Exam is an industry-recognized certification that demonstrates a candidate's ability to use Tableau Desktop to create compelling and effective visualizations. Tableau Desktop Specialist Exam certification is designed for individuals who are new to Tableau Desktop, as well as those who have some experience with the software. Tableau Desktop Specialist Exam certification is a valuable credential for professionals in various fields, including business intelligence, data analytics, and data science.
Tableau Desktop Specialist Exam Practice Tests 2023 | Pass Desktop-Specialist with confidence!: https://drive.google.com/open?id=1Dmh5TOaeejTfwZMMf09VVAFCpkO1CmOi
Pass Desktop-Specialist Tests Engine pdf - All Free Dumps: https://www.examtorrent.com/Desktop-Specialist-valid-vce-dumps.html
