Pass Authentic Tableau Desktop-Specialist with Free Practice Tests and Exam Dumps
New Desktop-Specialist Exam Questions Real Tableau Dumps
NEW QUESTION # 134
True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.
- A. False
- B. True
Answer: B
Explanation:
Yes! We get different color palettes. They are:
*From the official Tableau documentation*
To change the color for a value
1) Click on an item on the left, under Select Data Item.
2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color.
3) Repeat for as many values that you want to change.
4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box.
AND
NEW QUESTION # 135
How can you change the default Tableau repository location?
- A. By clicking on Help -> Change Repository Location
- B. By Moving the repository location manually to wherever we want
- C. By clicking on File -> Repository Location and choosing a new location
- D. By clicking on Window -> Repository Location
Answer: B
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 136
Which of the following situations describe the best reason to use a union?
- A. You have two tables with similarly named columns of data that you want to combine.
- B. You have two data sets with similar data types for which you want to find only distinct values.
- C. You have two data sets saved in different formats that you want to unify into a single format.
- D. You have two tables with differently named columns of data that you want to combine.
Answer: A
Explanation:
You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2
NEW QUESTION # 137
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
- A. Tableau myServer
- B. Tableau Server
- C. Tableau Public
- D. Tableau Prep
Answer: A
Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
NEW QUESTION # 138
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Orange, Blue
- C. Blue, Orange
- D. Red, Blue
Answer: C
Explanation:
Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:
NEW QUESTION # 139
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. October
- B. June
- C. September
- D. July
Answer: A
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 # 140
What is a story point in Tableau?
- A. A collection of dashboards
- B. A collection of both worksheets and dashboards
- C. A collection of worksheets
- D. A single worksheet or dashboard
Answer: D
Explanation:
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.
NEW QUESTION # 141
Data blending simulates a traditional _________________ Join
- A. Inner
- B. Left
- C. Right
- D. Full Outer
Answer: B
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 # 142
What are three geographic roles that you can assign to a field? Choose three.
- A. Airport
- B. Address
- C. City
- D. Country
- E. Time zone
Answer: A,C,D
Explanation:
According to the Tableau Desktop Specialist Exam Guide, city, country, and airport are three geographic roles that you can assign to a field. Address and time zone are not geographic roles in Tableau.
NEW QUESTION # 143
Which of the following are valid ways to export a dashboard with multiple visualisations as an image?
- A. using the floating export worksheet option on the Dashboard
- B. Right click on the dashboard, and choose Copy, then image.
- C. Click on Worksheet in the Menu bar followed by Export, then choose Image
- D. Click on Dashboard in the Menu bar followed by Copy Image
Answer: D
Explanation:
Only 1 option is correct -
Click on Dashboard in the Menu bar followed by Copy Image
Right click on the dashboard, and choose Copy, then image - Try doing this, you will end up copying just one of the worksheets not the entire dashboard Click on Worksheet in the Menu bar followed by Export, then choose Image - Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard Using the floating export worksheet option on the Dashboard - No such option exists
NEW QUESTION # 144
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. October
- B. June
- C. September
- D. July
Answer: A
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 # 145
You have a visualization that uses multiple types of sorting.
How can you clear all sorting of the visualization?
- A. Right-click a sorted field, and then select Clear Sort.
- B. From the Header label, select the sort icon.
- C. From the Dashboard menu, select Clear.
- D. From the Worksheet menu, select Clear, and then select Sorts.
Answer: D
Explanation:
To clear all sorting in a Tableau visualization, you would go to the Worksheet menu, select the "Clear" option, and then choose "Sorts." This action removes all sorting that has been applied to the visualization, including any custom sorting or sorting based on multiple fields. This is a quick way to reset the view to its default sorting state and is particularly useful when you have applied various sorting layers and wish to start fresh.
NEW QUESTION # 146
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. False
- B. True
Answer: B
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 # 147
For a relative date filter, the default anchor is _________________
- A. The current time
- B. The target date
- C. The date we specify
- D. Today's date
Answer: D
Explanation:
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
NEW QUESTION # 148
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 # 149
True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.
- A. True
- B. False
Answer: B
Explanation:
In fact, the opposite of this is true.
Trick : Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.
If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!
Refer to logical layer vs physical layer from the official
documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm
NEW QUESTION # 150
Which of the following are valid Dashboard size options?
- A. Range
- B. Automatic
- C. Scaled
- D. Fixed Size
Answer: A,B,D
Explanation:
Scaled is NOT a valid size options when creating Dashboards in Tableau!
After you create a dashboard, you might need to resize and reorganize it to work better for your users.
NEW QUESTION # 151
Which of the following describes the best way to change the formatting at a workbook level?
- A. It is only possible to specify formatting at a worksheet level, not at the workbook level.
- B. Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.
- C. Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.
- D. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.
Answer: D
Explanation:
It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.
You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level.
For example, you might want to use a specific font, size, and color so that all views adhere to your company's brand. You might also want to remove grid lines from your views-or make them more noticeable by increasing their pixel size or color.
You can also change the theme used by your workbook. Themes control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.
Change fonts in your workbook:
You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.
1) On the Format menu, select Workbook.
2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.
Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.
Reset a workbook to its default settings
When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.
1) On the Format menu, select Workbook.
2) In the Format Workbook pane, click Reset to Defaults.
Graphical user interface, application Description automatically generated
NEW QUESTION # 152
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A. In My Computer -> C: -> Tableau -> Shapes
- B. In My Documents -> My Tableau Repository -> Shapes
- C. In Downloads -> My Tableau Repository -> Shapes
- D. In Program Files -> Tableau -> Shapes
Answer: B
Explanation:
Here's how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.
NEW QUESTION # 153
You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.
Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?
- A. 2 before and 11 after
- B. 1 before and 2 after
- C. 1 before and 12 after
C 1 before and 11 after
Answer: A
Explanation:
In Tableau, when you initially add a measure to the rows shelf, you create one mark in the view that represents the aggregate value of that measure. When you then add a dimension with 11 members to the columns shelf, the view is subdivided into 11 separate marks, each representing the measure for one of the dimension members. This results in a total of 11 marks in the view after the dimension is added, one for each member of the dimension.
NEW QUESTION # 154
You have the following visualization.
Where should you place a field named Region to show multiple distinct lines on the same axis?
- A. Color on the Marks card
- B. The Columns shelf
- C. Path on the Marks card
- D. The Rows shelf
Answer: A
Explanation:
To display multiple distinct lines on the same axis based on a field, you should place the field on the Color shelf in the Marks card. This will encode each distinct value in the Region field with a different color, resulting in separate lines for each region on the same axis.
NEW QUESTION # 155
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Topological
- B. Manual
- C. Hierarchical
- D. Random
Answer: B
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 # 156
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 a static view of the visualisation.
- C. If we want to interact with the visualisation.
- D. If we want to dynamically enter parameters to the visualisation.
Answer: B
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 # 157
Which of the following is an example of a Date Part?
- A. November
- B. September 2020
- C. March 2019
- D. Q4 2017
Answer: A
Explanation:
All answers except November are examples of Date Values (continuous in nature).
See below:
You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).
All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!
NEW QUESTION # 158
......
Desktop-Specialist Exam Info and Free Practice Test Professional Quiz Study Materials: https://www.passtestking.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Course 2025 Desktop-Specialist Test Prep Training Practice Exam Download: https://drive.google.com/open?id=1PCjQ_KUYq-viW8v7EBKbzmJp0JimFAhi