[Jan-2022] Download Real Tableau Desktop-Certified-Associate Exam Dumps Test Engine Exam Questions
New Desktop-Certified-Associate exam dumps Use Updated Tableau Exam
NEW QUESTION 12
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, $2275
- B. 26, $325
- C. 26.5, $325
- D. 26.5, $2275
Answer: D
Explanation:
Graphical user interface Description automatically generated with medium confidence
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
NEW QUESTION 13
Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all categories by customers who have purchased any product which contains the word 'Avery'?
- A. 14.52%
- B. 23.41%
- C. 16.86%
- D. 19.65%
Answer: A
Explanation:
Add Product Name filter that contains the word Avery
Graphical user interface, text, application, email Description automatically generated
Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.
Select all these Customers and create a group.
Graphical user interface, text Description automatically generated
Now, right-click on the Customer ID (group) and click on Edit Group
Mark the Include 'Other' Checkbox.
Graphical user interface, text, application Description automatically generated
Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.
Remove the Product Name from filters.
Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 14
In a combined axis chart, using which field we get multiple measures on a single axis?
- A. Measure Names
- B. Measure Values
- C. None of the above
- D. Number of records
Answer: A
Explanation:
By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generated
NEW QUESTION 15
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: A
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 16
Which calculation will color the sales by state, while the city is on the Marks card, as shown in this view?
Larger image
- A. { Exclude [City] : SUM([Sales])}
- B. { Exclude [State] : SUM([Sales])}
- C. {SUM([Sales])}
- D. { Exclude : SUM([Sales])}
Answer: A
Explanation:
Explanation
{ Exclude [City] : SUM([Sales])} => using this calculation we can exclude the City dimension from all the dimensions present in the view. So here SUM(sales) would be the aggregation of sales in the state level only, even though city field is available in the view.
NEW QUESTION 17
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: C
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 18
Connect to the "WorldBank Data" and use the Development Indicators table. Create a country map of the Europe and Central Asia region. Find out which neighboring country of Romania is having a greater average GDP per capita than Romania?
- A. Hungary
- B. Ukraine
- C. Bulgaria
- D. Serbia
Answer: A
Explanation:
Explanation
Drop the Country field to the view.
Drop the Region to the filters shelf and select Europe & Central Asia.
Drop the GDP per capita to the label and change the aggregation to Avg.
NEW QUESTION 19
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
- A. Using Blend
- B. Using Union
- C. Using Join Calculations
- D. Using cross-database join
Answer: C
Explanation:
Explanation
Use join Calculations while joining two tables.
NEW QUESTION 20
Which type of sort is applied in the Ship Mode field?
Larger image
- A. Data Source Order
- B. Nested Sort
- C. Field Sort
- D. Alphabetic Sort
Answer: B
Explanation:
Refer to Nested Sort section:
https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
NEW QUESTION 21
How the ATTR() is defined in Tableau?
- A. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
- B. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END
- C. IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END
- D. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
Answer: B
Explanation:
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function
NEW QUESTION 22
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. California, Idaho, Nevada
- B. Texas, New Mexico, Colorado
- C. New York, Massachusetts, Rhode Island
- D. North Carolina, South Carolina, Virginia
Answer: A
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 23
Connect to the "Global Superstore" data source and use the Orders table. Find out how many new customers were acquired in the year 2014?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
If customer first order is equal to the order date, then this is the new customer.
Create a calculated field to find the first order date:
Find If the order date is equal to the day of first purchase for that customer, flag that row as a
'New Customer'
Find the unique customers:
Drop the Order date to filter shelf and select the year 2014 to find out the new customer acquired in 2014.
Drop New Customer field to Rows and Unique customer field to Text marks card.
NEW QUESTION 24
Connect to the "Global Superstore" data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?
- A. $427
- B. $527
- C. $403
- D. $503
Answer: C
Explanation:
Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.
Drop the City to the view, and add the State to the Filter shelf and select North Carolina.
Also, drop the Order Date to the Filters and select year 2012, 2013, 2014 Graphical user interface, text, application, email Description automatically generated
Now, drop the Profit field to the tooltip. As of now, your view should look like this:
A picture containing map Description automatically generated
Now, we have to find the total profit earned by all the cities in Wake County.
Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.
Graphical user interface, text, application, chat or text message Description automatically generated
To show the County go to the Map->Map Layers.
Check County Names and County Borders.
Graphical user interface, text, application Description automatically generated
the total profit earned by all the cities in Wake County is $403.
A picture containing map Description automatically generated
NEW QUESTION 25
Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
First, find the distinct sports for each country:
Graphical user interface Description automatically generated with medium confidence
It will be created as a Measure, move this to Dimension
Get the distinct countries:
Graphical user interface Description automatically generated with medium confidence
drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.
Chart Description automatically generated
NEW QUESTION 26
Connect to the "Global Superstore" data source and use the Orders table. Create a view using Profit and Sales.
Find out which sub-category is above the profit median but below the sales median value?
- A. Appliances
- B. Storage
- C. Binders
- D. Tables
Answer: C
Explanation:
Drop Sales to columns and profit to rows, and Sub-Category to details.
Add two reference lines, one on the sales axis:
Graphical user interface Description automatically generated
Add similarly on profit axis as well.
Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.
A picture containing chart Description automatically generated
NEW QUESTION 27
How to create custom territories on a map?
- A. Geocode a territory field using another geographic field
- B. Select and group locations on a map
- C. By using a background image on a map
- D. Create a territory from a geographic field
Answer: A,B,D
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_custom_territories.htm
NEW QUESTION 28
Connect to the "Global Superstore" data source and use the Orders table. Which of the customer names are in the Top 20 by sales, calculate the profit ratio for these customers and find out who all are in the bottom 5 in profit ratio (within these customers)?
- A. Sean Miller
- B. Bart Watters
- C. Raymond Buch
- D. Art Ferguson
Answer: A,D
Explanation:
Explanation
Right Click on the Customer Name -> Create -> Set
Graphical user interface, text, application Description automatically generated
Create a calculated field:
Graphical user interface Description automatically generated
Drop the Top 20 by Sales set, Customer Name to Rows.
Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.
Graphical user interface, text, application, chat or text message Description automatically generated
Sort the Profit.
Table Description automatically generated
NEW QUESTION 29
Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?
- A. Right-click on the view, go to format, and provide the URL.
- B. Go to Dashboard->Actions and create the go to URL action
- C. Go to Dashboard->Actions and create the Highlight action
- D. Go to Dashboard->Actions and create the go to sheet action
Answer: A
Explanation:
Go to Dashboard->Actions and create the go to sheet action
Graphical user interface, application Description automatically generated
NEW QUESTION 30
Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than
600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?
- A. 32.38%
- B. 42.84%
- C. 32.25%
- D. 44.33%
Answer: D
Explanation:
Explanation
Create the Calculated field 'Math Performers':
Drop the Math Performer field to the Rows and drop gender to filter, select 'Men' Drop the Number of Records (if tableau version prior to 2020.2) to the Text Or Drop the Education.csv(Count) (tableau version 2020.2 and after) to the Text Apply 'Percent of Total' Quick table calculation to the field on the Text marks card:
NEW QUESTION 31
......
Pass Your Desktop-Certified-Associate Dumps as PDF Updated on 2022 With 110 Questions: https://www.exam4tests.com/Desktop-Certified-Associate-valid-braindumps.html