Get Tableau Desktop-Specialist Dumps Questions [2021] To Gain Brilliant Result
Desktop-Specialist dumps - TestKingFree - 100% Passing Guarantee
NEW QUESTION 35
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 Window -> Repository Location
- D. By clicking on Help -> Change Repository Location
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 36
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Context Filter
- B. Extract Filter
- C. Dimension Filter
- D. Measure 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 37
How can you change the Default Aggregation for a measure in Tableau?
- A. By right clicking the dimension -> Default properties and choosing Aggregation
- B. By double clicking on the measure, and then choosing Window -> Default Aggregation
- C. By changing its properties manually every time we need to use it
- D. By right clicking the measure -> Default properties and choosing Aggregation
Answer: B
Explanation:
Explanation
According to the official Tableau documentation:
Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!
NEW QUESTION 38
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 39
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 40
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 41
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 42
What will the following function return?
LEFT("Tableau", 3)
- A. eau
- B. An error
- C. Tab
- D. ble
Answer: B
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION 43
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 44
True or False: It is possible to change the Geographic Role of a dimension
- A. True
- B. False
Answer: A
Explanation:
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
NEW QUESTION 45
Is it possible to make a Measure discrete?
- A. Yes
- B. No
Answer: A
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 46
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. Yes
- B. No
Answer: A
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 47
How can you format numbers in Tableau as currency?
- A. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 48
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 49
What is the following icon in the Data pane used to do?
Larger image
- A. Extract Data
- B. Sort Data
- C. Clean Data
- D. View Data
Answer: D
Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
NEW QUESTION 50
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?
- A. 1,461
- B. 111,060
- C. 1,222
- D. 112,256
Answer: D
Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!
* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October
NEW QUESTION 51
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 discrete field to the row/column shelf
- C. When we drag a measure to the row/column shelf
- D. When we drag a dimension 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 52
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.759329
- B. 0.748472
- C. 0.739284
- D. 0.783262
Answer: D
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 53
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Binders
- B. Labels
- C. Envelopes
- D. Fasteners
Answer: D
Explanation:
Explanation
To reach the correct answer, follow the steps below:
1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'
As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!
NEW QUESTION 54
What is the one most important thing you should do after creating a Dual-axis chart?
- A. Synchronise the axis
- B. Edit the labels
- C. Change the colours
- D. Hide the axis
Answer: A
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 55
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of orders placed in that duration
- B. Number of orders shipped between these dates
- C. Number of days between these dates
- D. Number of unique orders placed between these dates
Answer: C
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 56
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 57
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Blue, Orange
- C. Red, Blue
- D. Orange, Blue
Answer: B
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 58
......
Get 100% Passing Success With True Desktop-Specialist Exam: https://www.testkingfree.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Premium Quality Tableau Desktop-Specialist Online dumps: https://drive.google.com/open?id=11i-EM6fGAlR1PJ2QHfs7LQCUhFP-YYrX