Latest [Oct 19, 2021] Tableau Desktop-Specialist Exam Practice Test To Gain Brilliante Result
Take a Leap Forward in Your Career by Earning Tableau Desktop-Specialist
NEW QUESTION 44
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 45
Which of the following are the options to export the data used to build the view / visualisations?
- A. PDF File
- B. MS Access Database
- C. CSV file
- D. JSON format
Answer: B
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 46
For creating variable sized bins we use __________________
- A. Sets
- B. Calculated Fields
- C. Groups
- D. Table Calculations
Answer: B
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 47
To connect Tableau to a CSV data source what type of connection should you use?
- A. Spatial
- B. JSON
- C. Excel
- D. Text
Answer: D
Explanation:
Explanation
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:
2) Choose the appropriate file, and click Open:
3) Finally, Tableau imports the data as shown below:
NEW QUESTION 48
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. duplicates
- B. aliases
- C. copies
- D. parameters
Answer: B
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION 49
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 20,000
- B. 5,000
- C. 15,000
- D. 10,000
Answer: D
Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
NEW QUESTION 50
True or False: Context Filters are executed after Data Source filters
- A. True
- B. False
Answer: A
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:
NEW QUESTION 51
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
- A. 96.46%
- B. 99.46%
- C. 97.12%
- D. 95.12%
Answer: C
Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :
NEW QUESTION 52
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 53
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A. Nothing changes in the view, but a group is created in the Dimensions shelf.
- B. A new mark (bar) is created, which consolidates all members of the group.
- C. The colours of the members selected are now the same, and different for the rest of the members.
- D. Trick question! It is not possible to group by labels.
Answer: B
Explanation:
Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
NEW QUESTION 54
How can you change the default Tableau repository location?
- A. By Moving the repository location manually to wherever we want
- B. By clicking on File -> Repository Location and choosing a new location
- C. By clicking on Help -> Change Repository Location
- D. By clicking on Window -> Repository Location
Answer: A
Explanation:
Explanation
According to the official Tableau documentation:
NEW QUESTION 55
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. Regex Search
- C. Union Search
- D. Wildcard Search
Answer: D
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 56
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
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 57
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?
- A. 3.704
- B. 3.840
- C. 3.000
- D. 3.500
Answer: A
Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.
2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:
Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)
NEW QUESTION 58
True or False: It is possible to add a field to more than one hierarchy
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
NEW QUESTION 59
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 Online
- C. Tableau Reader
- D. Tableau Server
Answer: C
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION 60
Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :
2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:
3) Finally, click on the Show mark Labels icon:
4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:
NEW QUESTION 61
True or False: The Highlighting action can be disabled for the entire workbook.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes, it is possible to disable highlighting for the entire workbook.
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
NEW QUESTION 62
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. True
- B. False
Answer: A
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 63
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
- A. Tom Ashbrook
- B. Penelope Sewall
- C. Sanjit Engle
- D. Tamara Chand
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 64
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on Data in the Menu bar and Choose Show Mark Labels
- B. Click on Analysis in the Menu bar and choose Show Mark Labels
- C. Drag the measure to the Text label in the Marks Card
- D. Click on the Show mark labels icon in the Toolbar
Answer: B,C,D
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 65
......
Authentic Best resources for Desktop-Specialist Online Practice Exam: https://www.realexamfree.com/Desktop-Specialist-real-exam-dumps.html
Updates Up to 365 days On Developing Desktop-Specialist Braindumps: https://drive.google.com/open?id=1Msnimhz8o2BP10zT2MmkxVXyzH2r4Avl
