[Sep-2021] Desktop-Specialist Dumps Full Questions - Tableau Desktop Specialist Exam Study Guide
Exam Questions and Answers for Desktop-Specialist Study Guide
NEW QUESTION 47
A Tableau Support case can be opened in which of the following valid ways?
- A. Using the Developer Community Forum
- B. Using the support option on the Tableau website
- C. Contacting Salesforce using their website
- D. Using the Tableau learn website
Answer: B
Explanation:
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
NEW QUESTION 48
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 .twm file
- B. Save it as a .twb file
- C. Save it as a .tds file
- D. Save it as a .twbx 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 49
Which of the following are valid ways of Grouping Data?
- A. From the Analytics Pane
- B. Using Marks in the view
- C. From the Dimensions Shelf
- D. Using Labels in the View
Answer: B,C,D
Explanation:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:
Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:
They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):
Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:
Finally, we can group directly from the Dimensions shelf as follows:
Now choose Phones, Chairs and Storage and Click Group:
You will now automatically have a new Dimension as follows:
NEW QUESTION 50
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Sets
- B. Clustering
- C. Grouping
- D. Union
Answer: B
Explanation:
Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
NEW QUESTION 51
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. July
- B. September
- C. October
- D. June
Answer: C
Explanation:
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 52
What does it imply if a field has a blue background?
- A. It is continuous
- B. It is a measure
- C. It is discrete
- D. It is a dimension
Answer: C
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.
NEW QUESTION 53
How do you identify a continuous field in Tableau?
- A. It is preceded by a '=#' symbol in the data window
- B. It is identified by a green pill in a visualization
- C. It is preceded by a 'Abc' symbol in the data window
- D. It is identified by a blue pill in the visualization
Answer: A
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.
NEW QUESTION 54
To use a quick table calculation, which of the following programming languages do you need to know?
- A. Java
- B. ython
- C. Javascript
- D. None of these
Answer: D
Explanation:
Explanation
You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
NEW QUESTION 55
________________ can only create header. _______________ will create header and axis both.
- A. Measures, Dimensions
- B. Dates, Strings
- C. Dimensions, Measures
- D. Groups, Sets
Answer: C
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 56
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Data Extract (.tde)
- B. Tableau Packaged Workbook (.twbx)
- C. Tableau Workbook (.twb)
- D. Tableau Data Source (.tds)
Answer: A
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 57
When using Animations in a Tableau, which of the following is the default duration for animations?
- A. 0.5s
- B. 0.3s
- C. 0.4s
- D. 0.2s
Answer: B
Explanation:
Explanation
The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!
NOTE: Animations are DISABLED by default and must be manually enabled.
You can also reset all settings to default by clickin on 'Reset All'
NEW QUESTION 58
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. 22.404%
- B. 23.497%
- C. 28.415%
- D. 25.683%
Answer: A
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 59
Which of the following can you add a reference line to?
- A. Calculated Fields
- B. Groups
- C. Dimensions
- D. Measures
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 60
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Orange, Blue
- 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 61
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.748472
- B. 0.759329
- C. 0.783262
- D. 0.739284
Answer: C
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 62
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 hold one or more worksheets, plus zero or more dashboards and stories.
- C. 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
- D. 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.
Answer: C
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 63
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Values are always aggregated at the level of the Date Part
- D. Tableau doesn't aggregate values, we do!
Answer: B
Explanation:
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:
NEW QUESTION 64
Which of the following returns the Absolute Value of a given number?
- A. ZN(Number)
- B. ABS(Number)
- C. FLOOR(Number)
- D. CEILING(Number)
Answer: B
Explanation:
Explanation
From the official Tableau website:
NEW QUESTION 65
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Phone, Monitor, Laptop, Default
- B. Default, Phone, Tablet, Desktop
- C. Phone, Tablet, Laptop, Desktop
- D. Monitor, Default, Phone, Tablet
Answer: A
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION 66
Which one of the following is a dimension?
- A. Longitude
- B. Measure Names
- C. Latitude
- D. Number of records
Answer: B
Explanation:
Explanation
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
NEW QUESTION 67
The row and column shelves contain ___________________
- A. Grand Totals
- B. Pills
- C. Parameters
- D. Filters
Answer: B
Explanation:
Explanation
We can drag fields from the Data pane to create the structure for your visualizations.
The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.
These FIELDS are also referred to as PILLS. See below:
NEW QUESTION 68
Which of the following chart type makes use of 'binned' data?
- A. Gantt Chart
- B. Bullet chart
- C. Histogram
- D. Treemaps
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.
NEW QUESTION 69
......
Tableau Desktop Specialist Exam Free Update With 100% Exam Passing Guarantee: https://www.free4torrent.com/Desktop-Specialist-braindumps-torrent.html
Real Exam Questions & Answers - Tableau Desktop-Specialist Dump is Ready: https://drive.google.com/open?id=1taKMpvxYKBoVD6_J7W7oua-a7TznYyYT