Pass Your Desktop-Specialist Dumps as PDF Updated on 2021 With 150 Questions
Tableau Desktop-Specialist Real Exam Questions and Answers FREE
How to book the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
To apply for the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam, You have to follow these steps:
- Step 1: Go to the Tableau-Solutions-Architect-Professional Official Site
- Step 2: Read the instruction carefully
- Step 3: Follow the given steps
- Step 4: Apply for the Tableau-Solutions-Architect-Professional Exam
NEW QUESTION 86
We can join a maximum of ______ tables in Tableau
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Explanation
It is possible to join a maximum of 32 tables in Tableau!
NEW QUESTION 87
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.748472
- C. 0.783262
- D. 0.759329
Answer: C
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 88
Larger image
What is this entire view referred to as in Tableau?
- A. Distribution Pane
- B. Data pane
- C. Summary Pane
- D. Analytics Pane
Answer: D
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 89
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).
* Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
* 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!
3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )
NEW QUESTION 90
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Select
- B. Hover
- C. Double click
- D. Click
- E. Menu
Answer: A,B,E
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 91
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.000
- C. 3.704
- D. 3.840
Answer: C
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 92
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. 46,493
- B. 68,620
- C. 74,683
- D. 37,455
Answer: D
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 93
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. JPEG Image (.JPG, .JPEG)
- B. Portable Network Graphic (.PNG)
- C. Tagged Image File Format (TIFF)
- D. Windows Bitmap (.BMP)
Answer: A,B,D
Explanation:
Explanation
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
NEW QUESTION 94
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]/[POPULATION])
- B. SUM([GDP]*[POPULATION])
- C. SUM([GDP]) / SUM([Population])
- D. SUM([Population]/[GDP]])
Answer: C
Explanation:
Explanation
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION 95
Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?
- A. January 2018
- B. December 2017
- C. September 2017
- D. March 2018
Answer: A
Explanation:
Explanation
Follow the steps to get the correct answer : January 2018
* We are talking about dates, so use the Time series sheet as follows:
* Next, the following should be your view and clearly, January 2018 is the lowest point:
Read more about dates:
https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/
NEW QUESTION 96
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the of the revenue in the same view!
NEW QUESTION 97
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. To create 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.
- B. To 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 etc
- C. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
- D. To hold one or more worksheets, plus zero or more dashboards and stories.
Answer: B
Explanation:
Explanation
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - To 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 etc. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
3) Extract (.hyper or .tde) - To create 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.
3) (.twb) Workbooks - To hold one or more worksheets, plus zero or more dashboards and stories.
NEW QUESTION 98
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A. Trick question! It is not possible to group by labels.
- B. Nothing changes in the view, but a group is created in the Dimensions shelf.
- C. A new mark (bar) is created, which consolidates all members of the group.
- D. The colours of the members selected are now the same, and different for the rest of the members.
Answer: C
Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
NEW QUESTION 99
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 be edited once created
- B. The calculated fields created in Blends cannot use more than 2 fields
- C. No difference, calculated fields cannot be created in Blends
- 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 100
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. Right click it -> Edit Default properties -> Assign geographic roles
- D. Edit the data source manually for a quick resolution
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 101
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Clustering
- B. Sets
- C. Union
- D. Grouping
Answer: A
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 102
_________________ 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 Joining
- D. Data segregation
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 103
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.
- A. .tde file
- B. .twbx file
- C. .twb file
- D. .tbm file
Answer: B
Explanation:
Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks.
NEW QUESTION 104
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Bookmark (.tbm)
- B. Tableau Workbook (.twb)
- C. Tableau Data Extract (.tde)
- D. Tableau Packaged Workbook (.twbx)
Answer: D
Explanation:
Explanation
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)
NEW QUESTION 105
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity
- A. True
- B. False
Answer: A
Explanation:
Explanation
Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.
To disaggregate all measures in the view:
Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.
NEW QUESTION 106
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Extract Filter
- B. Context Filter
- C. Measure Filter
- D. Dimension Filter
Answer: A
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 107
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. 4.87
- B. 65.67
- C. 68.77
- D. 76.25
Answer: D
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 108
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Hierarchical
- B. Random
- C. Manual
- D. Topological
Answer: C
Explanation:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
NEW QUESTION 109
Which of the following charts types always includes bars sorted in descending order?
- A. Stacked Bar Chart
- B. Pareto Chart
- C. Pie Chart
- D. Gantt Chart
Answer: B
Explanation:
Explanation
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.
NEW QUESTION 110
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION 111
......
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certified Professional salary
The estimated average salary of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is listed below: Country wise:
- England: 87200 POUND
- India: 8580000 INR
- Europe: 97000 EURO
- United States: 114000 USD
Pass Tableau Desktop-Specialist Exam Info and Free Practice Test: https://www.exam4docs.com/Desktop-Specialist-study-questions.html
New 2021 Latest Questions Desktop-Specialist Dumps - Use Updated Tableau Exam: https://drive.google.com/open?id=1Kt_gN33Lmjy_NboPKa_piwCd8sEcjBy-
