100% Free Desktop-Specialist Exam Dumps Use Real Tableau Desktop Specialist Dumps With 150 Questions!
Pass Your Desktop-Specialist Exam Easily With 100% Exam Passing Guarantee [2023]
Tableau is a powerful data visualization tool that has become increasingly popular in recent years. Tableau Desktop-Specialist certification exam is designed to test the proficiency of users in using Tableau Desktop. Tableau Desktop Specialist Exam certification is primarily aimed at individuals who use Tableau Desktop for data analysis and visualization, but it is also relevant for those who are responsible for creating dashboards and reports for business intelligence and data analytics.
Introduction to Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
As companies switch employment quickly into the public cloud, cloud storage has become a deep sector. Tableau is regarded as a leader in the field and the most seasoned cloud service as a pioneer in ideas and a benchmark amongst all its adversaries. This transformation requires a range of features for designing, deploying and managing cloud computing services. Get certified Tableau programs with all the credentials (plus top performers) that one of the most successful cloud storage companies will better assess. The credential represents, within the enterprise, a shared network concept, understood terms, and a fundamental degree of cloud experience that can speed up the cloud job assessment. The guidelines below contain the Tableau Architect-Professional Certification Examination, the Tableau Architect/Professional Qualification Pay, and all test facts, such as Tableau Desktop-Specialist practice exams.
Tableau eLearning offers self-running learning modules and a demo for each subject. It is the main resource. We found, however, that most but not all the competencies in the Exam Prep Guide covered the suggested Desktop I: Basic course. In reality, Desktop II has been able to use the following skills: midway through the course - data (included in a joint, mix, or union), create a set, apply a background filter, use bins and histograms, and add a parameter. We have now completed our intermediate level course - but, if you wish, all you can do is take the modules. We suggest you take notice of important principles, such as the distinction between discrete and continuous fields, as you look at the demonstrations. It was also useful to do the analysis exercises .The price of e-learning is USD 10/user per month. To access the activity files, you will also need a personal or technical Tableau Desktop license. If you are a specialist, it is worth asking if they will cover the costs of your preparation, website, and qualification. You can use Tableau eLearning and desktop for free for a year if you have a valid email address from your university.
NEW QUESTION # 88
What does the following icon do in Tableau?
Larger image
- A. Create a Worksheet
- B. Create a Dashboard
- C. Create a Story
- D. Create a Story and Dashboard both
Answer: B
Explanation:
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION # 89
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of orders placed in that duration
- B. Number of days between these dates
- C. Number of orders shipped between these dates
- D. Number of unique orders placed between these dates
Answer: B
Explanation:
Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.
NEW QUESTION # 90
__________ 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 # 91
How do you identify a continuous field in Tableau?
- A. It is identified by a blue pill in the visualization
- B. It is preceded by a '=#' symbol in the data window
- C. It is preceded by a 'Abc' symbol in the data window
- D. It is identified by a green pill in a visualization
Answer: B
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 # 92
DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!
2) Or, you can simply go to Data Source -> Country Tab -> Describe
As you can see, 147 members exist in this Country column!
NEW QUESTION # 93
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([GDP]/[POPULATION])
- C. SUM([GDP]*[POPULATION])
- D. SUM([Population]/[GDP]])
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 # 94
What will the following function return?
LEFT("Tableau", 3)
- A. ble
- B. eau
- C. Tab
- D. An error
Answer: D
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION # 95
A field that shows average home values for the United States in 2016 is most likely :
- A. A geographical dimension
- B. An aggregated measure
- C. A discrete date part dimension
- D. A continuous date value dimension
Answer: B
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 # 96
Which of the following calculations DO NOT need a quick table calculation?
- A. Standard Deviation
- B. Variance
- C. Rank
- D. Moving Average
Answer: B
Explanation:
Explanation
For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:
However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.
NEW QUESTION # 97
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
- A. 95.12%
- B. 99.46%
- C. 96.46%
- D. 97.12%
Answer: D
Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :
NEW QUESTION # 98
How can you format numbers in Tableau as currency?
- A. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 99
True or False: All rows from both tables are returned in an INNER JOIN
- A. True
- B. False
Answer: B
Explanation:
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
NEW QUESTION # 100
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.739284
- B. 0.783262
- C. 0.748472
- D. 0.759329
Answer: B
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 # 101
True or False: Trend lines can only be used with numeric or date fields
- A. True
- B. False
Answer: B
Explanation:
Explanation
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.
NEW QUESTION # 102
Which of the following is not a Trend Line Model?
- A. binomial Trend Line
- B. Linear Trend Line
- C. Exponential Trend Line
- D. Logarithmic Trend Line
Answer: D
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 # 103
Dates in Tableau are typically treated as ______________
- A. Dimensions
- B. Measures
Answer: A
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 # 104
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 # 105
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 Online
- C. Tableau Reader
- D. Tableau Server
Answer: C
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION # 106
Which of the following is NOT a new feature introduced in Tableau 2020.1?
- A. Buffer Calculations
- B. Set Control
- C. Dynamic Paramaters
- D. Viz Animations
Answer: B
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 # 107
Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?
- A. 68,620
- B. 74,683
- C. 37,455
- D. 46,493
Answer: C
Explanation:
Explanation
If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:
2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:
3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:
4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.
Now the chart looks like this:
Now we change the Profit chart type to line:
5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'
And, our final view and answer is:
NEW QUESTION # 108
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A. No difference, calculated fields cannot be created in Blends
- B. The calculated fields created in Blends cannot use more than 2 fields
- C. The calculated fields created in Blends cannot be edited once created
- 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 # 109
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Menu
- B. Hover
- C. Double click
- D. Select
- E. Click
Answer: A,B,D
Explanation:
Explanation
Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:
1) Select
2) Hover
3) Menu
Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)
NEW QUESTION # 110
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. 5,129 and 88,872
- D. 1,807 and 34,571
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 # 111
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
This is a tricky question. We are talking about story POINTS, and not entire stories in the question.
To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.
I can simply drag the dashboard into the view to create a new story point.
Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:
The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.
Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm
NEW QUESTION # 112
......
Study resources for the Valid Desktop-Specialist Braindumps: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html
Desktop-Specialist Dumps are Available for Instant Access: https://drive.google.com/open?id=1p2XAHMIEWT86CxFm-2FkAcf3e0OpceZe