Valid Desktop-Specialist Exam Dumps Ensure you a HIGH SCORE (2023)
Pass Desktop-Specialist Exam with Latest Questions
NEW QUESTION # 47
Which of the following is NOT a new feature introduced in Tableau 2020.1?
- A. Viz Animations
- B. Dynamic Paramaters
- C. Set Control
- D. Buffer Calculations
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 # 48
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Mixed
- B. Discrete
- C. Fading
- D. Continuous
Answer: A
Explanation:
Explanation
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version:
For more information about color palettes, see Color Palettes and Effects.
NEW QUESTION # 49
Which of the following can you add a reference line to?
- A. Dimensions
- B. Measures
- C. Calculated Fields
- D. Groups
Answer: B,C
Explanation:
Explanation
You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.
Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.
NEW QUESTION # 50
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on the Show mark labels icon in the Toolbar
- B. Click on Data in the Menu bar and Choose Show Mark Labels
- C. Click on Analysis in the Menu bar and choose Show Mark Labels
- D. Drag the measure to the Text label in the Marks Card
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 # 51
What is a story point in Tableau?
- A. A collection of both worksheets and dashboards
- B. A collection of dashboards
- C. A single worksheet or dashboard
- D. A collection of worksheets
Answer: C
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 # 52
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Desktop
- B. Tableau Reader
- C. Tableau Online
- D. Tableau Server
Answer: B
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION # 53
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Union
- B. Sets
- C. Clustering
- D. Grouping
Answer: C
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 # 54
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 # 55
Which of the following are valid ways of Grouping Data?
- A. From the Dimensions Shelf
- B. Using Labels in the View
- C. Using Marks in the view
- 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 # 56
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Manual
- B. Topological
- C. Hierarchical
- D. Random
Answer: A
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 # 57
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?
- A. 0.748472
- B. 0.739284
- C. 0.783262
- D. 0.759329
Answer: C
Explanation:
Explanation
Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:
c
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):
3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:
4) The following is our view. Hover over the trend line to see the R-squared value:
NEW QUESTION # 58
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Profit / Sales
- B. Sales / Profit
- C. SUM(Profit) / SUM(Sales)
- D. SUM(Sales)/SUM(Profit)
Answer: C
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 # 59
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 2 , 2
- B. 1 , 2
- C. 1 , 4
- D. 2 , 3
Answer: C
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 # 60
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Orange
- B. Blue, Red
- C. Red, Blue
- D. Orange, 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 # 61
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Computer -> C: -> Tableau -> Shapes
- B. In Downloads -> My Tableau Repository -> Shapes
- C. In My Documents -> My Tableau Repository -> Shapes
- D. In Program Files -> Tableau -> Shapes
Answer: C
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 # 62
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. MS Access Database
- C. PDF File
- D. CSV file
Answer: B
Explanation:
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
NEW QUESTION # 63
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 # 64
What term is used to describe the following picture?
- A. Parameter
- B. Set
- C. Hierarchy
- D. Group
- E. Larger image
Answer: B
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 # 65
......
Tableau Desktop-Specialist Certification Exam covers a wide range of topics that include connecting to and preparing data, creating charts and graphs, and analyzing data using Tableau Desktop. Desktop-Specialist exam also evaluates an individual's knowledge of advanced features such as organizing data, creating calculated fields, and using data blending. Tableau Desktop Specialist Exam certification exam is designed to test an individual's ability to work with different data sources, including spreadsheets, databases, and cloud-based systems. Desktop-Specialist exam also evaluates an individual's ability to create interactive dashboards and reports that can be shared with others. With the Tableau Desktop-Specialist Certification, individuals can showcase their expertise in Tableau Desktop and gain an edge in today's competitive job market.
Desktop-Specialist Exam Practice Questions prepared by Tableau Professionals: https://www.examcollectionpass.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Use Valid New Desktop-Specialist Questions - Top choice Help You Gain Success: https://drive.google.com/open?id=1OqfTmVhTb2-gTgPwaosNLJExtb58QLIo