[Oct-2021] Tableau Desktop Specialist Desktop-Specialist Exam Practice Dumps
2021 Desktop-Specialist Premium Files Test pdf - Free Dumps Collection
NEW QUESTION 16
Which of the following are benefits of using Data Extracts in Tableau?
- A. Working with freshest data at all times
- B. Improved Performance
- C. Ability to use the data offline
- D. Faster to work with
Answer: B,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 17
The row and column shelves contain ___________________
- A. Grand Totals
- B. Pills
- C. Parameters
- D. Filters
Answer: B
Explanation:
Explanation
We can drag fields from the Data pane to create the structure for your visualizations.
The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
These FIELDS are also referred to as PILLS. See below:
NEW QUESTION 18
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 19
Which of the following are valid ways to add Totals to a view?
- A. Using the Analytics Pane
- B. From the Analysis Tab in the Menu bar on top
- C. Using the Data Pane
- D. Using the Marks shelf
Answer: A,B
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 20
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Values are always aggregated at the level of the Date Part
- D. Tableau doesn't aggregate values, we do!
Answer: B
Explanation:
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:
NEW QUESTION 21
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 22
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Computer -> C: -> Tableau -> Shapes
- B. In My Documents -> My Tableau Repository -> Shapes
- C. In Downloads -> My Tableau Repository -> Shapes
- D. In Program Files -> Tableau -> Shapes
Answer: B
Explanation:
Explanation
Here's how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.
NEW QUESTION 23
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. .twbx file
- B. .tde file
- C. .tbm file
- D. .twb file
Answer: A
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 24
What is the minimum amount of RAM recommended for any production use of Tableau Server?
- A. 16GB
- B. 64GB
- C. 32GB
- D. 8GB
Answer: C
Explanation:
Explanation
The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.
These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.
NEW QUESTION 25
What is the one most important thing you should do after creating a Dual-axis chart?
- A. Edit the labels
- B. Synchronise the axis
- C. Change the colours
- D. Hide the axis
Answer: B
Explanation:
Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.
To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.
NEW QUESTION 26
Larger image
What is this view referred to as in Tableau?
- A. Window Pane
- B. Dimensions & Measures
- C. Data Pane
- D. Analytics Pane
Answer: C
Explanation:
Explanation
Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.
The Data pane includes:
Dimension fields - Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.
Measure fields - Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.
For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.
Calculated fields - If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.
For more information on calculated fields, see Create Custom Fields with Calculations.
Sets - Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.
Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.
Parameters - Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.
NEW QUESTION 27
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 20,000
- B. 5,000
- C. 15,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 28
The icon associated with the field that has been grouped is a ______________
- A. =#
- B. Paper Clip
- C. Globe
- D. Intersection
Answer: B
Explanation:
Explanation
You can create a group to combine related members in a field. The icon associated with a group is a paper clip!
NEW QUESTION 29
True or False: The Highlighting action can be disabled for the entire workbook.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes, it is possible to disable highlighting for the entire workbook.
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
NEW QUESTION 30
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Groups
- C. Dimensions
- D. Measures
Answer: A,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 31
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Measure Filter
- B. Extract Filter
- C. Context Filter
- D. Dimension Filter
Answer: B
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 32
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. Edit the data source manually for a quick resolution
- C. Right click it -> Edit Default properties -> Assign geographic roles
- D. Right click it -> Geographic role -> and then assign the appropriate geographic role
Answer: D
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 33
......
Get ready to pass the Desktop-Specialist Exam right now using our Tableau Desktop Specialist Exam Package: https://www.dumpsking.com/Desktop-Specialist-testking-dumps.html
A fully updated 2021 Desktop-Specialist Exam Dumps exam guide from training expert DumpsKing: https://drive.google.com/open?id=1C2Grn5xdilIMJ0maQqDfbCWlsv1gmYdn
