[Jan 15, 2024] Desktop-Specialist Exam Dumps 100% Same Q&A In Your Real Exam
Desktop-Specialist Test Engine Dumps Training With 150 Questions
NEW QUESTION # 87
Which of the following can you add a reference line to?
- A. Dimensions
- B. Calculated Fields
- C. Groups
- D. Measures
Answer: B,D
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 # 88
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Numbers and Headers
- B. Labels and Values
- C. Rows and Columns
- D. Dimensions and Measures
Answer: D
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.
Further,
NEW QUESTION # 89
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 -> Geographic role -> and then assign the appropriate geographic role
- C. Edit the data source manually for a quick resolution
- D. Right click it -> Edit Default properties -> Assign geographic roles
Answer: B
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 # 90
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of unique orders placed between these dates
- B. Number of days between these dates
- C. Number of orders placed in that duration
- D. Number of orders shipped 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 # 91
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Continuous Value, Discrete Value
- B. Geographic Value, Discrete Value
- C. Discrete value, Continuous Value
- D. Longitude, Latitude
Answer: C
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 # 92
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 5,000
- B. 15,000
- C. 20,000
- D. 10,000
Answer: D
Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
NEW QUESTION # 93
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 # 94
A field that shows average home values for the United States in 2016 is most likely :
- A. A discrete date part dimension
- B. A continuous date value dimension
- C. A geographical dimension
- D. An aggregated measure
Answer: D
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 # 95
By definition, Tableau displays measures over time as a ____________
- A. Line
- B. Stacked Bar
- C. Bar
- D. Packed Bubble
Answer: A
Explanation:
Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:
NEW QUESTION # 96
You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?
- A. Save it as a .twb file
- B. Save it as a .twbx file
- C. Save it as a .twm file
- D. Save it as a .tds file
Answer: D
Explanation:
Explanation
After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: 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.
twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.
NEW QUESTION # 97
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A. Help improve performance
- B. To support additional functionality such as count distinct
- C. To have access to the freshest possible data at all times
- D. Fast to create
Answer: A,B,D
Explanation:
Explanation
From the official documentation, the following are the major advantages of using Tableau Data Extracts:
From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
NEW QUESTION # 98
A Tableau Support case can be opened in which of the following valid ways?
- A. Using the support option on the Tableau website
- B. Contacting Salesforce using their website
- C. Using the Developer Community Forum
- D. Using the Tableau learn website
Answer: A
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION # 99
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. 76.25
- B. 68.77
- C. 4.87
- D. 65.67
Answer: A
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 # 100
Data blending simulates a traditional _________________ Join
- A. Inner
- B. Right
- C. Left
- D. Full Outer
Answer: C
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 # 101
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
- A. Correct)
- B. 0
- C. 1
- D. 2
- E. 3
Answer: D
Explanation:
Explanation
Follow along the steps below:
* Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
NEW QUESTION # 102
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. 592,593
- D. 293,202
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 # 103
......
Tableau Desktop-Specialist Exam is a certification exam designed for individuals who want to demonstrate their proficiency in using Tableau Desktop software. Tableau Desktop is a powerful data visualization tool that allows users to connect to various data sources, create interactive dashboards, and share insights with others. Tableau Desktop Specialist Exam certification exam tests candidates' knowledge of Tableau Desktop's features and functionalities, as well as their ability to use the software to analyze and visualize data effectively.
Desktop-Specialist Practice Test Pdf Exam Material: https://www.actualtests4sure.com/Desktop-Specialist-test-questions.html
Desktop-Specialist Questions Pass on Your First Attempt Dumps for Tableau Desktop Specialist Certified: https://drive.google.com/open?id=1TYvAWHpuSYiNPst59KKN_cLXwGSaKcFw
