Guaranteed Success in Tableau Desktop Specialist Desktop-Specialist Exam Dumps
Tableau Desktop-Specialist Daily Practice Exam New 2023 Updated 150 Questions
Tableau Desktop-Specialist is a certification exam designed for professionals who want to showcase their proficiency in using Tableau Desktop. It is a vendor-based certification offered by Tableau, a popular data visualization tool used by businesses and organizations worldwide. Desktop-Specialist exam assesses the candidate's ability to use Tableau Desktop software to connect, visualize, and share data with others. Passing the Tableau Desktop Specialist exam validates that the candidate has the skills and expertise required to work with Tableau Desktop in various data visualization and business intelligence roles.
To prepare for the Tableau Desktop-Specialist exam, candidates can take online courses, attend training sessions, and practice using Tableau Desktop software. Tableau also provides study materials, such as practice exams and sample questions, to help candidates prepare for the exam.
NEW QUESTION # 49
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
- B. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
- C. To hold one or more worksheets, plus zero or more dashboards and stories.
- D. To 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 etc
Answer: D
Explanation:
Explanation
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - To 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 etc. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
3) Extract (.hyper or .tde) - To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
3) (.twb) Workbooks - To hold one or more worksheets, plus zero or more dashboards and stories.
NEW QUESTION # 50
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).
* Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
* 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!
3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )
NEW QUESTION # 51
What is the following icon in the Data pane used to do?
Larger image
- A. View Data
- B. Sort Data
- C. Extract Data
- D. Clean Data
Answer: A
Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
NEW QUESTION # 52
Larger image
What is this view referred to as in Tableau?
- A. Data Pane
- B. Analytics Pane
- C. Dimensions & Measures
- D. Window Pane
Answer: A
Explanation:
Explanation
Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.
The Data pane includes:
Dimension fields - Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.
Measure fields - Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.
For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.
Calculated fields - If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.
For more information on calculated fields, see Create Custom Fields with Calculations.
Sets - Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.
Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.
Parameters - Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.
NEW QUESTION # 53
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 25.79%
- B. 23.39%
- C. 29.49%
- D. 27.73%
Answer: D
Explanation:
Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION # 54
Which of the following are valid ways to add Totals to a view?
- A. From the Analysis Tab in the Menu bar on top
- B. Using the Data Pane
- C. Using the Analytics Pane
- D. Using the Marks shelf
Answer: A,C
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION # 55
For creating variable sized bins we use __________________
- A. Sets
- B. Table Calculations
- C. Groups
- D. Calculated Fields
Answer: D
Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
NEW QUESTION # 56
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. 68.77
- B. 76.25
- C. 65.67
- D. 4.87
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 # 57
Which of the following can you add a reference line to?
- A. Measures
- B. Groups
- C. Dimensions
- D. Calculated Fields
Answer: A,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 # 58
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Orange, Blue
- B. Blue, Red
- 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 # 59
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Sales / Profit
- B. SUM(Profit) / SUM(Sales)
- C. Profit / Sales
- D. SUM(Sales)/SUM(Profit)
Answer: B
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:
NEW QUESTION # 60
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the of the revenue in the same view!
NEW QUESTION # 61
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?
- A. YES, we can do this with the help of a Web-Page object
- B. NO, this is not currently possible in Tableau
- C. YES, we can do this with the help of a plugin
- D. YES, we can do this with the help of Tableau Public
Answer: A
Explanation:
Explanation
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
NEW QUESTION # 62
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Sanjit Engle
- B. Tamara Chand
- C. Tom Ashbrook
- D. Penelope Sewall
Answer: D
Explanation:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set
2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
c
NEW QUESTION # 63
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Menu
- B. Double click
- C. Click
- D. Select
- E. Hover
Answer: A,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 # 64
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
- A. Sets
- B. Parameters
- C. Groups
- D. Calculation
Answer: B
Explanation:
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -
NEW QUESTION # 65
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. (Correct)
- B. $33,768
- C. $147,950
- 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 # 66
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. Pattern Search
- B. Wildcard Search
- C. Regex Search
- D. Union Search
Answer: B
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 # 67
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Blending
- B. Combining
- C. Unioning
- D. Joining
Answer: C
Explanation:
Explanation
Unioning is the correct answer!
From the official documentation:
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."
NEW QUESTION # 68
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
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.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
NEW QUESTION # 69
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into
_______________________
- A. Labels and Values
- B. Dimensions and Measures
- C. Rows and Columns
- D. Numbers and Headers
Answer: B
Explanation:
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 # 70
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Fading
- B. Discrete
- C. Mixed
- D. Continuous
Answer: C
Explanation:
Explanation
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version:
For more information about color palettes, see Color Palettes and Effects.
NEW QUESTION # 71
......
Tableau Desktop-Specialist exam is targeted towards professionals who work in various industries such as finance, healthcare, marketing, and sales. It is suitable for individuals who are involved in data analysis, business intelligence, and reporting. Desktop-Specialist exam covers a wide range of topics including data connection, data blending, data aggregation, and data visualization. Desktop-Specialist exam is divided into two parts, multiple-choice questions and hands-on exercises, to assess the candidate's knowledge and skills.
Test Engine to Practice Desktop-Specialist Test Questions: https://actualtorrent.pdfdumps.com/Desktop-Specialist-valid-exam.html