Guide (New 2022) Actual Tableau Desktop-Specialist Exam Questions
Desktop-Specialist Exam Dumps Pass with Updated 2022 Certified Exam Questions
NEW QUESTION 85
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. July
- B. October
- C. June
- D. September
Answer: B
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 86
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A. Fast to create
- B. To have access to the freshest possible data at all times
- C. To support additional functionality such as count distinct
- D. Help improve performance
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 87
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A. Edit the config file in My Documents -> MyTableauRepository for a quick fix
- B. Edit the data source manually for a quick resolution
- C. Right click it -> Geographic role -> and then assign the appropriate geographic role
- D. Right click it -> Edit Default properties -> Assign geographic roles
Answer: C
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 88
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on Data in the Menu bar and Choose Show Mark Labels
- B. Click on Analysis in the Menu bar and choose Show Mark Labels
- C. Click on the Show mark labels icon in the Toolbar
- D. Drag the measure to the Text label in the Marks Card
Answer: B,C,D
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION 89
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 1 , 2
- B. 1 , 4
- C. 2 , 3
- D. 2 , 2
Answer: B
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 90
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Numbers and Headers
- B. Dimensions and Measures
- C. Rows and Columns
- D. Labels and Values
Answer: B
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
Further,
NEW QUESTION 91
Which of the following is NOT a valid official data source in Tableau Desktop?
- A. Amazon Redshift
- B. PostgreSQL
- C. SAP HANA
- D. Google Firebase
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 92
True or False: It is possible to add a field to more than one hierarchy
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
NEW QUESTION 93
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. union
- B. blend
- C. concatenate
- D. join
Answer: A
Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
A union of these tables creates the following single table that contains all rows from all tables.
NEW QUESTION 94
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.3s
- B. 0.5s
- C. 0.4s
- D. 0.2s
Answer: A
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 95
How do you identify a continuous field in Tableau?
- A. It is preceded by a '=#' symbol in the data window
- B. It is identified by a green pill in a visualization
- C. It is preceded by a 'Abc' symbol in the data window
- D. It is identified by a blue pill in the visualization
Answer: A
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
NEW QUESTION 96
Which of the following calculations DO NOT need a quick table calculation?
- A. Rank
- B. Moving Average
- C. Variance
- D. Standard Deviation
Answer: C
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 97
______________ refers to the level of detail for a piece of data, wherever you are looking.
- A. Data Cleanliness
- B. Data LOD
- C. Data connectivity
- D. Data granularity
Answer: D
Explanation:
Explanation
Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.
NEW QUESTION 98
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 29.49%
- B. 23.39%
- C. 27.73%
- D. 25.79%
Answer: C
Explanation:
Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION 99
True or False: All rows from both tables are returned in an INNER JOIN
- A. False
- B. True
Answer: A
Explanation:
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
NEW QUESTION 100
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
- A. 99.46%
- B. 96.46%
- C. 97.12%
- D. 95.12%
Answer: C
Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :
NEW QUESTION 101
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Measure Names
- C. Number of Records
- D. Calculated Fields
Answer: A,B
Explanation:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
NEW QUESTION 102
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a
____________ and a ____________.
- A. role, type
- B. dimension, measure
- C. Data type, Value
- D. type, role
Answer: A
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 103
Which of the following are valid ways to add Totals to a view?
- A. From the Analysis Tab in the Menu bar on top
- B. Using the Analytics Pane
- C. Using the Marks shelf
- D. Using the Data Pane
Answer: A,B
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION 104
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. 65.67
- C. 4.87
- D. 68.77
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 105
We can join a maximum of ______ tables in Tableau
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
It is possible to join a maximum of 32 tables in Tableau!
NEW QUESTION 106
Which of the following can you add a reference line to?
- A. Groups
- B. Dimensions
- C. Calculated Fields
- D. Measures
Answer: C,D
Explanation:
Explanation
You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.
Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.
NEW QUESTION 107
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Marks Card
- C. Analytics Pane
- D. Data Pane
Answer: B
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 108
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. 2
- D. 3
- E. Correct)
Answer: C
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 109
......
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Certification Path
Exam Training teaches you how to interpret test questions and how long you will be absent from class.Our Readiness for Examination: Tableau Certified Solutions Architect - A training class in the class room or engaging in a physical or virtual classroom with Tableau Approved Learner is provided in different formats. Free digital training for learning whenever needed. The course reviews sample questions in each subject and how the tested subjects are to be learned and makes it possible to prevent incorrect responses. Find the best selection for you.
Experience of Tableau in computation, networking, storage and database applications Practical experience in Tableau deployment and operating systems The ability of Tableau-based software to identify and establish functional criteria. The opportunity to define which Tableau systems meet specific technical requirements. Knowledge of recommended best practices for secure and effective Tableau platform implementations. Understanding Tableau Cloud's main architectural tenets. Tableau worldwide understanding of infrastructure. An awareness of network infrastructure relevant to Tableau. Understand the safety features and services of Tableau and its links to traditional providers.
Pass Guaranteed Quiz 2022 Realistic Verified Free Tableau: https://torrentpdf.guidetorrent.com/Desktop-Specialist-dumps-questions.html