Verified Desktop-Certified-Associate dumps Q&As - Pass Guarantee or Full Refund [Nov-2021]
Desktop-Certified-Associate PDF Dumps | Nov 29, 2021 Recently Updated Questions
NEW QUESTION 20
Connect to the "Global Superstore" data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?
- A. Polynomial, Degree 3
- B. Polynomial, Degree 2
- C. Exponential
- D. Linear
Answer: D
Explanation:
Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.
Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.
Chart, line chart Description automatically generated
NEW QUESTION 21
Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?
- A. $483,269
- B. $414,302
- C. $2,263,137
- D. $2,385,198
Answer: A
Explanation:
Find the minimum order date for each customer
Graphical user interface, text, website Description automatically generated
Drop the order date, Min Order date, and Sales to the view
A picture containing graphical user interface Description automatically generated
$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.
NEW QUESTION 22
In a combined axis chart, using which field we get multiple measures on a single axis?
- A. None of the above
- B. Measure Values
- C. Number of records
- D. Measure Names
Answer: D
Explanation:
By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generated
NEW QUESTION 23
Which of the following map layers are available in Tableau?
- A. Points of Interest
- B. Neighborhoods
- C. Cities Borders
- D. Area Code Labels
Answer: A,B,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 24
How the ATTR() is defined in Tableau?
- A. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
- B. IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END
- C. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END
- D. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
Answer: C
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 25
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: D
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 26
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. 23.41%
- B. 14.52%
- C. 16.86%
- D. 19.65%
Answer: B
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 27
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, 0
- B. Galeras, 0
- C. Galeras, 55
- D. Purace, 55
Answer: D
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
Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:
Map Description automatically generated
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
NEW QUESTION 28
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. 42.84%
- B. 44.33%
- C. 32.25%
- D. 32.38%
Answer: B
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 29
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. $503
- D. $403
Answer: D
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 30
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. Bulgaria
- C. Serbia
- D. Ukraine
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 31
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. Create a territory from a geographic field
- D. By using a background image on a map
Answer: A,B,C
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_custom_territories.htm
NEW QUESTION 32
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: B
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 33
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.72
- B. 26.33
(Correct) - C. 26.41
- D. 26.02
Answer: B
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
NEW QUESTION 34
How can we add Visualization in a tooltip?
- A. Go to the Worksheet menu, click on Tooltip and click Insert -> sheets
- B. Go to the Format menu, click on Tooltip and click Insert -> sheets
- C. Go to the Tooltip on the marks card, and click insert -> sheets
- D. Right Click on the view, Tooltip and add insert -> sheets
Answer: A,C
Explanation:
Only 1 and 2 options are correct.
For these types of questions, please take the help of the Tableau software during your exam.
NEW QUESTION 35
Use custom geocoding, when you need ___________ locations to map your data.
- A. User-defined
- B. Default
- C. Tableau generated
- D. States
Answer: A
Explanation:
Explanation
Custom geocoding means that you assign latitude and longitude coordinates toyour locations so Tableau can plot them accurately.
Refer:https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm
NEW QUESTION 36
......
Desktop-Certified-Associate Exam Questions – Valid Desktop-Certified-Associate Dumps Pdf: https://www.newpassleader.com/Tableau/Desktop-Certified-Associate-exam-preparation-materials.html