Printable & Easy to Use Desktop-Specialist Dumps 100% Same Q&A In Your Real Exam
Desktop-Specialist Practice Test Give You First Time Success with 100% Money Back Guarantee!
Tableau Desktop Specialist Exam is a certification program designed for individuals who want to demonstrate their proficiency in using Tableau Desktop. Tableau is a leading data visualization software used by businesses, organizations, and individuals to analyze and present data in a visually appealing and easy-to-understand way. The Tableau Desktop Specialist Exam is an industry-recognized certification that validates your skills and knowledge in using Tableau to create impactful visualizations, dashboards, and reports.
Tableau Desktop Specialist exam consists of multiple choice and hands-on questions that assess the candidate's ability to use Tableau Desktop to create interactive dashboards, reports, and visualizations. Desktop-Specialist exam covers topics such as data preparation, data connection, data blending, calculations, and mapping.
Tableau Desktop-Specialist exam is a globally recognized certification that is highly valued by employers. It is an excellent way for professionals to demonstrate their expertise in data analysis and visualization using Tableau Desktop. Passing Desktop-Specialist exam can help professionals enhance their career prospects, increase their earning potential, and gain recognition in their industry. Tableau Desktop Specialist Exam certification is valid for three years, after which the candidate needs to renew it by taking another exam or completing a certification project.
NEW QUESTION # 74
Which statement accurately describes a join?
- A. A combination of columns appended from different tables that have similar values
- B. Away to combine multiple Tableau workbooks using similar data sources
- C. Away to combine table columns in relational databases by using shared values
- D. A combination of rows appended from different tables that have the same column names
Answer: C
Explanation:
According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.
NEW QUESTION # 75
Which of the following are valid Layout Container types when using Dashboards in Tableau?
- A. Horizontal Container
- B. Split Container
- C. Diagonal Container
- D. Vertical Container
Answer: A,D
Explanation:
Chart Description automatically generated
NEW QUESTION # 76
Which of the following is an example of a Date Part?
- A. Q4 2017
- B. September 2020
- C. March 2019
- D. November
Answer: D
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 # 77
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins
- A. Union
- B. Data segregation
- C. Data Joining
- D. Data Blending
Answer: D
Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.
According to the official Tableau Documentation:
To read more about Data Blending, click on THIS link.
NEW QUESTION # 78
DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!
2) Or, you can simply go to Data Source -> Country Tab -> Describe
As you can see, 147 members exist in this Country column!
NEW QUESTION # 79
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 # 80
Which of the following is a valid way to create Sets in Tableau?
- A. In the Tableau Main Menu, Choose Worksheet and select Create > Set
- B. In the Data pane, right-click a measure and select Create > Set.
- C. In the Data pane, right-click a dimension and select Create > Set.
- D. In the Tableau Main Menu, choose Dashboard and select Create > Set
Answer: C
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 # 81
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
- A. 23.497%
- B. 25.683%
- C. 22.404%
- D. 28.415%
Answer: C
Explanation:
Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:
NEW QUESTION # 82
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. June
- B. September
- C. October
- D. July
Answer: C
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 # 83
What does the following marker/icon do in Tableau?
- A. Highlight the largest value
- B. Format the Legends
- C. Toggle the highlighting on/off.
- D. Edit the Colors
Answer: C
Explanation:
Top of Form
The correct answer is Toggle the highlighting ON/OFF. If selected, whichever value you choose from this legend will be highlighted in the view. However, if it is deselected, then even if you choose a value in the Legend, it will NOT be highlighted.
See below:
Chart, bar chart Description automatically generated
Chart, bar chart Description automatically generated
Bottom of Form
NEW QUESTION # 84
Which of the following are true about Dashboards in Tableau?
- A. Floating items can be layered over other objects
- B. None of these
- C. Tiled items don't overlap
- D. A bar chart can be used a floating item
Answer: A,C,D
Explanation:
From the official Tableau documentation:
As we can see below, Bar charts can be used as a floating object.
NEW QUESTION # 85
A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
- A. Go to Sheet
- B. Go to Web page
- C. Go to Hyperlink
- D. Go to URL
Answer: D
Explanation:
Tricky options! Go to hyperlink and Go to Web page are not valid Actions in Tableau.
A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.
Graphical user interface, text, application, Word Description automatically generatedGraphical user interface, text, application, email Description automatically generatedGraphical user interface, text, application, Word Description automatically generatedText, letter Description automatically generated
NEW QUESTION # 86
Which statement accurately describes an extract when the Physical Tables option is selected?
- A. All the data is tolled up to the current visible fields.
- B. Data is limited to only the Top N of data for the connection.
- C. An individual table is created for each physical table in the extract.
- D. Data shown in the Data pane is separated based on the table type.
Answer: C
Explanation:
When the Physical Tables option is selected for an extract in Tableau, an individual table is created for each physical table in the extract. This means that the extract will include a separate table for each underlying table in your database, maintaining the database's structure within the extract. This can be useful when you need to preserve the original granularity of the data or when working with certain database optimizations.
NEW QUESTION # 87
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of orders shipped between these dates
- B. Number of days between these dates
- C. Number of unique orders placed between these dates
- D. Number of orders placed in that duration
Answer: B
Explanation:
Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.
NEW QUESTION # 88
What are three ways to access bolding options for the text in a tooltip? Choose three.
- A. Select Worksheet on the menu, and then select Tooltip
- B. Hover over a mark and press ALT+F.
- C. Hover over a mark and press CTRL+B.
- D. Right-click on the Field and select Format.
- E. Select Format on the menu, and then select Font
- F. Select Tooltip on the Marks card.
Answer: A,D,F
Explanation:
To access bolding options for the text in a tooltip in Tableau, you can:
Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.
Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.
Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.
NEW QUESTION # 89
Which of the following describes the best way to change the formatting at a workbook level?
- A. Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.
- B. Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.
- C. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.
- D. It is only possible to specify formatting at a worksheet level, not at the workbook level.
Answer: C
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 # 90
_____________ 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:
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 # 91
When creating a date filter in Tableau, to what does Anchor refer?
- A. The date in a range-of-dates filter to which you anchor units of time.
- B. The mid-point in the range of displayed dates.
- C. The date in a relative-date filter to which you anchor a unit of time.
- D. The latest date in the data source that can be found.
Answer: C
Explanation:
When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2
NEW QUESTION # 92
What should you use to apply bold text formatting to rows or columns independent of each other?
- A. The Field Format Font pane
C The Rows tab or the Columns tab on the Format Font pane - B. Text on the Marks card
- C. The Sheets tab on the Format Font pane
Answer: C
Explanation:
To apply bold text formatting to rows or columns independently in Tableau, you should use the Rows tab or the Columns tab on the Format Font pane. This approach provides control over the formatting of text within individual rows or columns. By selecting the appropriate tab (Rows or Columns), you can apply formatting settings, including bold text, to only the selected rows or columns. This is a crucial feature for enhancing the readability and visual appeal of specific parts of a Tableau worksheet, allowing for emphasis on particular data points or categories.
NEW QUESTION # 93
Which of the following are true about dimensions?
- A. They contain qualitative values (such as names, dates, or
geographical data) - B. Dates are mostly placed in dimensions by default for relational data sources
- C. They contain contain numeric, quantitative values
- D. They affect the level of detail in the view
Answer: A,B,D
Explanation:
Measures contain numeric quantitative values hence that option is incorrect.
Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm
NEW QUESTION # 94
Which of the following points are True about Viz Animations?
- A. They can be turned on for certain worksheets only
- B. It is possible to turn them on for the entire workbook at once
- C. Sequential animations take more time but make complex changes
clearer by presenting them step-by-step - D. Animations work well with maps, polygons, and density marks in web
browsers
Answer: A,B,C
Explanation:
All of the given options are true except - Animations work well with maps, polygons, and density marks in web browsers.
From the official documentation:
As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
NEW QUESTION # 95
Is it possible to make a Measure discrete?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:
Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!
NEW QUESTION # 96
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Numbers and Headers
- B. Rows and Columns
- C. Labels and Values
- D. Dimensions and Measures
Answer: D
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.
Further,
NEW QUESTION # 97
True or False: All rows from both tables are returned in an INNER JOIN
- A. False
- B. True
Answer: A
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 # 98
......
Fully Updated Free Actual Tableau Desktop-Specialist Exam Questions: https://www.realvalidexam.com/Desktop-Specialist-real-exam-dumps.html
All Obstacles During Desktop-Specialist Exam Preparation with Desktop-Specialist Real Test Questions: https://drive.google.com/open?id=1Yr9ZDIgqTXdQNaEP6NnGPA71Xgt6Dc0x
