[Sep-2021] Tableau Desktop-Specialist Dumps – Reduce Your Chance of Failure in Desktop-Specialist Exam
To help you achieve your ultimate goal, we suggest the actual Tableau Desktop-Specialist dumps for your Tableau Desktop Specialist Exam exam preparation to use as your guideline.
NEW QUESTION 63
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 25.79%
- B. 27.73%
- C. 23.39%
- D. 29.49%
Answer: B
Explanation:
Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION 64
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 dimension -> Default properties and choosing Aggregation
- C. By right clicking the measure -> 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 65
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
- A. No
- B. Yes
Answer: A
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 66
What does the following icon do in Tableau?
Larger image
- A. Create a Story and Dashboard both
- B. Create a Worksheet
- C. Create a Dashboard
- D. Create a Story
Answer: C
Explanation:
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION 67
How can you change the default Tableau repository location?
- A. By Moving the repository location manually to wherever we want
- B. By clicking on File -> Repository Location and choosing a new location
- C. By clicking on Help -> Change Repository Location
- D. By clicking on Window -> Repository Location
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 68
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. True
- B. False
Answer: A
Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
NEW QUESTION 69
True or False: All rows from both tables are returned in an INNER JOIN
- A. False
- B. True
Answer: A
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 70
DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
- A. Canada
- B. France
- C. United States
- D. United Kingdom
Answer: B
Explanation:
Explanation
Follow along to get the correct answer:
* Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)
2.2 Converting to discrete first & then using it
and then :
3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013
NEW QUESTION 71
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Click
- B. Menu
- C. Hover
- D. Select
- E. Double click
Answer: B,C,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 72
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 .twm file
- B. Save it as a .twb file
- C. Save it as a .tds file
- D. Save it as a .twbx file
Answer: C
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 73
You can use the __________________ in Tableau to clean / organise your data.
- A. Data manager
- B. Data organiser
- C. Data cleaner
- D. Data interpreter
Answer: D
Explanation:
Explanation
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.
NEW QUESTION 74
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 75
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. Sets
- B. Groups
- C. Calculation
- D. Parameters
Answer: D
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 76
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. join
- B. union
- C. concatenate
- D. blend
Answer: B
Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
A union of these tables creates the following single table that contains all rows from all tables.
NEW QUESTION 77
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. 74,683
- B. 37,455
- C. 46,493
- D. 68,620
Answer: B
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 78
......
100% Free Desktop-Specialist Demo-Trial [Pdf], get it now: https://drive.google.com/open?id=1EYb71INbOh4eVZRv4s28RdtyDHV1h7hj
Accurate & Verified Answers As Seen in the Real Exam here: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html