Study HIGH Quality Desktop-Specialist Free Study Guides and Exams Tutorials [Q48-Q63]

Desktop-Specialist Tableau

admin • January 13, 2024

Study HIGH Quality Desktop-Specialist Free Study Guides and Exams Tutorials [Q48-Q63]

5/5 - (1 vote)

Study HIGH Quality Desktop-Specialist Free Study Guides and Exams Tutorials

Download Tableau Desktop-Specialist Exam Dumps to Pass Exam Easily

Q48. According to Tableau’s ‘Order of Operations’, which of the following filters is applied FIRST?

Dimension Filter

Measure Filter

Context Filter

Extract Filter

Explanation
According to Tableau’s order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:

Q49. Larger image

What is this entire view referred to as in Tableau?

Data pane

Analytics Pane

Summary Pane

Distribution Pane

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

Q50. Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Marks Card

Data Pane

Filter Shelf

Analytics Pane

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.

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

96.46%

95.12%

97.12%

99.46%

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 :

Q52. What is a story point in Tableau?

A single worksheet or dashboard

A collection of dashboards

A collection of both worksheets and dashboards

A collection of worksheets

Explanation
In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.

Q53. In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

top left bottom left

top right, bottom right

top left, bottom right

top right, bottom left

Explanation
Tree maps size begins from maximum in top left to smallest in bottom right.

See below to learn how to create a TreeMap and add colours to it:

Q54. Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Profit, State, Number of Records, Sales

Region, Country, Profit, State

Longitude, Country, State, Sales

Sales, State, Country, Profit

Explanation
Since Sales is a measure, it can easily be depicted via size.
To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.
Finally, the Profit can be depicted via a color! Eg – Red for poor and green for excellent profits!

Q55. What is the minimum amount of RAM recommended for any production use of Tableau Server?

8GB

16GB

32GB

64GB

Explanation
The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.
These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

Q56. Which of the following are valid ways to trigger actions for a Dashboard?

Hover

Click

Select

Double click

Explanation
Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:
1) Select
2) Hover
3) Menu
Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

Q57. Which of these is NOT a type of Quick Filter available in Tableau?

Wildcard Match

Multiple Values (dropdown)

Regex Match

Single Value (slider)

Explanation
Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

Q58. _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Tableau Packaged Workbook (.twbx)

Tableau Workbook (.twb)

Tableau Data Extract (.tde)

Tableau Data Source (.tds)

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.

Q59. Which one of the following is a dimension?

Longitude

Measure Names

Number of records

Latitude

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

Q60. Which of the following are benefits of using Data Extracts in Tableau?

Improved Performance

Ability to use the data offline

Working with freshest data at all times

Faster to work with

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!

Q61. When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Portable Network Graphic (.PNG)

JPEG Image (.JPG, .JPEG)

Tagged Image File Format (TIFF)

Windows Bitmap (.BMP)

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.

Q62. True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

True

False

Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

Q63. Which of the following are the options to export the data used to build the view / visualisations?

CSV file

PDF File

JSON format

MS Access Database

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.

Loading …

Tableau Desktop-Specialist certification exam is designed for individuals who seek to demonstrate their proficiency in using Tableau Desktop. It is an entry-level certification exam that covers basic concepts of Tableau Desktop, including connecting to data sources, creating visualizations, and sharing insights. Desktop-Specialist exam requires you to demonstrate your knowledge of Tableau Desktop by using it to solve real-world scenarios.

Tableau Desktop Specialist Certification Exam is a globally recognized certification exam for individuals who aspire to become Tableau Desktop Specialists. Tableau Desktop is a powerful data visualization tool that helps businesses make informed data-driven decisions. Tableau Desktop Specialist Exam certification exam validates the skills and knowledge of the individuals in using Tableau Desktop to connect, analyze and visualize data. Desktop-Specialist exam measures the skills in using Tableau Desktop to create visualizations, organize data, and share insights.

Get 100% Real Free Tableau Desktop Specialist Desktop-Specialist Sample Questions: https://www.2pass4sure.com/Tableau-Desktop-Specialist/Desktop-Specialist-actual-exam-braindumps.html