Pass Tableau Desktop-Specialist Exam with Guarantee Updated 150 Questions
Latest Desktop-Specialist Pass Guaranteed Exam Dumps Certification Sample Questions
How to book the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
To apply for the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam, You have to follow these steps:
- Step 1: Go to the Tableau-Solutions-Architect-Professional Official Site
- Step 2: Read the instruction carefully
- Step 3: Follow the given steps
- Step 4: Apply for the Tableau-Solutions-Architect-Professional Exam
Tableau Desktop-Specialist Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION 20
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Fading
- B. Continuous
- C. Mixed
- D. Discrete
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 21
Larger image
What is this entire view referred to as in Tableau?
- A. Analytics Pane
- B. Summary Pane
- C. Distribution Pane
- D. Data pane
Answer: A
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 22
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 23
Which of the following is a valid way to create Sets in Tableau?
- A. In the Data pane, right-click a measure and select Create > Set.
- B. In the Tableau Main Menu, choose Dashboard and select Create > Set
- C. In the Data pane, right-click a dimension and select Create > Set.
- D. In the Tableau Main Menu, Choose Worksheet 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 24
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Desktop
- B. Tableau Server
- C. Tableau Online
- D. Tableau Reader
Answer: D
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION 25
True or False: To concatenate fields, they must be of same data type
- A. False
- B. True
Answer: B
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 26
True or False: A reference line cannot be added from the Analytics Pane
- A. True
- B. False
Answer: B
Explanation:
Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:
NEW QUESTION 27
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 .twbx file
- B. Save it as a .twb file
- C. Save it as a .tds file
- D. Save it as a .twm file
Answer: C
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 28
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. Calculation
- B. Parameters
- C. Sets
- D. Groups
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 29
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of days between these dates
- B. Number of orders shipped between these dates
- C. Number of unique orders placed 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 30
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. CSV file
- C. MS Access Database
- D. PDF File
Answer: C
Explanation:
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
NEW QUESTION 31
How can you change the default Tableau repository location?
- A. By clicking on Help -> Change Repository Location
- B. By clicking on File -> Repository Location and choosing a new location
- C. By Moving the repository location manually to wherever we want
- D. By clicking on Window -> Repository Location
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 32
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 33
True or False: Sets can be created on Measures
- A. True
- B. False
Answer: B
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 34
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 35
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: A
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 36
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. $147,950
- C. $48,115
- D. $16,581
- E. $33,768
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 37
......
New Desktop-Specialist Test Materials & Valid Desktop-Specialist Test Engine: https://questionsfree.prep4pass.com/Desktop-Specialist_exam-braindumps.html
