Desktop-Certified-Associate Certification Exam Dumps Questions in here [Jan-2022]
Updated Desktop-Certified-Associate Exam Practice Test Questions
What is the Registration Procedure of Tableau Desktop Certified Associate Exam
The registration procedure for this certification is straightforward. You can simply log onto the site and register for the exam. The only prerequisite needed is that you have previous experience in working with Microsoft Excel. You also need to be a recent graduate or have a Bachelor's degree in a technical field to take part in the examination. Once the exam is taken, the results are available immediately. A passing score will need that you correctly answer at least 70 percent of the questions.
NEW QUESTION 15
In a combined axis chart, using which field we get multiple measures on a single axis?
- A. None of the above
- B. Measure Names
- C. Number of records
- D. Measure Values
Answer: B
Explanation:
By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generated
NEW QUESTION 16
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. Japan and 96,812,000
- B. Japan and 9,103,406,453
- C. Indonesia and 95,055,669
- D. Indonesia and 9,103,406,453
Answer: C
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 17
Which of the following is true about spatial files?
- A. None of the above
- B. You cannot apply filters in your view if it is creates using the spatial data source
- C. You cannot create a dual-axis chart using spatial data
- D. You cannot join spatial data source with the non-spatial data source
Answer: A
Explanation:
All are false here.
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm
NEW QUESTION 18
Connect to the "Global Superstore" data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
First, create a set using the Product Name. Select the Top condition as:
Drop this Set to the filters shelf and select IN only.
Drop this Set to the filters shelf and select IN only.
Drop the Category, Top 10 profitable products and Product Name to the view:
NEW QUESTION 19
Connect to the "Global Superstore" data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Drop Order Date to columns, Category to Rows, and Sales to Text.
Go to Analysis -> Totals -> Show Columns Grand Total
Graphical user interface, text, application Description automatically generated
Update Total All Using to Average:
Graphical user interface, text, application Description automatically generated
Table Description automatically generated
In the year 2012, the furniture sales were more than the average sales of that year.
NEW QUESTION 20
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 21
Connect to the "Education" data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
- A. Public Affairs
- B. Business
- C. Communication
- D. Education
Answer: A,B
Explanation:
Explanation
Create a bar chart using field college and Math. Change the Math aggregation to AVG.
Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation to Avg.
Follow the same for Writing field.
Now from the Analytics menu, drop the Distribution band to the view, select the scope as entire table, and select the value as 70 percentiles.
Your view will look like this:
70 percentiles are 547.8
Business and public affairs have all the individual subject values lesser than 547.8.
NEW QUESTION 22
What are the types of annotations available in Tableau?
- A. Circle
- B. Point
- C. Mark
- D. Area
Answer: B,C,D
Explanation:
Graphical user interface, application, table Description automatically generated
NEW QUESTION 23
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: D
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 24
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. 19.65%
- D. 16.86%
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 25
Connect to the "Significant Volcano Eruption" data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?
- A. Chile
- B. United States
- C. Japan
- D. Indonesia
Answer: B
Explanation:
Explanation
Select the measure "Death" and go to the Show Me and Click on Histogram When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin).
Right-click on this and click on Edit. Update the size of bins to 500.
Graphical user interface, application Description automatically generated
Drop the Country to the color, so our view will look like this:
Chart Description automatically generated
Now drop the Country to the filter and select 4 countries mentioned in our options.
Hover the bar, it shows the United States has reported 9 deaths.
Chart Description automatically generated
NEW QUESTION 26
To create a choropleth map, your data source should include the following types of information?
- A. Quantitative or qualitative values
- B. Location names or custom polygons
- C. Background image
- D. Custom Territories
Answer: A,B
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_howto_choropleth.htm
NEW QUESTION 27
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 28
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.58
- C. -0.69
- D. -0.67
Answer: D
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
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
NEW QUESTION 29
Which of the following are the valid dashboard actions in Tableau?
- A. Select action
- B. Filter action
- C. URL action
- D. Hover action
Answer: B,C
Explanation:
Graphical user interface Description automatically generated
NEW QUESTION 30
Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?
- A. Construction
- B. Clothing
- C. Education
- D. Retail
Answer: B
Explanation:
Drop Sector to columns and Funded Amount to Rows.
From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.
Your view will look like this:
Chart, bar chart Description automatically generated
Here, the Clothing funded amount is exactly similar to the Median.
NEW QUESTION 31
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: A
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 32
Which type of sort is applied in the Ship Mode field?
Larger image
- A. Field Sort
- B. Nested Sort
- C. Data Source Order
- 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 33
......
Pass Tableau Desktop Certified Associate Desktop-Certified-Associate Exam With 110 Questions: https://freedownload.prep4sures.top/Desktop-Certified-Associate-real-sheets.html