[2023] Pass Tableau Desktop-Specialist Exam Updated 150 Questions
Get 2023 Updated Free Tableau Desktop-Specialist Exam Questions and Answer
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certification Path
Exam Training teaches you how to interpret test questions and how long you will be absent from class.Our Readiness for Examination: Tableau Certified Solutions Architect - A training class in the class room or engaging in a physical or virtual classroom with Tableau Approved Learner is provided in different formats. Free digital training for learning whenever needed. The course reviews sample questions in each subject and how the tested subjects are to be learned and makes it possible to prevent incorrect responses. Find the best selection for you.
Experience of Tableau in computation, networking, storage and database applications Practical experience in Tableau deployment and operating systems The ability of Tableau-based software to identify and establish functional criteria. The opportunity to define which Tableau systems meet specific technical requirements. Knowledge of recommended best practices for secure and effective Tableau platform implementations. Understanding Tableau Cloud's main architectural tenets. Tableau worldwide understanding of infrastructure. An awareness of network infrastructure relevant to Tableau. Understand the safety features and services of Tableau and its links to traditional providers.
What is the duration, language, and format of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
- No negative marking for wrong answers
- Number of Questions: 65
- Type of Questions: Multiple choice (MCQs), multiple answers
How to study the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
A wide variety of Tableau Desktop-Specialist exam dumps have been recognized for qualification concerns for Tableau Certified Developer-Professional Certifications. The fact that students have to study carefully doesn't facilitate certificates. The training from Tableau Accredited Developer-Professional often takes a long time. Each test contains answers and questions that allow students to pass their final test. After taking and studying our courses, you can pass the exam. But it doesn't stop there; you can always be successful with your profession thanks to our complete guides. In the future, you will manufacture your own merchandise. We have an innovative approach to preparing some content for you. We also applied the new data to production and commodities.
NEW QUESTION 56
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Wildcard Match
- B. Regex Match
- C. Single Value (slider)
- D. Multiple Values (dropdown)
Answer: B
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION 57
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 58
Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?
- A. January 2018
- B. March 2018
- C. September 2017
- D. December 2017
Answer: A
Explanation:
Explanation
Follow the steps to get the correct answer : January 2018
* We are talking about dates, so use the Time series sheet as follows:
* Next, the following should be your view and clearly, January 2018 is the lowest point:
Read more about dates:
https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/
NEW QUESTION 59
Which of the following are valid ways to add Totals to a view?
- A. Using the Analytics Pane
- B. Using the Data Pane
- C. Using the Marks shelf
- D. From the Analysis Tab in the Menu bar on top
Answer: A,D
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION 60
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. union
- B. blend
- C. concatenate
- D. join
Answer: A
Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
A union of these tables creates the following single table that contains all rows from all tables.
NEW QUESTION 61
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 62
By default, measures placed in a view are aggregated by ______________
- A. SUM
- B. AVERAGE
- C. COUNT
- D. MEDIAN
Answer: A
Explanation:
Explanation
By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.
NEW QUESTION 63
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. 65.67
- B. 68.77
- C. 4.87
- D. 76.25
Answer: D
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 64
For creating variable sized bins we use __________________
- A. Sets
- B. Groups
- C. Calculated Fields
- D. Table Calculations
Answer: C
Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
NEW QUESTION 65
______________ refers to the level of detail for a piece of data, wherever you are looking.
- A. Data Cleanliness
- B. Data LOD
- C. Data granularity
- D. Data connectivity
Answer: C
Explanation:
Explanation
Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.
NEW QUESTION 66
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Unioning
- B. Joining
- C. Blending
- D. Combining
Answer: A
Explanation:
Explanation
Unioning is the correct answer!
From the official documentation:
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."
NEW QUESTION 67
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Sets
- B. Clustering
- C. Union
- D. Grouping
Answer: B
Explanation:
Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
NEW QUESTION 68
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.000
- B. 3.704
- C. 3.840
- D. 3.500
Answer: B
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 69
True or False: Context Filters are executed after Data Source filters
- A. False
- B. True
Answer: B
Explanation:
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:
NEW QUESTION 70
Which of the following is not a Trend Line Model?
- A. Exponential Trend Line
- B. Logarithmic Trend Line
- C. Linear Trend Line
- D. binomial Trend Line
Answer: B
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 71
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A. Edit the config file in My Documents -> MyTableauRepository for a quick fix
- B. Right click it -> Edit Default properties -> Assign geographic roles
- C. Right click it -> Geographic role -> and then assign the appropriate geographic role
- D. Edit the data source manually for a quick resolution
Answer: C
Explanation:
Explanation
From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:
NEW QUESTION 72
How does Tableau know at which level to aggregate values?
- A. Values are always aggregated at the level of the Date Part
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Aggregation is always done by using Tableau special formulas
- D. Tableau doesn't aggregate values, we do!
Answer: B
Explanation:
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:
NEW QUESTION 73
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Documents -> My Tableau Repository -> Shapes
- B. In Downloads -> My Tableau Repository -> Shapes
- C. In Program Files -> Tableau -> Shapes
- D. In My Computer -> C: -> Tableau -> Shapes
Answer: A
Explanation:
Explanation
Here's how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.
NEW QUESTION 74
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 75
True or False: The Highlighting action can be disabled for the entire workbook.
- A. False
- B. True
Answer: B
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 76
......
Verified Desktop-Specialist exam dumps Q&As with Correct 150 Questions and Answers: https://testking.itexamsimulator.com/Desktop-Specialist-brain-dumps.html
