Latest 2023 Realistic Verified Desktop-Specialist Dumps - 100% Free Desktop-Specialist Exam Dumps
Get 2023 Updated Free Tableau Desktop-Specialist Exam Questions and Answer
The exam is suitable for individuals who want to demonstrate their expertise in using Tableau Desktop and for organizations that want to ensure that their employees are proficient in using the software. The exam covers various topics related to Tableau Desktop, including data connection, data preparation, analysis, visualization, and collaboration. The questions are designed to test the knowledge and skills of individuals in each of these areas.
Tableau Desktop Specialist Certification Exam is a professional certification for individuals who want to demonstrate their proficiency in using Tableau Desktop. The certification exam is designed to test the candidate's knowledge of Tableau Desktop's basic functionality, including data preparation, visualization creation, and dashboard building. In this exam, candidates will be evaluated on their ability to use Tableau Desktop to connect to data sources, create visualizations, and perform data analysis.
Tableau Desktop-Specialist (Tableau Desktop Specialist) Certification Exam is a professional certification that validates an individual's expertise in using Tableau Desktop software. Tableau is a powerful tool used for data visualization and business intelligence. This certification exam assesses the candidate's ability to use Tableau to connect, analyze, and visualize data, build dashboards, and create data stories.
NEW QUESTION # 70
Which of the following chart type makes use of 'binned' data?
- A. Bullet chart
- B. Gantt Chart
- C. Histogram
- D. Treemaps
Answer: C
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
NEW QUESTION # 71
What term is used to describe the following picture?
- A. Hierarchy
- B. Group
- C. Parameter
- D. Set
- E. Larger image
Answer: D
Explanation:
Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
NEW QUESTION # 72
True or False: To concatenate fields, they must be of same data type
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use
- Type casting. See below:
Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!
NEW QUESTION # 73
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?
- A. If we want to interact with the visualisation.
- B. If we want to use filters in the visualisation.
- C. If we want to dynamically enter parameters to 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 # 74
Which of the following are interactive elements that can be added to a dashboard for users?
- A. Filter Action
- B. Highlight Action
- C. URL Action
- D. Edit Tooltip Action
Answer: B,C,D
Explanation:
Explanation
We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:
NEW QUESTION # 75
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,222
- D. 1,461
Answer: A
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 # 76
Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :
2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:
3) Finally, click on the Show mark Labels icon:
4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:
NEW QUESTION # 77
Which of the following are the options to export the data used to build the view / visualisations?
- A. PDF File
- B. MS Access Database
- C. CSV file
- D. JSON format
Answer: B
Explanation:
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
NEW QUESTION # 78
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Portable Network Graphic (.PNG)
- B. Tagged Image File Format (TIFF)
- C. JPEG Image (.JPG, .JPEG)
- D. Windows Bitmap (.BMP)
Answer: A,C,D
Explanation:
Explanation
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
NEW QUESTION # 79
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Default, Phone, Tablet, Desktop
- B. Phone, Tablet, Laptop, Desktop
- C. Monitor, Default, Phone, Tablet
- D. Phone, Monitor, Laptop, Default
Answer: D
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION # 80
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Union
- B. Grouping
- C. Sets
- D. Clustering
Answer: D
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 # 81
When is an axis created for the visualisation in Tableau?
- A. When we drag a discrete field to the row/column shelf
- B. When we drag a dimension to the row/column shelf
- C. When we drag a measure to the row/column shelf
- D. When we drag a continuous field to the row/column shelf
Answer: D
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 # 82
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
- A. Tableau Workbook (.twb)
- B. Tableau Packaged Workbook (.twbx)
- C. Tableau Data Extract (.tde)
- D. Tableau Bookmark (.tbm)
Answer: B
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 # 83
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Measures
- C. Dimensions
- D. Groups
Answer: A,B
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 # 84
How does Tableau know at which level to aggregate values?
- A. Values are always aggregated at the level of granularity of the worksheet.
- B. Tableau doesn't aggregate values, we do!
- C. Values are always aggregated at the level of the Date Part
- D. Aggregation is always done by using Tableau special formulas
Answer: A
Explanation:
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:
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. September
- B. July
- C. June
- D. October
Answer: D
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
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 # 87
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 5,000
- B. 15,000
- C. 10,000
- D. 20,000
Answer: C
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 # 88
The row and column shelves contain ___________________
- A. Parameters
- B. Pills
- C. Grand Totals
- D. Filters
Answer: B
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 # 89
Which of the following are valid ways to add Totals to a view?
- A. Using the Data Pane
- B. From the Analysis Tab in the Menu bar on top
- C. Using the Analytics Pane
- D. Using the Marks shelf
Answer: B,C
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 # 90
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Multiple Values (dropdown)
- B. Regex Match
- C. Wildcard Match
- D. Single Value (slider)
Answer: B
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION # 91
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. June
- D. October
Answer: D
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:
NEW QUESTION # 92
......
Desktop-Specialist Dumps PDF and Test Engine Exam Questions: https://www.prep4sureexam.com/Desktop-Specialist-dumps-torrent.html
Get New Desktop-Specialist Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1MRrsbZV8Q8zRdEyHSDUd38hbdjmKl_gp