[Q97-Q118] 100% Guaranteed Results Desktop-Specialist Unlimited 315 Questions [2024]

100% Guaranteed Results Desktop-Specialist Unlimited 315 Questions [2024]

Desktop-Specialist Dumps PDF - Want To Pass Desktop-Specialist Fast

Tableau Desktop Specialist Exam is a certification program designed for individuals who want to demonstrate their proficiency in using Tableau Desktop. Tableau is a leading data visualization software used by businesses, organizations, and individuals to analyze and present data in a visually appealing and easy-to-understand way. The Tableau Desktop Specialist Exam is an industry-recognized certification that validates your skills and knowledge in using Tableau to create impactful visualizations, dashboards, and reports.

NEW QUESTION # 97
A field that shows average home values for the United States in 2016 is most likely :

A. A geographical dimension
B. A continuous date value dimension
C. A discrete date part dimension
D. An aggregated measure

Answer: D

Explanation:
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.
Date part and Date values don't really make much sense given the question, and neither does geography.
Therefore, the answer naturally is "An aggregated measure".

NEW QUESTION # 98
Which of the following calculations DO NOT need a quick table calculation?

A. Rank
B. Standard Deviation
C. Moving Average
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 # 99
______________ refers to the level of detail for a piece of data, wherever you are looking.

A. Data granularity
B. Data LOD
C. Data connectivity
D. Data Cleanliness

Answer: A

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 # 100
What are three geographic roles that you can assign to a field? Choose three.

A. Country
B. Time zone
C. Address
D. City
E. Airport

Answer: A,D,E

Explanation:
According to the Tableau Desktop Specialist Exam Guide, city, country, and airport are three geographic roles that you can assign to a field. Address and time zone are not geographic roles in Tableau.

NEW QUESTION # 101
Which two options can you use to change the device layout of a dashboard? Choose two.

A. The Layout pane
B. The Dashboard menu
C. The Format menu
D. The Dashboard pane

Answer: A,D

Explanation:
You can change the device layout of a dashboard by using the Dashboard pane or the Dashboard menu. The Dashboard pane allows you to select a device type and customize the layout for that device. The Dashboard menu allows you to create a new device layout or copy an existing one. The Format menu and the Layout pane do not have options for changing the device layout1

NEW QUESTION # 102
You have the following visualization.

Where should you place a field named Region to show multiple distinct lines on the same axis?

A. The Rows shelf
B. Path on the Marks card
C. The Columns shelf
D. Color on the Marks card

Answer: D

Explanation:
To display multiple distinct lines on the same axis based on a field, you should place the field on the Color shelf in the Marks card. This will encode each distinct value in the Region field with a different color, resulting in separate lines for each region on the same axis.

NEW QUESTION # 103
________________ is hosted by Tableau to share our visualisations publically with the world.

A. Tableau Public
B. Tableau Reader
C. Tableau Desktop
D. Tableau Server

Answer: A

Explanation:
Tableau Public is a free service that lets anyone publish interactive data visualizations to the web.
Visualizations that have been published to Tableau Public ("vizzes") can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.
Check it out : https://public.tableau.com/en-us/s/

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. September
B. July
C. October
D. June

Answer: C

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
Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf.
Which of the following would create a stacked bar chart?

A. By dragging another measure to Color on the Marks card
B. By dragging another dimension to Color on the Marks card
C. By dragging another dimension to the Rows shelf
D. By dragging another measure to the Columns shelf

Answer: B

Explanation:
Very important question for the exam and appears quite a lot too.
The correct answer is - By dragging another dimension to Color on the Marks card.
Chart, bar chart Description automatically generated

This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.
Chart, bar chart Description automatically generated

The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.

NEW QUESTION # 106
For creating variable sized bins we use __________________

A. Calculated Fields
B. Table Calculations
C. Sets
D. Groups

Answer: A

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 # 107
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

A. $147,950
B. $48,115
C. $33,768
D. (Correct)
E. $16,581

Answer: E

Explanation:
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:

2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :

ii) Next, drag Color to Filters and Choose only White:

iii) Next, drag State ID to Filters, and choose New York (NY):

And Voila! We have our answer as follows:

iv) Last, drag Sales to Label:

NEW QUESTION # 108
When using a data source that has relationships, how can you add a join between two or more tables?

A. From the Connections pane, select Add.
B. From the Tables pane, drag a table directly on top of an existing logical table.
C. From the Tables pane, double-click a table.
D. Double-click a logical table in the canvas.

Answer: A

Explanation:
When using a data source that has relationships, you can add a join between two or more tables by dragging a table directly on top of an existing logical table from the Tables pane. This will create a logical table that contains the joined tables. You can then edit the join type, join clauses, and join calculation as needed2 The other options are not valid ways to add a join between tables when using relationships. From the Tables pane, double-clicking a table will add it to the data source as a separate logical table, not joined with any other table.
From the Connections pane, selecting Add will allow you to add another connection to the data source, not join tables within the same connection. Double-clicking a logical table in the canvas will open the Data Source page, where you can view and edit the fields in the logical table, not join it with another table2

NEW QUESTION # 109
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. 112,256
B. 111,060
C. 1,461
D. 1,222

Answer: A

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 # 110
DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

A. 0
B. 1
C. 2
D. 3

Answer: A

Explanation:
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!

2) Or, you can simply go to Data Source -> Country Tab -> Describe

As you can see, 147 members exist in this Country column!

NEW QUESTION # 111
Which three statements accurately describes the capabilities of dashboard actions? Choose three.

A. Can be set to run on Hover, Select, or Menu
B. Can have multiple source and target sheets
C. Can be set to Filter, Highlight, or Go to URL
D. Can be set to dynamically update when a workbook opens
E. Can be set to be triggered on a data value

Answer: A,B,C

Explanation:
Dashboard actions in Tableau are interactive elements that can be used to create a more dynamic experience.
These actions can be set to filter data on the dashboard, highlight specific elements, or even direct the user to a URL when interacting with a visualization. They can be triggered by user interaction such as hover, selection, or accessing a context menu. Moreover, dashboard actions can have multiple source sheets (where the action originates) and target sheets (where the action takes effect), allowing for a complex interactivity between different parts of the dashboard.

NEW QUESTION # 112
What are two outcomes when you drag a continuous date value to the Rows shelf? Choose two,

A. The date part Is displayed as labels.
B. A quantitative axis is shown.
C. The pill on the Rows shelf is blue.
D. The pill on the Rows shelf is green.

Answer: B,D

Explanation:
Dragging a continuous date value to the Rows shelf in Tableau results in a green pill on the Rows shelf, indicating a continuous field. It also results in a quantitative axis being displayed on the visualization.
Continuous fields are used to create axes on charts and can represent a range of values smoothly. This is opposed to discrete date values, which would be represented by a blue pill and typically show headers or labels rather than a continuous axis.

NEW QUESTION # 113
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:
Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

NEW QUESTION # 114
If you see the following Filter, then you're working with _______________________ Larger image

A. Date Values
B. Grouped Dates
C. Date Functions
D. Date Parts

Answer: A

Explanation:
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

NEW QUESTION # 115
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 # 116
Which of the following is NOT a valid official data source in Tableau Desktop?

A. Google Firebase
B. Amazon Redshift
C. PostgreSQL
D. SAP HANA

Answer: A

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:
1) Server

2) File

NEW QUESTION # 117
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

A. $147,950
B. $48,115
C. $33,768
D. (Correct)
E. $16,581

Answer: E

Explanation:
Phew! Tricky one! You needed to use filters in this one.
Follow along:

2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :

ii) Next, drag Color to Filters and Choose only White:

iii) Next, drag State ID to Filters, and choose New York (NY):

And Voila! We have our answer as follows:

iv) Last, drag Sales to Label: