First Attempt Guaranteed Success in Desktop-Specialist Exam 2023
Real Desktop-Specialist Exam Questions are the Best Preparation Material
What is the duration, language, and format of Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
- Duration of Exam: 130 minutes
- Number of Questions: 65
- Language Exam: English, Japanese, Korean.
- Type of Questions: Multiple choice (MCQs), multiple answers
How much Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Cost
The cost of the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is $150. For more information related to exam prices, please visit the official website Tableau Website as the cost of exams may be subjected to vary county-wise.
NEW QUESTION 56
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. .twb file
- B. .tbm file
- C. .twbx file
- D. .tde file
Answer: C
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 57
True or False : Bins can be created on dimensions
- A. False
- B. rue
Answer: B
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 58
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.5s
- B. 0.2s
- C. 0.3s
- D. 0.4s
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 59
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?
- A. Context Filter
- B. Data source Filter
- C. None of the these
- D. Extract Filter
Answer: A
Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
NEW QUESTION 60
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
- A. Sets
- B. Groups
- C. Calculation
- D. Parameters
Answer: D
Explanation:
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -
NEW QUESTION 61
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A. False
- B. True
Answer: B
Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
NEW QUESTION 62
What is the following icon in the Data pane used to do?
Larger image
- A. View Data
- B. Clean Data
- C. Extract Data
- D. Sort Data
Answer: A
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 63
How can you format numbers in Tableau as currency?
- A. Right-click a measure or axis in the view 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 Sheet name 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: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 64
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 65
Larger image
What is this entire view referred to as in Tableau?
- A. Data pane
- B. Summary Pane
- C. Distribution Pane
- D. Analytics Pane
Answer: D
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 66
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 1 , 4
- B. 2 , 2
- C. 2 , 3
- D. 1 , 2
Answer: A
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 67
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 10,000
- B. 15,000
- C. 5,000
- D. 20,000
Answer: A
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 68
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 69
The row and column shelves contain ___________________
- A. Filters
- B. Grand Totals
- C. Parameters
- D. Pills
Answer: D
Explanation:
Explanation
We can drag fields from the Data pane to create the structure for your visualizations.
The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
These FIELDS are also referred to as PILLS. See below:
NEW QUESTION 70
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Penelope Sewall
- B. Tamara Chand
- C. Tom Ashbrook
- D. Sanjit Engle
Answer: A
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION 71
How do you identify a continuous field in Tableau?
- A. It is preceded by a 'Abc' symbol in the data window
- B. It is identified by a blue pill in the visualization
- C. It is identified by a green pill in a visualization
- D. It is preceded by a '=#' symbol in the data window
Answer: D
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 72
What does the following icon do in Tableau?
Larger image
- A. Create a Story
- B. Create a Worksheet
- C. Create a Story and Dashboard both
- D. Create a Dashboard
Answer: D
Explanation:
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION 73
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Packaged Workbook (.twbx)
- B. Tableau Data Extract (.tde)
- C. Tableau Bookmark (.tbm)
- D. Tableau Workbook (.twb)
Answer: A
Explanation:
Explanation
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)
NEW QUESTION 74
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. 65.67
- B. 68.77
- C. 4.87
- D. 76.25
Answer: D
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 75
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Packaged Workbook (.twbx)
- B. Tableau Data Extract (.tde)
- C. Tableau Data Source (.tds)
- D. Tableau Workbook (.twb)
Answer: B
Explanation:
Explanation
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
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.
NEW QUESTION 76
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Phone, Tablet, Laptop, Desktop
- B. Monitor, Default, Phone, Tablet
- C. Phone, Monitor, Laptop, Default
- D. Default, Phone, Tablet, Desktop
Answer: C
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION 77
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. 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.
- 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 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
Answer: D
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 78
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 79
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Random
- B. Topological
- C. Manual
- D. Hierarchical
Answer: C
Explanation:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
NEW QUESTION 80
Which of the following can you add a reference line to?
- A. Groups
- B. Dimensions
- C. Measures
- D. Calculated Fields
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 81
......
How to Prepare For Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
Preparation Guide for Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
Introduction
IT professionals receive Tableau certificates to show and verify expertise and capabilities in the technical cloud. For cloud developers, managers and builders, Tableau offers various qualification tests. Tableau certification lasts for two years, and after it expires, IT professionals can recertify their particular certification. The Tableau Desktop-Specialist practice exams are offered in hundreds of research centers around the nation.
Tableau Certification validates cloud experience in order to improve demand skills and develop creative, successful teams for Tableau cloud projects. If you are a cloud specialist or a transferor from on-site solutions, this qualification provides you with a strong foundation to develop your cloud infrastructure skills and trains you for more advanced aspects of Tableau.
This guide offers a comprehensive description of Tableau Solutions Architect Technical qualification including different criteria for evaluation, examination style, subjects addressed, examination issues and approaches for training, and a target audience profile. Therefore, we design a range of Tableau Desktop-Specialist exam dumps pdf when knowing the student requirements. Our subjects, such as the study guide, help students complete exams.
Practice LATEST Desktop-Specialist Exam Updated 150 Questions: https://buildazure.actualvce.com/Tableau/Desktop-Specialist-valid-vce-dumps.html