2023 Latest 100% Exam Passing Ratio - Desktop-Specialist Dumps PDF
Pass Exam With Full Sureness - Desktop-Specialist Dumps with 150 Questions
NEW QUESTION # 86
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of days between these dates
- B. Number of unique orders placed between these dates
- C. Number of orders shipped between these dates
- D. Number of orders placed in that duration
Answer: A
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 # 87
What term is used to describe the following picture?
- A. Parameter
- B. Set
- C. Group
- D. Larger image
- E. Hierarchy
Answer: B
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 # 88
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. 28.415%
- B. 22.404%
- C. 25.683%
- D. 23.497%
Answer: B
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 # 89
What will the following function return?
LEFT("Tableau", 3)
- A. Tab
- B. ble
- C. eau
- D. An error
Answer: D
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION # 90
You can use the __________________ in Tableau to clean / organise your data.
- A. Data organiser
- B. Data interpreter
- C. Data manager
- D. Data cleaner
Answer: B
Explanation:
Explanation
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.
NEW QUESTION # 91
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.
- A. Wildcard Search
- B. Regex Search
- C. Pattern Search
- D. Union Search
Answer: A
Explanation:
Explanation
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.
NEW QUESTION # 92
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
- A. top left bottom left
- B. top left, bottom right
- C. top right, bottom left
- D. top right, bottom right
Answer: C
Explanation:
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:
NEW QUESTION # 93
Which of the following can you add a reference line to?
- A. Groups
- B. Dimensions
- C. Measures
- D. Calculated Fields
Answer: C,D
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 # 94
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION # 95
True or False: Sets can be created on Measures
- A. False
- B. True
Answer: A
Explanation:
Explanation
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source.
They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.
Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/
NEW QUESTION # 96
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 # 97
True or False: It is possible to change the Geographic Role of a dimension
- A. False
- B. True
Answer: B
Explanation:
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
NEW QUESTION # 98
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on Analysis in the Menu bar and choose Show Mark Labels
- B. Click on the Show mark labels icon in the Toolbar
- C. Drag the measure to the Text label in the Marks Card
- D. Click on Data in the Menu bar and Choose Show Mark Labels
Answer: A,B,C
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION # 99
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Double click
- B. Click
- C. Hover
- D. Select
- E. Menu
Answer: C,D,E
Explanation:
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)
NEW QUESTION # 100
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity
- A. False
- B. True
Answer: B
Explanation:
Explanation
Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.
To disaggregate all measures in the view:
Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.
NEW QUESTION # 101
If you have a dashboard and are displaying its filter, how can you rearrange it?
- A. By clicking anywhere inside the filter and dragging it.
- B. By clicking on the dropdown and dragging the filter
- C. By clicking on the filter title and dragging it.
- D. By clicking on the 2 lines on top and dragging the filter.
Answer: D
Explanation:
Explanation
You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:
NEW QUESTION # 102
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
- A. $147,950
- B. $33,768
- C. (Correct)
- D. $16,581
- E. $48,115
Answer: D
Explanation:
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:
2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, drag State ID to Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
NEW QUESTION # 103
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)
- A. 65.67
- B. 76.25
- C. 4.87
- D. 68.77
Answer: B
Explanation:
Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:
2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:
3) Now, let's create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
NEW QUESTION # 104
Is SUM a table calculation?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile
These can be calculated using : Table(across), Cell, or Specific dimensions!
NEW QUESTION # 105
________________ can only create header. _______________ will create header and axis both.
- A. Groups, Sets
- B. Dimensions, Measures
- C. Dates, Strings
- D. Measures, Dimensions
Answer: B
Explanation:
Explanation
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
NEW QUESTION # 106
How can you format numbers in Tableau as currency?
- A. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION # 107
Which of the following is NOT a new feature introduced in Tableau 2020.1?
- A. Dynamic Paramaters
- B. Set Control
- C. Viz Animations
- D. Buffer Calculations
Answer: B
Explanation:
Explanation
Your Tableau Desktop Specialist exam will be based on the 2020.1 version.
Set controls are a new feature introduced in the 2020.2 version, and hence is the correct answer - it is not a part of 2020.1 For the 2020.1 version the new features were:
1) Viz animations:
Viz animations help you see and understand your changing data. It's easy to track the logical steps behind data's evolution and tell powerful data stories. Sorting, filtering, adding fields, and other actions will now smoothly animate your visualizations. Choose whether to turn Viz Animations on or off, and decide how you'd best like to apply animations to your new workbooks.
2) Dynamic Parameters:
Say goodbye to republishing workbooks with parameters every time the underlying data changes. Set your parameter once, and Tableau will automatically update the parameter's list of values every time someone opens the workbook.
3) Buffer Calculations:
Buffer calculations allow you to visualize the distance around point locations. Give Tableau three parameters-location, distance, and a unit of measure-and a buffer, or boundary is instantly created.
Answering complex spatial questions becomes easier than ever before-visualize what properties are within
200 meters of a proposed transit site, or how many competitors' stores are within 1 mile of their store, and more.
NEW QUESTION # 108
......
Tableau Desktop Specialist Certification Exam is a professional certification that is designed to validate an individual's knowledge and expertise in using Tableau Desktop. Tableau Desktop is a powerful data visualization and business intelligence tool that helps organizations to analyze and visualize data in a meaningful way. With the Tableau Desktop Specialist Certification, individuals can demonstrate their proficiency in using Tableau Desktop to create and publish data visualizations, data analysis, and data-driven solutions.
Verified Desktop-Specialist dumps Q&As - 100% Pass from TroytecDumps: https://www.troytecdumps.com/Desktop-Specialist-troytec-exam-dumps.html
Pass Desktop-Specialist Exam in First Attempt Guaranteed 2023 Dumps: https://drive.google.com/open?id=1WGzM8q5uwV--ibHAo8FOjehocN45VnKx