150 Exam Questions for Desktop-Specialist Updated Versions With Test Engine
Pass Desktop-Specialist Exam with Updated Desktop-Specialist Exam Dumps PDF 2021
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certified Professional salary
The estimated average salary of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is listed below: Country wise:
- United States: 114000 USD
- India: 8580000 INR
- Europe: 97000 EURO
- England: 87200 POUND
NEW QUESTION 83
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Discrete value, Continuous Value
- B. Longitude, Latitude
- C. Geographic Value, Discrete Value
- D. Continuous Value, Discrete Value
Answer: A
Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:
NEW QUESTION 84
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Values are always aggregated at the level of the Date Part
- C. Tableau doesn't aggregate values, we do!
- D. Values are always aggregated at the level of granularity of the worksheet.
Answer: D
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 85
DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
- A. Canada
- B. United Kingdom
- C. France
- D. United States
Answer: C
Explanation:
Explanation
Follow along to get the correct answer:
* Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)
2.2 Converting to discrete first & then using it
and then :
3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013
NEW QUESTION 86
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Single Value (slider)
- B. Regex Match
- C. Multiple Values (dropdown)
- D. Wildcard Match
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 87
What does the box in a box plot represent?
- A. Maximum value of the data
- B. The interquartile range
- C. The median of the middle half of the data points
- D. Minimum value of the data
Answer: B
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 88
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Hierarchical
- B. Manual
- C. Random
- D. Topological
Answer: B
Explanation:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
NEW QUESTION 89
What is a story point in Tableau?
- A. A collection of dashboards
- B. A collection of both worksheets and dashboards
- C. A collection of worksheets
- D. A single worksheet or dashboard
Answer: D
Explanation:
Explanation
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.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.
NEW QUESTION 90
How do you identify a continuous field in Tableau?
- A. It is preceded by a '=#' symbol in the data window
- B. It is preceded by a 'Abc' symbol in the data window
- C. It is identified by a green pill in a visualization
- D. It is identified by a blue pill in the visualization
Answer: A
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
NEW QUESTION 91
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 92
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.5s
- B. 0.4s
- C. 0.2s
- D. 0.3s
Answer: D
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 93
Which of the following is not a Trend Line Model?
- A. binomial Trend Line
- B. Logarithmic Trend Line
- C. Exponential Trend Line
- D. Linear 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 94
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 support option on the Tableau website
- D. Using the Tableau learn website
Answer: C
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION 95
______________ 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. Joining
- B. Blending
- C. Unioning
- D. Combining
Answer: C
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 96
Which one of the following is a dimension?
- A. Latitude
- B. Number of records
- C. Measure Names
- D. Longitude
Answer: C
Explanation:
Explanation
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
NEW QUESTION 97
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. Parameters
- B. Calculation
- C. Groups
- D. Sets
Answer: A
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 98
________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
- A. .tds
- B. .twb
- C. .tde
- D. .tbm
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources.
NEW QUESTION 99
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 1 , 4
- B. 1 , 2
- C. 2 , 2
- D. 2 , 3
Answer: A
Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
NEW QUESTION 100
Which of the following is a good reason for using a bullet graph?
- A. Forecasting future sales
- B. Displaying the year-on-year growth in sales
- C. Comparing the actual sales against the target sales
- D. Analysing the trend over a given time period
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 101
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. Edit the data source manually for a quick resolution
- C. Right click it -> Edit Default properties -> Assign geographic roles
- D. Right click it -> Geographic role -> and then assign the appropriate geographic role
Answer: D
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 102
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. duplicates
- B. parameters
- C. aliases
- D. copies
Answer: C
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION 103
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Measure Filter
- B. Extract Filter
- C. Context Filter
- D. Dimension Filter
Answer: B
Explanation:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
NEW QUESTION 104
For creating variable sized bins we use __________________
- A. Calculated Fields
- B. Table Calculations
- C. Groups
- D. Sets
Answer: A
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 105
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A. The calculated fields created in Blends cannot be edited once created
- B. The calculated fields created in Blends cannot use more than 2 fields
- C. No difference, calculated fields cannot be created in Blends
- D. Fields used in Blends must first be aggregated
Answer: D
Explanation:
Explanation
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:
In addition to handling calculations slightly differently, there are some limitations on secondary data sources.
You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.
NEW QUESTION 106
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the of the revenue in the same view!
NEW QUESTION 107
Which of the following is NOT a new feature introduced in Tableau 2020.1?
- A. Buffer Calculations
- B. Dynamic Paramaters
- C. Set Control
- D. Viz Animations
Answer: C
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 108
......
Desktop-Specialist Exam Dumps - Free Demo & 365 Day Updates: https://www.exam4tests.com/Desktop-Specialist-valid-braindumps.html
Free Sales Ending Soon - Use Real Desktop-Specialist PDF Questions: https://drive.google.com/open?id=1AHpdCiP3m5ubQ-nwFbA-CZGtrJwNvrH0