Valid Desktop-Specialist Exam Dumps Ensure you a HIGH SCORE (2022)
Pass Desktop-Specialist Exam with Latest Questions
NEW QUESTION 43
Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :
2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:
3) Finally, click on the Show mark Labels icon:
4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:
NEW QUESTION 44
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 use more than 2 fields
- B. No difference, calculated fields cannot be created in Blends
- C. Fields used in Blends must first be aggregated
- D. The calculated fields created in Blends cannot be edited once created
Answer: C
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 45
How can you change the Default Aggregation for a measure in Tableau?
- A. By changing its properties manually every time we need to use it
- B. By right clicking the measure -> Default properties and choosing Aggregation
- C. By right clicking the dimension -> Default properties and choosing Aggregation
- D. By double clicking on the measure, and then choosing Window -> Default Aggregation
Answer: D
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 46
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins
- A. Data Blending
- B. Union
- C. Data segregation
- D. Data Joining
Answer: A
Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.
According to the official Tableau Documentation:
To read more about Data Blending, click on THIS link.
NEW QUESTION 47
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. (Correct)
- B. $16,581
- C. $48,115
- D. $147,950
- 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 48
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Continuous
- B. Discrete
- C. Fading
- D. Mixed
Answer: D
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 is NOT a new feature introduced in Tableau 2020.1?
- A. Buffer Calculations
- B. Viz Animations
- C. Set Control
- D. Dynamic Paramaters
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 50
Which of the following is not a Trend Line Model?
- A. Linear Trend Line
- B. Logarithmic Trend Line
- C. binomial Trend Line
- D. Exponential 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 51
Data blending simulates a traditional _________________ Join
- A. Left
- B. Right
- C. Inner
- D. Full Outer
Answer: A
Explanation:
Explanation
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:
NEW QUESTION 52
To connect Tableau to a CSV data source what type of connection should you use?
- A. JSON
- B. Excel
- C. Spatial
- D. Text
Answer: D
Explanation:
Explanation
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:
2) Choose the appropriate file, and click Open:
3) Finally, Tableau imports the data as shown below:
NEW QUESTION 53
Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
- A. 336,908
- B. 416,702
- C. 293,202
- D. 592,593
Answer: B
Explanation:
Explanation
Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:
NEW QUESTION 54
What does it imply if a field has a blue background?
- A. It is a measure
- B. It is a dimension
- C. It is discrete
- D. It is continuous
Answer: C
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 55
Is SUM a table calculation?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile
These can be calculated using : Table(across), Cell, or Specific dimensions!
NEW QUESTION 56
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Dimension Filter
- B. Context Filter
- C. Measure Filter
- D. Extract Filter
Answer: D
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 57
Which of the following are benefits of using Data Extracts in Tableau?
- A. Improved Performance
- B. Faster to work with
- C. Ability to use the data offline
- D. Working with freshest data at all times
Answer: A,B,C
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 58
......
What is the duration, language, and format of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
- No negative marking for wrong answers
- Language Exam: English, Japanese, Korean.
- Number of Questions: 65
- Passing score: 72%
Desktop-Specialist Exam Practice Questions prepared by Tableau Professionals: https://testinsides.vcedumps.com/Desktop-Specialist-examcollection.html
