Desktop-Specialist Dumps are Available for Instant Access [2023]
Practice with these Desktop-Specialist dumps Certification Sample Questions
NEW QUESTION # 85
A Tableau Support case can be opened in which of the following valid ways?
- A. Using the Developer Community Forum
- B. Using the Tableau learn website
- C. Contacting Salesforce using their website
- D. Using the support option on the Tableau website
Answer: D
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION # 86
_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
- A. .twbx files
- B. .twb files
- C. .tde files
- D. .tbm files
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. For more information, see Extract Your Data.
NEW QUESTION # 87
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. Sets
- C. Groups
- D. Calculation
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 # 88
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.
Inner join
Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.
NEW QUESTION # 89
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
- A. September
- B. June
- C. July
- D. October
Answer: D
Explanation:
Explanation
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:
It is clear that October with -55.3% had the lowest Year on Year growth.
NEW QUESTION # 90
What does the box in a box plot represent?
- A. The median of the middle half of the data points
- B. Minimum value of the data
- C. The interquartile range
- D. Maximum value of the data
Answer: C
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 # 91
When is an axis created for the visualisation in Tableau?
- A. When we drag a dimension to the row/column shelf
- B. When we drag a discrete field to the row/column shelf
- C. When we drag a continuous field to the row/column shelf
- D. When we drag a measure to the row/column shelf
Answer: C
Explanation:
Explanation
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.
Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).
NEW QUESTION # 92
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Measures
- C. Groups
- D. Dimensions
Answer: A,B
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 # 93
For Bullet Graphs we need at least ____________ measures
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
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.
Therefore, we need at least 2 measures for creating bullet graphs.
NEW QUESTION # 94
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Sales / Profit
- B. SUM(Sales)/SUM(Profit)
- C. Profit / Sales
- D. SUM(Profit) / SUM(Sales)
Answer: D
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 # 95
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of unique orders placed between these dates
- B. Number of orders shipped between these dates
- C. Number of orders placed in that duration
- D. Number of days between these dates
Answer: D
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 # 96
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.500
- B. 3.704
- C. 3.000
- D. 3.840
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 # 97
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Wildcard Match
- B. Single Value (slider)
- C. Multiple Values (dropdown)
- D. Regex Match
Answer: D
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION # 98
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: D
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 # 99
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. 96.46%
- B. 99.46%
- C. 97.12%
- D. 95.12%
Answer: C
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 # 100
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
- A. 25.683%
- B. 22.404%
- C. 23.497%
- D. 28.415%
Answer: B
Explanation:
Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:
NEW QUESTION # 101
What is the following icon in the Data pane used to do?
Larger image
- A. Extract Data
- B. View Data
- C. Clean Data
- D. Sort Data
Answer: B
Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
NEW QUESTION # 102
......
How much Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Cost
The cost of the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is $150. For more information related to exam prices, please visit the official website Tableau Website as the cost of exams may be subjected to vary county-wise.
Tableau Desktop-Specialist certification exam is a performance-based exam that measures the candidate's ability to solve real-world problems using Tableau Desktop. Desktop-Specialist exam consists of multiple-choice questions, hands-on exercises, and scenario-based questions, which test the candidate's ability to analyze, interpret, and visualize data using Tableau Desktop. Desktop-Specialist exam is designed to evaluate the candidate's understanding of Tableau Desktop features and functionality and their ability to use these tools to create effective data visualizations.
Get Instant Access REAL Desktop-Specialist DUMP Pass Your Exam Easily: https://passitsure.itcertmagic.com/Tableau/real-Desktop-Specialist-exam-prep-dumps.html