[Sep 21, 2021] Desktop-Certified-Associate Ultimate Study Guide - PassTestking
Ultimate Guide to Prepare Desktop-Certified-Associate Certification Exam for Tableau Desktop Certified Associate in 2021
NEW QUESTION 53
What are the types of annotations available in Tableau?
- A. Area
- B. Mark
- C. Point
- D. Circle
Answer: A,B,C
Explanation:
Graphical user interface, application, table Description automatically generated
NEW QUESTION 54
How to add reference lines in a view? (Select correct two answers)
- A. Using Analytics pane
- B. Right Click on Axis and Add Reference Line
- C. Using Data Pane
- D. Using Analysis Menu
Answer: A,B
Explanation:
Using Analytics pane:
Graphical user interface, application Description automatically generated
Right Click on Axis and Add Reference Line:
Graphical user interface, application Description automatically generated
NEW QUESTION 55
Which of the following are true regarding custom geocoding and data blending?
- A. In data blending, you can use any data but custom geocoding requires text file based data
- B. You can create new geographic roles both in data blending and custom geocoding
- C. Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending
- D. Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending
Answer: A,D
Explanation:
Refer to the quick comparison of data blending and custom geocoding -
https://help.tableau.com/current/pro/desktop/en-us/maps_customgeocode_datablend.htm
NEW QUESTION 56
Connect to the "Global Superstore" data source and create a view to show only those orders which were returned. What is the unique number of orders returned in the North Africa region in the office supplies category? Consider only those orders which were shipped using Standard Class ship mode.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Create an inner join between Orders and Returns table using Order ID
Graphical user interface, application Description automatically generated
Create a calculated field to find the unique order.
Graphical user interface, text, application Description automatically generated
Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:
Graphical user interface, text, application Description automatically generated
NEW QUESTION 57
Connect to the "Global Superstore" data source and use the Orders table. Create a map that shows the number of unique customers in Australia. Find the state of Queensland. Which neighboring state has the minimum number of unique customers?
- A. Australian Capital Territory
- B. South Australia
- C. New South Wales
- D. Northern Territory
Answer: D
Explanation:
Explanation
Drop the country field to the view and also to the filter and select Australia.
Drop the State to the detail marks card.
Create the Unique Customer field to the Label.
Your view will look like this:
Northern Territory has the minimum unique customers - 19.
NEW QUESTION 58
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. Outer join
- B. Right join
- C. Left join
- D. Inner join
Answer: C
Explanation:
When you use a left join to combine tables, the result is a table that contains all values from the 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.
NEW QUESTION 59
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. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Graphical user interface, application Description automatically generated
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
NEW QUESTION 60
You have connected to an excel sheet that has two tables "orders" and "returns". You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?
- A. It will only be enabled once you perform the data blending
- B. It will only be enabled once you perform the union
- C. It will only be enabled once you save the visualization to Tableau Server
- D. It will only be enabled once you perform the join
Answer: D
Explanation:
Explanation
Select the Extract connection and click on Edit as shown:
If you have single table on the canvas, then Multiple tables option remain disabled:
If you create a join, only then Multiple tables option will be enabled:
NEW QUESTION 61
Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
- A. Texas, New Mexico, Colorado
- B. California, Idaho, Nevada
- C. North Carolina, South Carolina, Virginia
- D. New York, Massachusetts, Rhode Island
Answer: B
Explanation:
Drop the State field to a view, you will get >1k unknown.
Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.
Also, drop the Order Date to the Filters Shelf and choose Years as:
Graphical user interface, application Description automatically generated
Check for the Year 2013.
Drop the Sales field to the Label in the Marks card, your view should look like this:
Graphical user interface Description automatically generated with medium confidence
Now use the Lasso Selection tool from the Map tools:
Graphical user interface, diagram Description automatically generated
And create the group of states as per our answer options.
Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.
Map Description automatically generated
Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.
Graphical user interface, text, application Description automatically generated
NEW QUESTION 62
Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?
- A. .42
- B. .48
- C. .55
- D. .51
Answer: A
Explanation:
Enable the Summary Card from Show/Hide menu as shown:
Skewness is .42
Graphical user interface, chart Description automatically generated
NEW QUESTION 63
Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country.
Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?
- A. Indonesia and 95,055,669
- B. Indonesia and 9,103,406,453
- C. Japan and 9,103,406,453
- D. Japan and 96,812,000
Answer: A
Explanation:
Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Graphical user interface, application Description automatically generated
Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
Graphical user interface, text, application Description automatically generated
Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.
Drop the year to the filters shelf and only enter 1963.
Graphical user interface Description automatically generated
Drop Country and Number of Records / volerup(Count) field to the view.
And drop population to the view from the secondary data source. Your view will look like this:
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 64
Connect to the "Significant Volcano Eruption" data source. What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Drop year to filter shelf and select from 2000.
Graphical user interface Description automatically generated
Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.
Click on Show Me, and select Box and whisker Plot.
IQR = Upper hinge - Lower hinge
Graphical user interface Description automatically generated with low confidence
Here IQR = 32 -2 = 30
Topic 1, Exam Pool B
Download the Dataset from here:
https://drive.google.com/file/d/1z7LPBQNPWHChteShl0QL3yu_JcvstLGl/view?usp=sharing
Use the above data set to answers the questions under Exam Pool B.
NEW QUESTION 65
When we create a filter action in a dashboard, what all we must specify so that it will work?
- A. Source Sheet
- B. Target filter on Selected fields
- C. Run action on
- D. Target Sheet
Answer: A,C,D
Explanation:
Even if you don't select the target filters, your filter action will work. Rest all you need to provide so that it will work.
Graphical user interface Description automatically generated
NEW QUESTION 66
Connect to the "Global Superstore" data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?
- A. The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
- B. The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
- C. The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
- D. The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
Answer: B,D
Explanation:
Create a hierarchy of Segment, Category, Region and drop it into the rows.
Text Description automatically generated
Create profit ratio calculated field:
Graphical user interface, text Description automatically generated
Drop the profit and profit ratio fields to the view, your view will look like this:
Graphical user interface, text, application Description automatically generated
Now let's go through each answer option.
1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.
2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.
3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.
4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False Note: This is an easy question but time consuming, so attempt these types of questions in the end.
NEW QUESTION 67
Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Calculate the Profit Ratio:
Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.
Drop the Order date to Rows and drill-down it to Quarters.
Drop the profit ratio >.25 field to Text:
NEW QUESTION 68
Which of the following map layers are available in Tableau?
- A. Cities Borders
- B. Area Code Labels
- C. Neighborhoods
- D. Points of Interest
Answer: B,C,D
Explanation:
Go to the Map -> Map Layer
Cities Borders is not valid.
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 69
In a box plot, how we can calculate the length of the Upper whisker?
- A. Upper whisker = (Upper hinge - Lower hinge) + (1.5 * IQR)
- B. Upper whisker = Lower hinge + (1.5 * IQR)
- C. Upper whisker = Upper hinge + (1.5 * IQR)
- D. Upper whisker = IQR + (1.5 * IQR)
Answer: C
Explanation:
Explanation
The upper whiskers extends to 1.5 * IQR
The length of the upper whisker is upper hinge + 1.5 * IQR.
NEW QUESTION 70
Connect to the "Global Superstore" data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?
- A. Same Day
- B. Second Class
- C. Standard Class
- D. First Class
Answer: A,D
Explanation:
Explanation
Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate measures) From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.
Hover on each of the boxes:
Median for the First Class and Same Day ship modes are 84.
NEW QUESTION 71
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. 1
- C. 2
- D. 3
Answer: B
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
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.
NEW QUESTION 72
Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Explanation
In WorldCupMatches table, we have the information of Away goals, and in the WorldCups table, we have the information of the Winner team and goal scored.
In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate row for each match. This is the perfect example to use blend as here we need to first aggregate the data from WorldCupMatches table.
Let's establish the blend relationship between these two data sources, on the basis of Country and Year.
Let's use WorldCups as the primary data source, so add the field from this data source to the view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the rows.
In WorldCupMatches data source, create a calculated field :
Drop this field to the Text, and format it so that it will be shown in percentage.
Out of the given options, only in 1934 host country won the world cup
2010 is the correct answer.
NEW QUESTION 73
Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?
- A. North Africa
- B. Western US
- C. Southern Africa
- D. Eastern Asia
Answer: C
Explanation:
Explanation
Create a left outer join, so that we can calculate the percentage of the returned orders
Create a calculated field "% of returned orders":
Drop the Order Date to the filters shelf and select the year 2013
Drop the Region to the rows and % of returned orders to the Text:
NEW QUESTION 74
Connect to the "Flight" data source and create a hierarchy as City-Airport Name-Carrier Name. Find out which combination was having the lowest number of on-time flights?
- A. Orlando-Orlando International-SkyWest
- B. Salt Lake City-Salt Lake City International-Mesa
- C. Phoenix-Phoenix Sky Harbor International-Pinnacle
- D. Boston-Logan International-SkyWest
Answer: C
Explanation:
Explanation
Create a hierarchy using City-Airport Name-Carrier Name.
Filter using Ontime Category field and select the Ontime.
Drop the hierarchy to the view and Number of flights to the Text.
Check each combination from the answers:
NEW QUESTION 75
Which of the following map layers are available in Tableau?
- A. Cities Borders
- B. Area Code Labels
- C. Neighborhoods
- D. Points of Interest
Answer: B,C,D
NEW QUESTION 76
Using the Profit Analysis Dashboard twbx file, find out the 5th most profitable product in the state of New York? You can add the functionality to the dashboard.
- A. GBC DocuBind TL300 Electric Binding System
- B. HP Designjet T520 Inkjet Large Format Printer - 24" Color
- C. Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind
- D. Canon imageCLASS 2200 Advanced Copier
Answer: A
Explanation:
Select New York State, you are getting only 3 products, and not 5.
Timeline Description automatically generated
You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow) Chart, bar chart Description automatically generated
Select Add to Context on the State filter
Graphical user interface, text, application, chat or text message Description automatically generated
A picture containing graphical user interface Description automatically generated
NEW QUESTION 77
......
Tableau Desktop Certified Associate Fundamentals-Desktop-Certified-Associate Exam-Practice-Dumps: https://www.passtestking.com/Tableau/Desktop-Certified-Associate-practice-exam-dumps.html