[Sep-2023] Pass Tableau Desktop-Specialist Exam in First Attempt Guaranteed!

Full Desktop-Specialist Practice Test and 150 unique questions with explanations waiting just for you, get it now!

NEW QUESTION # 35
Which of the following are valid ways of Grouping Data?

• A. From the Dimensions Shelf
• B. Using Labels in the View
• C. Using Marks in the view
• D. From the Analytics Pane

Answer: A,B,C

Explanation:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:

Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:

They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):

Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:

Finally, we can group directly from the Dimensions shelf as follows:

Now choose Phones, Chairs and Storage and Click Group:

You will now automatically have a new Dimension as follows:

NEW QUESTION # 36
Which of the following are benefits of using Data Extracts in Tableau?

• A. Improved Performance
• B. Working with freshest data at all times
• C. Ability to use the data offline
• D. Faster to work with

Answer: A,C,D

Explanation:
Explanation
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!

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

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

Answer: A

Explanation:
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 # 38
What does the box in a box plot represent?

• A. The interquartile range
• B. Minimum value of the data
• C. Maximum value of the data
• D. The median of the middle half of the data points

Answer: A

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 # 39
_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

• A. .tbm files
• B. .twbx files
• C. .twb files
• D. .tde files

Answer: D

Explanation:
Explanation
According to the official Tableau documentation:
Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. For more information, see Extract Your Data.

NEW QUESTION # 40
True or False: Sets can be created on Measures

• A. True
• B. False

Answer: B

Explanation:
Explanation
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source.
They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.


Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/

NEW QUESTION # 41
Data blending simulates a traditional _________________ Join

• A. Inner
• B. Full Outer
• C. Right
• D. Left

Answer: D

Explanation:
Explanation
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:

NEW QUESTION # 42
Are animations enabled by default in Tableau?

• A. No
• B. Yes

Answer: A

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 # 43
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

• A. If we want to use filters in the visualisation.
• B. If we want to dynamically enter parameters to the visualisation.
• C. If we want to interact with the visualisation.
• D. If we want a static view of the visualisation.

Answer: D

Explanation:
Explanation
Exporting the visualisation gives us a static view of the visualisation.
It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.
In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

NEW QUESTION # 44
How can you change the Default Aggregation for a measure in Tableau?

• A. By double clicking on the measure, and then choosing Window -> Default Aggregation
• B. By changing its properties manually every time we need to use it
• C. By right clicking the measure -> Default properties and choosing Aggregation
• D. By right clicking the dimension -> Default properties and choosing Aggregation

Answer: A

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 # 45
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 # 46
Which of the following is a benefit of using a Tableau Data Source (.tds)?

• A. To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc
• B. To hold one or more worksheets, plus zero or more dashboards and stories.
• C. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
• D. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

Answer: A

Explanation:
Explanation
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
3) Extract (.hyper or .tde) - To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
3) (.twb) Workbooks - To hold one or more worksheets, plus zero or more dashboards and stories.

NEW QUESTION # 47
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

• A. Unioning
• B. Combining
• C. Joining
• D. Blending

Answer: A

Explanation:
Explanation
Unioning is the correct answer!
From the official documentation:

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."

NEW QUESTION # 48
Larger image

What is this entire view referred to as in Tableau?

• A. Summary Pane
• B. Data pane
• C. Analytics Pane
• D. Distribution Pane

Answer: C

Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:

NEW QUESTION # 49
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

• A. Data Blending
• B. Data segregation
• C. Data Joining
• D. Union

Answer: A

Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

NEW QUESTION # 50
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

• A. 3.500
• B. 3.000
• C. 3.704
• D. 3.840

Answer: C

Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

NEW QUESTION # 51
Which one of the following is a dimension?

• A. Number of records
• B. Measure Names
• C. Latitude
• D. Longitude

Answer: B

Explanation:
Explanation
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.

NEW QUESTION # 52
True or False: Context Filters are executed after Data Source filters

• A. True
• B. False

Answer: A

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

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

Answer: C

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 # 54
The icon associated with the field that has been grouped is a ______________

• A. =#
• B. Paper Clip
• C. Globe
• D. Intersection

Answer: B

Explanation:
Explanation
You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

NEW QUESTION # 55
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 a measure or axis 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: C

Explanation:
Explanation
According to the official Tableau documentation:

NEW QUESTION # 56
Which of the following is a good reason for using a bullet graph?

• A. Analysing the trend over a given time period
• B. Displaying the year-on-year growth in sales
• C. Forecasting future sales
• D. Comparing the actual sales against the target sales

Answer: D

Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

NEW QUESTION # 57
True or False: It is possible to add a field to more than one hierarchy

• A. True
• B. False

Answer: A

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 # 58
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

• A. .twbx file
• B. .tbm file
• C. .twb file
• D. .tde file

Answer: A

Explanation:
Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks.

NEW QUESTION # 59
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 dimension to the row/column shelf
• C. When we drag a discrete field to the row/column shelf
• D. When we drag a measure 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 # 60
......

Get Latest Desktop-Specialist Dumps Exam Questions in here: https://pass4sure.dumptorrent.com/Desktop-Specialist-braindumps-torrent.html