[Jan-2022] Desktop-Specialist Pre-Exam Practice Tests | Exam Questions and Answers for Tableau Desktop Specialist Study Guide
Tableau Desktop Specialist Exam Certification Sample Questions
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. 76.25
- B. 68.77
- C. 4.87
- D. 65.67
Answer: A
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
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 92
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]*[POPULATION])
- B. SUM([Population]/[GDP]])
- C. SUM([GDP]/[POPULATION])
- D. SUM([GDP]) / SUM([Population])
Answer: D
Explanation:
Explanation
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION 93
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.5s
- B. 0.4s
- C. 0.3s
- D. 0.2s
Answer: C
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 94
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?
- A. YES, we can do this with the help of a plugin
- B. YES, we can do this with the help of a Web-Page object
- C. YES, we can do this with the help of Tableau Public
- D. NO, this is not currently possible in Tableau
Answer: B
Explanation:
Explanation
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
NEW QUESTION 95
Which of the following are valid ways to copy a worksheet visualisation as an image?
- A. Using the Marks shelf and choosing Copy->Image
- B. By simply clicking Control + V on the keyboard
- C. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
- D. By right clicking on the worksheet visualisation and selecting Copy->Image
Answer: C,D
Explanation:
Explanation
The following are 2 correct ways to copy the worksheet visualisation as an image:
AND
NEW QUESTION 96
What does the box in a box plot represent?
- A. Minimum value of the data
- B. The median of the middle half of the data points
- C. The interquartile range
- D. Maximum value of the data
Answer: C
Explanation:
Explanation
In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
NEW QUESTION 97
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. To hold one or more worksheets, plus zero or more dashboards and stories.
- B. 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.
- C. 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
- D. 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.
Answer: C
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
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. aliases
- B. copies
- C. parameters
- D. duplicates
Answer: A
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 99
For creating variable sized bins we use __________________
- A. Sets
- B. Calculated Fields
- C. Table Calculations
- D. Groups
Answer: B
Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
NEW QUESTION 100
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
- A. Tableau Server
- B. Tableau myServer
- C. Tableau Prep
- D. Tableau Public
Answer: B
Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
NEW QUESTION 101
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. September 2017
- B. January 2018
- C. March 2018
- D. December 2017
Answer: B
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 102
What is a story point in Tableau?
- A. A collection of worksheets
- B. A single worksheet or dashboard
- C. A collection of dashboards
- D. A collection of both worksheets and dashboards
Answer: B
Explanation:
Explanation
In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.
NEW QUESTION 103
True or False: Trend lines can only be used with numeric or date fields
- A. True
- B. False
Answer: B
Explanation:
Explanation
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.
NEW QUESTION 104
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?
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. July
- C. June
- D. September
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:
It is clear that October with -55.3% had the lowest Year on Year growth.
NEW QUESTION 105
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Data Pane
- C. Marks Card
- D. Analytics Pane
Answer: C
Explanation:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!
The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.
You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.
In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.
NEW QUESTION 106
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 107
True or False: A reference line cannot be added from the Analytics Pane
- A. True
- B. False
Answer: B
Explanation:
Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:
NEW QUESTION 108
How can you format an axis as Bold in Tableau?
- A. By right clicking on the axis, choosing format, and then setting its font 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 clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
Answer: A
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 109
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In Downloads -> My Tableau Repository -> Shapes
- B. In Program Files -> Tableau -> Shapes
- C. In My Computer -> C: -> Tableau -> Shapes
- D. In My Documents -> My Tableau Repository -> Shapes
Answer: D
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 110
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
- A. top left bottom left
- B. top right, bottom left
- C. top left, bottom right
- D. top right, bottom right
Answer: B
Explanation:
Explanation
Tree maps size begins from maximum in top left to smallest in bottom right.
See below to learn how to create a TreeMap and add colours to it:
NEW QUESTION 111
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Single Value (slider)
- B. Regex Match
- C. Multiple Values (dropdown)
- D. Wildcard Match
Answer: B
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION 112
......
Tableau Exam Practice Test To Gain Brilliante Result: https://officialdumps.realvalidexam.com/Desktop-Specialist-real-exam-dumps.html
