Pass Desktop-Specialist Exam in First Attempt Guaranteed 2022 Dumps!
Desktop-Specialist Dumps Full Questions - Exam Study Guide
NEW QUESTION 73
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Portable Network Graphic (.PNG)
- B. Tagged Image File Format (TIFF)
- C. JPEG Image (.JPG, .JPEG)
- D. Windows Bitmap (.BMP)
Answer: A,C,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 74
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Double click
- B. Menu
- C. Hover
- D. Select
- E. 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 75
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Red, Blue
- C. Orange, Blue
- D. Blue, Orange
Answer: D
Explanation:
Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:
NEW QUESTION 76
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Sanjit Engle
- B. Penelope Sewall
- C. Tamara Chand
- D. Tom Ashbrook
Answer: B
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION 77
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.2s
- B. 0.3s
- C. 0.4s
- D. 0.5s
Answer: B
Explanation:
Explanation
The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!
NOTE: Animations are DISABLED by default and must be manually enabled.
You can also reset all settings to default by clickin on 'Reset All'
NEW QUESTION 78
By definition, Tableau displays measures over time as a ____________
- A. Stacked Bar
- B. Bar
- C. Line
- D. Packed Bubble
Answer: C
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 79
When is an axis created for the visualisation in Tableau?
- A. When we drag a measure to the row/column shelf
- B. When we drag a dimension to the row/column shelf
- C. When we drag a continuous field to the row/column shelf
- D. When we drag a discrete field 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 80
Which of the following calculations DO NOT need a quick table calculation?
- A. Rank
- B. Standard Deviation
- C. Variance
- D. Moving Average
Answer: C
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 81
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.
- A. Union Search
- B. Pattern Search
- C. Regex Search
- D. Wildcard Search
Answer: D
Explanation:
Explanation
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.
NEW QUESTION 82
Which of the following is NOT a valid official data source in Tableau Desktop?
- A. SAP HANA
- B. Google Firebase
- C. PostgreSQL
- D. Amazon Redshift
Answer: D
Explanation:
Explanation
Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.
But then again, it is a workaround and not an official out-of-the-box solution.
The following are the available Data sources available as of now:
* Server
* File
NEW QUESTION 83
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 84
Is it possible to make a Measure discrete?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:
Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!
NEW QUESTION 85
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. 37,455
- B. 74,683
- C. 46,493
- D. 68,620
Answer: A
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 86
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Multiple Values (dropdown)
- B. Single Value (slider)
- C. Wildcard Match
- 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 87
Which of the following are benefits of using Data Extracts in Tableau?
- A. Ability to use the data offline
- B. Working with freshest data at all times
- C. Faster to work with
- D. Improved Performance
Answer: A,C,D
Explanation:
Explanation
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!
NEW QUESTION 88
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 .twm 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 89
Which of the following are valid ways to add Totals to a view?
- A. Using the Data Pane
- B. Using the Marks shelf
- C. From the Analysis Tab in the Menu bar on top
- D. Using the Analytics Pane
Answer: C,D
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION 90
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. 65.67
- B. 68.77
- C. 76.25
- D. 4.87
Answer: C
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 91
Which of the following charts types always includes bars sorted in descending order?
- A. Pareto Chart
- B. Gantt Chart
- C. Stacked Bar Chart
- D. Pie Chart
Answer: A
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 92
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. October
- B. June
- C. September
- D. July
Answer: A
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:
NEW QUESTION 93
Are animations enabled by default in Tableau?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
NEW QUESTION 94
For Bullet Graphs we need at least ____________ measures
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
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 95
To use a quick table calculation, which of the following programming languages do you need to know?
- A. ython
- B. None of these
- C. Java
- D. Javascript
Answer: B
Explanation:
Explanation
You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
NEW QUESTION 96
Which of the following can you add a reference line to?
- A. Dimensions
- B. Measures
- C. Calculated Fields
- D. Groups
Answer: B,C
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 97
......
Tableau Desktop Specialist Free Certification Exam Material from ActualPDF with 150 Questions: https://pass4sure.actualpdf.com/Desktop-Specialist-real-questions.html
