100% Pass Guaranteed Free Desktop-Specialist Exam Dumps Aug 04, 2023
Verified & Latest Desktop-Specialist Dump Q&As with Correct Answers
Tableau Desktop Specialist Certification Exam is a comprehensive exam that covers a wide range of topics related to Tableau Desktop. Desktop-Specialist exam is designed to provide candidates with a thorough understanding of Tableau Desktop's functionality, including data preparation, visualization creation, and dashboard building. Candidates who pass the exam will have the skills and knowledge necessary to use Tableau Desktop effectively in their professional roles.
NEW QUESTION # 35
Which of the following can you use to create a Histogram?
- A. 1 measure
- B. 1 dimension
- C. 2 measures
- D. 2 dimensions
Answer: A
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 # 36
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. $33,768
- B. $16,581
- C. $48,115
- D. $147,950
- E. (Correct)
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 # 37
True or False: It is possible to change the Geographic Role of a dimension
- A. True
- B. False
Answer: A
Explanation:
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
NEW QUESTION # 38
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Drag the measure to the Text label in the Marks Card
- B. Click on Data in the Menu bar and Choose Show Mark Labels
- C. Click on the Show mark labels icon in the Toolbar
- D. Click on Analysis in the Menu bar and choose Show Mark Labels
Answer: A,C,D
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION # 39
How can you add color to marks in the view in Tableau?
- A. From the Analytics pane, drag a model to Color on the Marks card.
- B. Click on Data in the main menu above, and click on choose color.
- C. In the column/row shelf, right click the field and click on edit in shelf to select the color.
- D. From the Data pane, drag a field to Color on the Marks card.
Answer: D
Explanation:
Explanation
To assign a color to marks in the view, do the following:
From the Data pane, drag a field to Color on the Marks card.
Tableau applies different colors to marks based on the field's values and members. For example, if you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is assigned a color.
If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.
NEW QUESTION # 40
Which of the following are benefits of using Data Extracts in Tableau?
- A. Improved Performance
- B. Working with freshest data at all times
- C. Ability to use the data offline
- D. Faster to work with
Answer: A,C,D
Explanation:
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!
NEW QUESTION # 41
What does the following icon do in Tableau?
Larger image
- A. Create a Dashboard
- B. Create a Story and Dashboard both
- C. Create a Story
- D. Create a Worksheet
Answer: A
Explanation:
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION # 42
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 # 43
A Tableau Support case can be opened in which of the following valid ways?
- A. Using the Developer Community Forum
- B. Using the support option on the Tableau website
- C. Using the Tableau learn website
- D. Contacting Salesforce using their website
Answer: B
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION # 44
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. 68.77
- B. 65.67
- C. 76.25
- D. 4.87
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 # 45
A field that shows average home values for the United States in 2016 is most likely :
- A. An aggregated measure
- B. A discrete date part dimension
- C. A geographical dimension
- D. A continuous date value dimension
Answer: A
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 # 46
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Tamara Chand
- B. Sanjit Engle
- C. Tom Ashbrook
- D. Penelope Sewall
Answer: D
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION # 47
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?
- A. 52,678 and 311,404
- B. 4,888 and 17,817
- C. 1,807 and 34,571
- D. 5,129 and 88,872
Answer: B
Explanation:
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
NEW QUESTION # 48
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. True
- B. False
Answer: A
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 # 49
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Multiple Values (dropdown)
- B. Wildcard Match
- C. Regex Match
- D. Single Value (slider)
Answer: C
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION # 50
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 # 51
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([Population]/[GDP]])
- C. SUM([GDP]*[POPULATION])
- 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 # 52
Which of the following chart type makes use of 'binned' data?
- A. Bullet chart
- B. Gantt Chart
- C. Treemaps
- D. Histogram
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.
NEW QUESTION # 53
To use a quick table calculation, which of the following programming languages do you need to know?
- A. Java
- B. ython
- C. None of these
- D. Javascript
Answer: C
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 # 54
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. True
- B. False
Answer: A
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 # 55
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Orange
- B. Orange, Blue
- C. Blue, Red
- D. Red, Blue
Answer: A
Explanation:
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:
NEW QUESTION # 56
How can you change the Default Aggregation for a measure in Tableau?
- A. By double clicking on the measure, and then choosing Window -> Default Aggregation
- B. By changing its properties manually every time we need to use it
- C. By right clicking the measure -> Default properties and choosing Aggregation
- D. By right clicking the dimension -> Default properties and choosing Aggregation
Answer: A
Explanation:
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!
NEW QUESTION # 57
......
The Tableau Desktop-Specialist exam is designed for individuals who have a basic understanding of data analytics and visualization concepts and are familiar with the Tableau Desktop interface. Desktop-Specialist exam comprises of 36 multiple-choice questions that are to be completed within 120 minutes. The questions are designed to test an individual's knowledge of Tableau Desktop features and functionalities, including data connections, calculations, filters, and visualization types.
Latest Desktop-Specialist dumps - Instant Download PDF: https://www.braindumpspass.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Updated Verified Desktop-Specialist Downloadable Printable Exam Dumps: https://drive.google.com/open?id=17_0AWbOmu8bPximfHO3UYST2345H7YVo
