New 2021 Desktop-Specialist exam questions Welcome to download the newest Dumpexams Desktop-Specialist PDF dumps (150 Q&As)
P.S. Free 2021 Tableau Desktop Specialist Desktop-Specialist dumps are available on Google Drive shared by Dumpexams
NEW QUESTION 21
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 22
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A. Help improve performance
- B. To have access to the freshest possible data at all times
- C. To support additional functionality such as count distinct
- D. Fast to create
Answer: A,C,D
Explanation:
Explanation
From the official documentation, the following are the major advantages of using Tableau Data Extracts:
From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
NEW QUESTION 23
How can you add color to marks in the view in Tableau?
- A. From the Analytics pane, drag a model to Color on the Marks card.
- B. In the column/row shelf, right click the field and click on edit in shelf to select the color.
- C. From the Data pane, drag a field to Color on the Marks card.
- D. Click on Data in the main menu above, and click on choose color.
Answer: C
Explanation:
Explanation
To assign a color to marks in the view, do the following:
From the Data pane, drag a field to Color on the Marks card.
Tableau applies different colors to marks based on the field's values and members. For example, if you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is assigned a color.
If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.
NEW QUESTION 24
How can you format an axis as Bold in Tableau?
- A. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
- B. By choosing the axis and selecting Command/Control + B on your keyboard
- C. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
- D. By right clicking on the axis, choosing format, and then setting its font to bold.
Answer: D
Explanation:
Explanation
To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:
None of the other options are valid ways to make the axis bold.
Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm
NEW QUESTION 25
What term is used to describe the following picture?
- A. Parameter
- B. Hierarchy
- C. Set
- D. Larger image
- E. Group
Answer: C
Explanation:
Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
NEW QUESTION 26
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. 76.25
- C. 65.67
- D. 68.77
Answer: B
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 27
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 28
If you see the following Filter, then you're working with _______________________ Larger image
- A. Date Values
- B. Date Parts
- C. Grouped Dates
- D. Date Functions
Answer: A
Explanation:
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.
NEW QUESTION 29
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.748472
- B. 0.759329
- C. 0.783262
- D. 0.739284
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 30
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. duplicates
- B. aliases
- C. copies
- D. parameters
Answer: B
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION 31
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 32
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 33
________________ files are shortcuts for quickly connecting to the original data that you use often. 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.
- A. .tbm
- B. .tde
- C. .tds
- D. .twb
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. 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. For more information, see Save Data Sources.
NEW QUESTION 34
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 35
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of orders placed in that duration
- B. Number of unique orders placed between these dates
- C. Number of orders shipped between these dates
- 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 36
True or False : Bins can be created on dimensions
- A. rue
- B. False
Answer: A
Explanation:
Explanation
Bin are a user-defined grouping of numerical data in the data source.
According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.
Have a look at the following image. When we right click a measure, we get the following options:
However, for a dimension (this is because the of this dimension is a string:
But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:
We can clearly create bins from dimensions too - they just have to be numeric :)
For more information, please refer to: https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm
NEW QUESTION 37
_________________ 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 Joining
- B. Data Blending
- C. Union
- D. Data segregation
Answer: B
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 38
When is an axis created for the visualisation in Tableau?
- A. When we drag a continuous field to the row/column shelf
- B. When we drag a dimension to the row/column shelf
- C. When we drag a discrete field to the row/column shelf
- D. When we drag a measure to the row/column shelf
Answer: A
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 39
To connect Tableau to a CSV data source what type of connection should you use?
- A. Spatial
- B. JSON
- C. Excel
- D. Text
Answer: D
Explanation:
Explanation
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:
2) Choose the appropriate file, and click Open:
3) Finally, Tableau imports the data as shown below:
NEW QUESTION 40
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. No difference, calculated fields cannot be created in Blends
- C. Fields used in Blends must first be aggregated
- D. The calculated fields created in Blends cannot use more than 2 fields
Answer: C
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 41
......
Desktop-Specialist exam questions from Dumpexams dumps: https://www.dumpexams.com/Desktop-Specialist-real-answers.html (150 Q&As)
Free 2021 Tableau Desktop Specialist Desktop-Specialist dumps are available on Google Drive shared by Dumpexams: https://drive.google.com/open?id=19_uk3XQEaLFcw6UH3cvBOkGU4VXbrhZ9