2023 Desktop-Specialist Question Bank: Free PDF Download Recently Updated Questions
Desktop-Specialist Certification Exam Dumps with 150 Practice Test Questions
NEW QUESTION # 73
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Measure Names
- C. Number of Records
- D. Calculated Fields
Answer: A,B
Explanation:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
NEW QUESTION # 74
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Marks Card
- C. Data Pane
- D. Analytics Pane
Answer: B
Explanation:
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.
NEW QUESTION # 75
True or False: All rows from both tables are returned in an INNER JOIN
- A. True
- B. False
Answer: B
Explanation:
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
NEW QUESTION # 76
By definition, Tableau displays measures over time as a ____________
- A. Stacked Bar
- B. Line
- C. Bar
- D. Packed Bubble
Answer: B
Explanation:
Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:
NEW QUESTION # 77
Which of the following is a valid way to create Sets in Tableau?
- A. In the Tableau Main Menu, choose Dashboard and select Create > Set
- B. In the Data pane, right-click a dimension and select Create > Set.
- C. In the Tableau Main Menu, Choose Worksheet and select Create > Set
- D. In the Data pane, right-click a measure and select Create > Set.
Answer: B
Explanation:
Explanation
There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:
1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:
General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.
None of the other options exist, and therefore are incorrect answers.
NEW QUESTION # 78
When is an axis created for the visualisation in Tableau?
- A. When we drag a dimension to the row/column shelf
- B. When we drag a continuous field to the row/column shelf
- C. When we drag a measure to the row/column shelf
- D. When we drag a discrete field to the row/column shelf
Answer: B
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 # 79
Which of the following returns the Absolute Value of a given number?
- A. ABS(Number)
- B. ZN(Number)
- C. FLOOR(Number)
- D. CEILING(Number)
Answer: A
Explanation:
Explanation
From the official Tableau website:
NEW QUESTION # 80
Data blending simulates a traditional _________________ Join
- A. Right
- B. Left
- C. Full Outer
- D. Inner
Answer: B
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 # 81
Which of the following chart type makes use of 'binned' data?
- A. Treemaps
- B. Histogram
- C. Gantt Chart
- D. Bullet chart
Answer: B
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 # 82
You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?
- A. Save it as a .twm file
- B. Save it as a .twb file
- C. Save it as a .twbx file
- D. Save it as a .tds file
Answer: D
Explanation:
Explanation
After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: Data source files do 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, adding groups, and so on.
twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.
NEW QUESTION # 83
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A. Trick question! It is not possible to group by labels.
- B. The colours of the members selected are now the same, and different for the rest of the members.
- C. A new mark (bar) is created, which consolidates all members of the group.
- D. Nothing changes in the view, but a group is created in the Dimensions shelf.
Answer: C
Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
NEW QUESTION # 84
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.
- A. True
- B. False
Answer: A
Explanation:
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.
NEW QUESTION # 85
True or False: Tableau can create worksheet-specific filters
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes, it is possible to create worksheet-specific filters in Tableau.
When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.
Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.
NEW QUESTION # 86
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color
- A. Sales, State, Country, Profit
- B. Longitude, Country, State, Sales
- C. Region, Country, Profit, State
- D. Profit, State, Number of Records, Sales
Answer: A
Explanation:
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!
NEW QUESTION # 87
The icon associated with the field that has been grouped is a ______________
- A. =#
- B. Globe
- C. Intersection
- D. Paper Clip
Answer: D
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 # 88
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 # 89
If you see the following Filter, then you're working with _______________________ Larger image
- A. Grouped Dates
- B. Date Parts
- C. Date Functions
- D. Date Values
Answer: D
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 # 90
True or False: To concatenate fields, they must be of same data type
- A. True
- B. False
Answer: A
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 # 91
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A. To support additional functionality such as count distinct
- B. Fast to create
- C. Help improve performance
- D. To have access to the freshest possible data at all times
Answer: A,B,C
Explanation:
Explanation
From the official documentation, the following are the major advantages of using Tableau Data Extracts:
From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
NEW QUESTION # 92
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Grouping
- B. Clustering
- C. Sets
- D. Union
Answer: B
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 # 93
......
To take the exam, individuals must have a good understanding of Tableau Desktop and its features. They should be familiar with the different data sources that Tableau Desktop supports and should be able to connect to and prepare data for analysis. They should also be able to create visualizations and dashboards that effectively communicate insights and trends in the data.
Tableau Desktop-Specialist Certification Exam is designed for those who want to enhance their skills in data visualization and analysis using Tableau Desktop. This certification exam is globally recognized and helps professionals validate their proficiency in Tableau Desktop. Tableau Desktop is a powerful data visualization tool that helps businesses make informed decisions by analyzing complex data sets. By earning this certification, professionals can demonstrate their expertise in using Tableau Desktop and add value to their organization.
New Desktop-Specialist Exam Dumps with High Passing Rate: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html
Tableau Desktop-Specialist Actual Questions and Braindumps: https://drive.google.com/open?id=1V8Px4nHa89eIhDnPfz7uVsCuJZH3N08o