[Mar-2023] Tableau Desktop-Specialist DUMPS WITH REAL EXAM QUESTIONS
2023 New Real4Prep Desktop-Specialist PDF Recently Updated Questions
NEW QUESTION 63
Which of the following charts types always includes bars sorted in descending order?
- A. Gantt Chart
- B. Pareto Chart
- C. Stacked Bar Chart
- D. Pie Chart
Answer: B
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 64
Which of the following is NOT a valid official data source in Tableau Desktop?
- A. Amazon Redshift
- B. PostgreSQL
- C. Google Firebase
- D. SAP HANA
Answer: A
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 65
To use a quick table calculation, which of the following programming languages do you need to know?
- A. Javascript
- B. ython
- C. Java
- D. None of these
Answer: D
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 66
What is the one most important thing you should do after creating a Dual-axis chart?
- A. Synchronise the axis
- B. Change the colours
- C. Edit the labels
- 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 67
________________ can only create header. _______________ will create header and axis both.
- A. Groups, Sets
- B. Dimensions, Measures
- C. Dates, Strings
- D. Measures, Dimensions
Answer: B
Explanation:
Explanation
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
NEW QUESTION 68
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
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 69
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Clustering
- B. Sets
- C. Grouping
- D. Union
Answer: A
Explanation:
Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
NEW QUESTION 70
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 right clicking the measure -> Default properties and choosing Aggregation
- C. By changing its properties manually every time we need to use it
- D. By double clicking on the measure, and then choosing Window -> Default Aggregation
Answer: D
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 71
How can you format numbers in Tableau as currency?
- A. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: D
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 72
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 73
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of days between these dates
- B. Number of orders placed in that duration
- C. Number of orders shipped between these dates
- D. Number of unique orders placed between these dates
Answer: A
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 74
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a
____________ and a ____________.
- A. Data type, Value
- B. dimension, measure
- C. type, role
- D. role, type
Answer: D
Explanation:
Explanation
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time
NEW QUESTION 75
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 20,000
- B. 15,000
- C. 10,000
- D. 5,000
Answer: C
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 76
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
- A. 0
- B. 1
- C. Correct)
- D. 2
- E. 3
Answer: A
Explanation:
Explanation
Follow along the steps below:
* Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
NEW QUESTION 77
True or False: Context Filters are executed after Data Source filters
- A. False
- B. True
Answer: B
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:
NEW QUESTION 78
Is SUM a table calculation?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile
These can be calculated using : Table(across), Cell, or Specific dimensions!
NEW QUESTION 79
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. September
- B. June
- C. October
- D. July
Answer: C
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 80
How can you format an axis as Bold in Tableau?
- A. By right clicking on the axis, choosing Edit Axis, 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 format, 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: C
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 81
True or False: The Highlighting action can be disabled for the entire workbook.
- A. False
- B. True
Answer: B
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 82
You can use the __________________ in Tableau to clean / organise your data.
- A. Data cleaner
- B. Data organiser
- C. Data interpreter
- D. Data manager
Answer: C
Explanation:
Explanation
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.
NEW QUESTION 83
What will the following function return?
LEFT("Tableau", 3)
- A. An error
- B. ble
- C. eau
- D. Tab
Answer: A
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION 84
......
Latest Desktop-Specialist Pass Guaranteed Exam Dumps Certification Sample Questions: https://lead2pass.real4prep.com/Desktop-Specialist-exam.html