Desktop Certified Associate Updated Questions

Text Material Preview

Desktop Certified
Associate
Exam Name: Tableau Desktop Certified Associate
Full version: 110 Q&As
Full version of Desktop Certified Associate
Dumps
Share some Desktop Certified Associate exam
dumps below.
 1 / 23
https://www.certqueen.com/Desktop-Certified-Associate.html
https://www.certqueen.com/Desktop-Certified-Associate.html
1. Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by
California State in the West region? You can add the functionality to the dashboard.
A. $3,251
B. $3,448
C. $517
D. $987
Answer: C
Explanation:
Select California State from the Map
2. Connect to the "Kiva Loans - India" data source, find out the average number of days it took
to disbursed the funded amount in catering activity, and what is the total funded amount?
A. 26.5, $2275
B. 26, $2275
C. 26.5, $325
D. 26, $325
Answer: A
Explanation:
Graphical user interface Description automatically generated with medium confidence
 2 / 23
Filter the Activity = Catering
Drop the activity to rows, and no of days to columns, change the aggregation to AVG.
Also, drop the Funded Amount to the Tooltip.
Graphical user interface, application Description automatically generated
3. You have connected to the employee table in your data source and are adding a join on the
Employee Manager table. If you would like to see all of the records from the employee table and
only matching records from the employee manager table.
Which join type will you use?
A. Inner join
B. Outer join
C. Left join
D. Right join
Answer: C
Explanation:
When you use a left join to combine tables, the result is a table that contains all values from the
 3 / 23
left table and corresponding matches from the right table.
Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
=================================================== Topic 2, Exam Pool C
Download the Dataset from here:
https://drive.google.com/file/d/1hGTUYyq6Y7DLt-DwxVaR4tNLS-FYvD22/view?usp=sharing
Use the above data set to answers the questions under Exam Pool C.
4. Which of these dashboard actions do not have target sheets?
A. Change Parameters
B. Change Set Values
C. Filter
D. Go to URL
Answer: B D
Explanation:
Go to the menu Dashboard -> Action -> Add Action
 4 / 23
Select Filter, here you will find the Target Sheets
For all other options, you will not find the Target Sheets. Try it yourself.
 5 / 23
5. What is the default join type when you blend two data sources?
A. Inner join
B. Outer join
C. Left outer join
D. Right join
Answer: C
Explanation:
Blend is the left outer join after aggregation at the level of granularity.
6. Connect to the "Significant Volcano Eruption" data source. Using the elevations field, create
bins of size 1000 and find out in which bin has the most total deaths?
A. 0
B. 1000
C. 2000
D. 3000
Answer: C
Explanation:
Select the 'Elevation' field from measures, and go to show me. Click on Histogram. Right-Click
on the "Elevation (bin)" dimension and select Edit. Change the size of bins to 1000. Graphical
user interface, application Description automatically generated
 6 / 23
Drop the Total Death to Label.
Chart, histogram Description automatically generated
The total number of deaths reported in the bin of 2000.
Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.
7. How can we add Visualization in a tooltip?
A. Go to the Tooltip on the marks card, and click insert -> sheets
B. Go to the Worksheet menu, click on Tooltip and click Insert -> sheets
C. Go to the Format menu, click on Tooltip and click Insert -> sheets
D. Right Click on the view, Tooltip and add insert -> sheets
Answer: A B
Explanation:
Only 1 and 2 options are correct.
For these types of questions, please take the help of the Tableau software during your exam.
8. Connect to the "Global Superstore" data source and use the Orders table. Find out how many
distinct customers have made 6 orders?
A. 29
B. 30
 7 / 23
C. 31
D. None of the above
Answer: A
Explanation:
Find out the distinct orders for each customer
Graphical user interface, text, application Description automatically generated
Move this field from Measure to Dimension.
Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID
using
CountD, and drop this field to Label as well. Your view will look like this:
Chart Description automatically generated
 8 / 23
29 distinct customers have made 6 orders.
9. Connect to the "Global Superstore" data source and use the Orders table. Find out how many
days in the month of May 2012 were profitable?
A. 16
B. 18
C. 20
D. 22
Answer: C
Explanation:
Graphical user interface, application Description automatically generated
 9 / 23
Here we have created the Fixed LOD expression and fixing the order date. If profit is greater
than 0 it means profitable day/month/quarter/year depends on what you need to find. If profit < 0
then not profitable.
Drop the Order Date to the rows and drill-down it till months.
Drop the profitable days field to the Text, aggregated as SUM. So it will find a number of days.
Graphical user interface, application Description automatically generated
10. Connect to the "Significant Volcano Eruption" data source. In 1899, the Dona Juana volcano
erupted in Colombia. Find out which volcano in the Popayan city is the closest to Dona Juana
and how many death Dona Juana volcano caused?
A. Purace, 55
B. Galeras, 55
C. Purace, 0
D. Galeras, 0
 10 / 23
Answer: A
Explanation:
Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click
on these fields.
Drop the Location field to Filter shelf, select the Location as Colombia.
Drop the Name field to the Label.
To show the cities go to the Map -> Map layer and Check the Cities.
Graphical user interface, text, application Description automatically generated
 11 / 23
Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:
Map Description automatically generated
 12 / 23
Zoom-in the map, you will find Purace is the nearest one in the Popayan city and Dona Juana
was having 55 deaths.
Map Description automatically generated
 13 / 23
11. Connect to the "Covid data" source. Create a line chart using continuous months and new
deaths. Find the Excess Kurtosis for the sum of new deaths.
A. -0.56
B. -0.67
C. -0.69
D. -0.58
Answer: B
Explanation:
Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.
Click on the Show/Hide card and enable the Summary Card.
Chart, line chart Description automatically generated
 14 / 23
You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-
down and select the Excess Kurtosis.
Graphical user interface, application Description automatically generated
 15 / 23
 16 / 23
12. Connect to the "Global Superstore" data source and use the Orders table. Create a bar in
bar chart and compare the profit against the target profit for Canada Region. Consider target
profit is 30% of the sales.
Which of the following sub-categories has met or exceed the target profit?
A. Tables
B. Paper
C. Labels
D. Copiers
Answer: A C D
Explanation:
Graphical user interface, application Description automatically generated
Drop Region at the filter and Select Canada
Drop Profit to columns and Sub-Category to Rows
Then drop the target profit to profit axis, it will create the combined axis chart.Chart, bar chart Description automatically generated with medium confidence
 17 / 23
Now drop the Measure Names field from the Rows to the Color Marks Card.
Chart, bar chart Description automatically generated
Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will
start from
0)
Graphical user interface Description automatically generated with medium confidence
 18 / 23
 19 / 23
Tables, Labels and Copiers sub-categories has met or exceed the target profit.
Chart Description automatically generated
13. Which of the following is true about spatial files?
A. You cannot create a dual-axis chart using spatial data
B. You cannot join spatial data source with the non-spatial data source
C. You cannot apply filters in your view if it is creates using the spatial data source
D. None of the above
Answer: D
Explanation:
All are false here.
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm
14. Connect to the Olympic Athletes data source, find out the average age of players who won
at least one gold medal for the country?
A. 26.33
(Correct)
B. 26.41
C. 26.72
D. 26.02
Answer: A
 20 / 23
Explanation:
Drop the Age to the columns and change the aggregation to AVG.
Drop Gold Medals field to filter and select All values ->
Graphical user interface, text, application, email Description automatically generated
Change 1 from 0.
Graphical user interface, application Description automatically generated
15. In LOD calculation, we can use fields from multiple data sources (blended data source)?
A. True
B. False
Answer: B
 21 / 23
Explanation:
Graphical user interface, text, application, Word, email Description automatically generated
Here, the Location is in a primary data source, and the population field is in a secondary data
source.
So the answer is FALSE.
16. We can create variable size bins using ___________?
A. Groups
B. Calculated Fields
C. Sets
D. Hierarchies
Answer: B
Explanation:
Only by using Calculated fields you can create a variable size bin.
17. When we blend the data, sometimes a Null value appears in place of data.
What could be the possible reasons for the same?
A. The data to combine is at different level of detail.
B. The values in the primary and secondary data sources use different casing.
C. The secondary data source does not contain values for the corresponding values in the
primary data source.
D. The data types of the fields you are blending on are different.
Answer: B C D
Explanation:
Refer section "Null values appear after blending data sources" at
 22 / 23
https://help.tableau.com/current/pro/desktop/enus/ multipleconnections_troubleshooting.htm
 
More Hot Exams are available.
350-401 ENCOR Exam Dumps
350-801 CLCOR Exam Dumps
200-301 CCNA Exam Dumps
Powered by TCPDF (www.tcpdf.org)
 23 / 23
https://www.certqueen.com/promotion.asp
https://www.certqueen.com/350-401.html
https://www.certqueen.com/350-801.html
https://www.certqueen.com/200-301.html
http://www.tcpdf.org