[Feb 07, 2022] Pass Desktop-Specialist Review Guide, Reliable Desktop-Specialist Test Engine
Desktop-Specialist Test Engine Practice Test Questions, Exam Dumps
NEW QUESTION 18
Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?
- A. 4,888 and 17,817
- B. 1,807 and 34,571
- C. 52,678 and 311,404
- D. 5,129 and 88,872
Answer: A
Explanation:
Explanation
To reach the correct answer, follow these steps:
1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:
2) Drag Profit to Text in the Marks Shelf as shown:
3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS
The following will be the final view:
You could also Filter by Region to only Focus on Canada, but that's your choice:
THEREFORE,
2012 = 4,888
2011 -> 2014 = 17,817
NEW QUESTION 19
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
This is a tricky question. We are talking about story POINTS, and not entire stories in the question.
To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.
I can simply drag the dashboard into the view to create a new story point.
Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:
The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.
Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm
NEW QUESTION 20
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. Click on Data in the main menu above, and click on choose color.
- D. From the Data pane, drag a field to Color on the Marks card.
Answer: D
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 21
What is the minimum amount of RAM recommended for any production use of Tableau Server?
- A. 16GB
- B. 8GB
- C. 32GB
- D. 64GB
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 22
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 23
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 24
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Fading
- B. Discrete
- C. Continuous
- D. Mixed
Answer: D
Explanation:
Explanation
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version:
For more information about color palettes, see Color Palettes and Effects.
NEW QUESTION 25
Which data type in Tableau does this icon represent?
Larger image
- A. Geographic
- B. True or False
- C. Boolean
- D. String
Answer: A
Explanation:
Explanation
The following is the table for the data types in Tableau along with their icons:
NEW QUESTION 26
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Sets
- B. Clustering
- C. Union
- D. Grouping
Answer: B
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 27
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A. False
- B. rue
Answer: A
Explanation:
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, 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.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
NEW QUESTION 28
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 29
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Discrete value, Continuous Value
- B. Geographic Value, Discrete Value
- C. Continuous Value, Discrete Value
- D. Longitude, Latitude
Answer: A
Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:
NEW QUESTION 30
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 2 , 2
- B. 2 , 3
- C. 1 , 4
- D. 1 , 2
Answer: C
Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
NEW QUESTION 31
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 32
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A. Right click it -> Geographic role -> and then assign the appropriate geographic role
- B. Edit the config file in My Documents -> MyTableauRepository for a quick fix
- C. Right click it -> Edit Default properties -> Assign geographic roles
- D. Edit the data source manually for a quick resolution
Answer: A
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
To connect Tableau to a CSV data source what type of connection should you use?
- A. JSON
- B. Excel
- C. Text
- D. Spatial
Answer: C
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 34
Which of the following calculations DO NOT need a quick table calculation?
- A. Moving Average
- B. Rank
- C. Standard Deviation
- D. Variance
Answer: D
Explanation:
Explanation
For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:
However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.
NEW QUESTION 35
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 36
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: E
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 37
......
100% Free Desktop-Specialist Daily Practice Exam With 150 Questions: https://examtorrent.actualcollection.com/Desktop-Specialist-exam-questions.html