Brilliant Desktop-Specialist Exam Dumps Get Desktop-Specialist Dumps PDF
Desktop-Specialist Dumps PDF - Desktop-Specialist Real Exam Questions Answers
Candidates who pass the Tableau Desktop-Specialist certification exam can demonstrate their ability to use Tableau Desktop to analyze and visualize data effectively. They can help organizations make data-driven decisions by creating interactive dashboards, reports, and visualizations. Tableau Desktop Specialist Exam certification also validates the candidate's expertise in data visualization best practices, which can be applied to various industries, including finance, healthcare, and retail.
The Tableau Desktop-Specialist exam covers a range of topics including data connections, data preparation, visualization creation, calculations, and dashboard development. Desktop-Specialist exam is designed to test the individual's ability to use Tableau Desktop to create effective visualizations and dashboards that can be used to communicate insights to stakeholders.
NEW QUESTION # 141
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Workbook (.twb)
- B. Tableau Data Source (.tds)
- C. Tableau Data Extract (.tde)
- D. Tableau Packaged Workbook (.twbx)
Answer: C
Explanation:
Explanation
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
NEW QUESTION # 142
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?
- A. 0.739284
- B. 0.759329
- C. 0.748472
- D. 0.783262
Answer: D
Explanation:
Explanation
Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:
c
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):
3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:
4) The following is our view. Hover over the trend line to see the R-squared value:
NEW QUESTION # 143
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. 68.77
- 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 # 144
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
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 # 145
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.
- A. .twbx file
- B. .tde file
- C. .twb file
- D. .tbm file
Answer: A
Explanation:
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks.
NEW QUESTION # 146
What do the colours Blue and Green represent in Tableau?
- A. Continuous and Discrete
- B. Discrete and Continuous
- C. Measures and Dimensions
- D. Dimensions and Measures
Answer: B
Explanation:
Important question! If you selected Dimension and Measure, don't worry! It is a very common mistake. But we're here to learn aren't we?
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.
NEW QUESTION # 147
We can join a maximum of ______ tables in Tableau
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Explanation
It is possible to join a maximum of 32 tables in Tableau!
NEW QUESTION # 148
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. June
- B. July
- C. September
- D. October
Answer: D
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 # 149
If you see a Blue field, generally it will add _____________ to the view
- A. headers
- B. both
- C. none
- D. axis
Answer: A
Explanation:
Important question!
NEW QUESTION # 150
You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target.
When you click Salt Lake City in the view, to where will the URL action direct you?
- A. https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City
- B. https://en.wikipedia.org/wiki/Salt.LakeXity
- C. https://en.wikipedia.org/wiki/<Car Dropoff City>
- D. https://en.wikipedia.org/wiki/<Salt-Lake-City>
Answer: A
Explanation:
When you click Salt Lake City in the view, the URL action will direct you to
https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City. A URL action is a hyperlink that points to a web page 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 URLs3 In this case, the URL action uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target, where <Car Dropoff City> is a field value from the view. When you click Salt Lake City in the view, Tableau will replace <Car Dropoff City> with Salt Lake City in the URL target.
However, since spaces are not allowed in URLs, Tableau will encode them as + signs instead. Therefore, the final URL will be https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City3 The other options are not correct because they do not reflect how Tableau encodes field values in URL actions.
NEW QUESTION # 151
Which of the following can you use to create a Histogram?
- A. 2 measures
- B. 1 dimension
- C. 1 measure
- D. 2 dimensions
Answer: C
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
The basic building blocks for a histogram are as follows:
Demo :
NEW QUESTION # 152
Which of the following are valid ways to Bold the Tooltip content in Tableau?
- A. Click on Worksheet in the Menu bar, followed by Tooltip and select
the bold option - B. Click on Analysis, Tooltip options, and select bold.
- C. Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.
- D. Click on Tooltip in the Marks card, and select bold.
Answer: A,C,D
Explanation:
Lot of students have been seeing this question in the exam lately, and wanted me to include this question so here it is. Follow along -
1) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option Graphical user interface Description automatically generatedGraphical user interface, application, Word Description automatically generated
2) Click on Tooltip in the Marks card, and select bold.
Graphical user interface, application Description automatically generated
Graphical user interface, application, Word Description automatically generated
3) Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.
A picture containing line chart Description automatically generatedGraphical user interface Description automatically generated
There exists no option to Bold the tooltip contents by clicking Analysis. Hence, it is an incorrect choice.
NEW QUESTION # 153
By default, measures placed in a view are aggregated by ______________
- A. SUM
- B. AVERAGE
- C. MEDIAN
- D. COUNT
Answer: A
Explanation:
Explanation
By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.
NEW QUESTION # 154
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Tamara Chand
- B. Penelope Sewall
- C. Tom Ashbrook
- D. Sanjit Engle
Answer: B
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 # 155
You have the following visualization.
Which set type is created when you select the Create Set option?
- A. A Top N set
- B. A fixed set
- C. A dynamic set
- D. A combined set
Answer: C
Explanation:
When you use the 'Create Set' option in Tableau, it creates a dynamic set if the conditions for inclusion in the set are based on a calculation or an aggregation that may change as the data is updated or as filters are applied.
Fixed sets are static and do not change with data refreshes, while dynamic sets can update to reflect the current state of the data.
NEW QUESTION # 156
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
- A. An incremental refresh only adds rows that are new
- B. A full refresh must be configured. An incremental refresh is the default extract in Tableau.
- C. A full refresh is usually very slow. An incremental refresh can take less time.
- D. A full refresh replaces all the extracted data with the data in the underlying data source.
- E. An incremental refresh can only be run from Tableau Server.
Answer: A,C,D
Explanation:
According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.
NEW QUESTION # 157
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:
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 # 158
Which of the following is not a Trend Line Model?
- A. binomial Trend Line
- B. Linear Trend Line
- C. Logarithmic Trend Line
- D. Exponential Trend Line
Answer: C
Explanation:
Explanation
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:
For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
NEW QUESTION # 159
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 2 , 2
- B. 2 , 3
- C. 1 , 2
- D. 1 , 4
Answer: D
Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
NEW QUESTION # 160
The default path for all supporting files, data sources, icons, logs etc is in ______________________
- A. Documents -> My Tableau Repository
- B. Downloads -> Tableau Support Files
- C. Documents -> Tableau
- D. Documents -> Tableau Files
Answer: A
Explanation:
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
NEW QUESTION # 161
Which of these is NOT a type of Quick Filter available in Tableau?
- A. Wildcard Match
- B. Single Value (slider)
- C. Multiple Values (dropdown)
- D. Regex Match
Answer: D
Explanation:
Explanation
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
NEW QUESTION # 162
Which of the following are true about Dashboards in Tableau?
- A. Tiled items don't overlap
- B. A bar chart can be used a floating item
- C. None of these
- D. Floating items can be layered over other objects
Answer: A,B,D
Explanation:
From the official Tableau documentation:
As we can see below, Bar charts can be used as a floating object.
NEW QUESTION # 163
To display data that has both negative and positive quantitative values, Tableau Desktop will display marks by using__________________as the default.
- A. a diverging palette
- B. the full color range
- C. a categorical palette
- D. a sequential palette
Answer: A
Explanation:
Tableau Desktop will display marks by using a diverging palette as the default to display data that has both negative and positive quantitative values. A diverging palette is a type of color palette that uses two different color ranges to show positive and negative values. For example, a red-green diverging palette uses shades of red for negative values and shades of green for positive values. A diverging palette is automatically applied when there are both negative and positive values for a measure that is placed on Color on the Marks card5 The other options are not correct types of color palettes that Tableau Desktop uses as the default for data with both negative and positive values. A full color range is not a valid term for a color palette in Tableau. A sequential palette is a type of color palette that uses different shades of one color to show variations in a single measure. A sequential palette is usually applied when there are only positive values for a measure that is placed on Color on the Marks card5 A categorical palette is a type of color palette that uses different colors to show discrete values or categories. A categorical palette is usually applied when there is a dimension that is placed on Color on the Marks card5
NEW QUESTION # 164
What are two outcomes when you drag a continuous date value to the Rows shelf? Choose two,
- A. The pill on the Rows shelf is blue.
- B. The pill on the Rows shelf is green.
- C. The date part Is displayed as labels.
- D. A quantitative axis is shown.
Answer: B,D
Explanation:
Dragging a continuous date value to the Rows shelf in Tableau results in a green pill on the Rows shelf, indicating a continuous field. It also results in a quantitative axis being displayed on the visualization.
Continuous fields are used to create axes on charts and can represent a range of values smoothly. This is opposed to discrete date values, which would be represented by a blue pill and typically show headers or labels rather than a continuous axis.
NEW QUESTION # 165
Which of the following URL prefixes are permitted when creating a URL Action in Tableau?
- A. FTP
- B. SMTP
- C. HTTP
- D. HTTPS
Answer: A,C,D
Explanation:
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 Description automatically generated
Graphical user interface, application, Word Description automatically generated
Graphical user interface, text, application Description automatically generated
Graphical user interface, text, application Description automatically generated
NEW QUESTION # 166
......
Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is a valuable certification for individuals who want to demonstrate their expertise in using Tableau Desktop and for organizations that want to ensure that their employees are proficient in using the software. Desktop-Specialist exam covers various topics related to Tableau Desktop and tests the knowledge and skills of individuals in each of these areas. Passing the exam is a testament to an individual's proficiency in using Tableau Desktop and can lead to better job opportunities and increased credibility in the industry.
Valid Desktop-Specialist Test Answers & Tableau Desktop-Specialist Exam PDF: https://www.exams4collection.com/Desktop-Specialist-latest-braindumps.html
Realistic Desktop-Specialist Exam Dumps with Accurate & Updated Questions: https://drive.google.com/open?id=1YLg8KHk5ZtVgirxRrbz3mz7dlpDm2R-J
