Desktop-Certified-Associate Updated Exam Dumps [2021] Practice Valid Exam Dumps Question
Desktop-Certified-Associate Sample with Accurate & Updated Questions
NEW QUESTION 50
We can create variable size bins using ___________?
- A. Calculated Fields
- B. Groups
- C. Hierarchies
- D. Sets
Answer: A
Explanation:
Only by using Calculated fields you can create a variable size bin.
NEW QUESTION 51
Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Add the Latitude to Rows and Longitude to columns. Or double click on these fields.
Don't use Latitude (generated)/Longitude (generated) fields.
Drop Location to filter and select 'Alaska Peninsula'
Drop Name to the Label Marks card.
Your view will look like this:
Map Description automatically generated
Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.
A picture containing chart Description automatically generated
There were no eruptions that took place with 30 miles of Black Peak.
NEW QUESTION 52
Why we convert a numeric measure to a dimension?
- A. To aggregate the field
- B. To use this field in LOD
- C. To show the labels in your view
- D. To disaggregate the field
Answer: D
Explanation:
Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.
NEW QUESTION 53
Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?
- A. Western US
- B. Eastern Asia
- C. North Africa
- D. Southern Africa
Answer: D
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 54
Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?
- A. Education
- B. Wholesale
- C. Entertainment
- D. Retail
Answer: B
Explanation:
Create a box plot using Sector and Loan amount.
Chart, box and whisker chart Description automatically generated
The IQR is maximum for the Wholesale sector.
NEW QUESTION 55
You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image
- A. More than one city has that name. Adjust the geographic roles to fix this issue.
- B. More than one city has that name. Update the data type of the field to fix this issue.
- C. The city name must be misspelled. Correct the spelling to fix the issue.
- D. Click on the Reset matches button to fix this issue.
Answer: A
Explanation:
Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.
NEW QUESTION 56
To create this view, what all you have to do from the following options?
Larger image
- A. Add the Columns Totals on Top from Analysis Menu
- B. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
- C. Drop the measure to the color marks card
- D. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
Answer: B,C
Explanation:
Option 1 - It is not valid, as we are not showing Columns Totals on Top.
Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.
Rest are true.
NEW QUESTION 57
Which of the following are true regarding parameter actions?
- A. While creating the parameter action, you must specify the aggregation.
- B. The aggregation that you choose for the parameter action can be different than the aggregation used for the field in the view.
- C. You can create multiple parameter actions in your dashboard.
- D. Using parameter action, you can update the reference line.
Answer: B,C,D
Explanation:
While creating the parameter action, it is not mandatory to specify the aggregation.
All others are true.
Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm
NEW QUESTION 58
Connect to the "Significant Volcano Eruption" data source. Find out the distance between Okmok and Vsevidof volcanoes in Aleutian Island?
- A. 50 km
- B. 64 km
- C. 71 km
- D. 39 km
Answer: A
Explanation:
Explanation
Drop the longitude field to Columns and latitude to Rows.
Add Location filter and select Aleutin IS
Drop the Name field to Labels
Your view will look like this:
We need to find in Km so go to Map -> Map options and select Units as Metric
Use the radial selection tool to find out the distance between Okmok and Vsevidof volcanoes
NEW QUESTION 59
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 60
In a box plot, how we can calculate the length of the Upper whisker?
- A. Upper whisker = Upper hinge + (1.5 * IQR)
- B. Upper whisker = IQR + (1.5 * IQR)
- C. Upper whisker = Lower hinge + (1.5 * IQR)
- D. Upper whisker = (Upper hinge - Lower hinge) + (1.5 * IQR)
Answer: A
Explanation:
Explanation
The upper whiskers extends to 1.5 * IQR
The length of the upper whisker is upper hinge + 1.5 * IQR.
NEW QUESTION 61
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 62
Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan
2021?
- A. 118.50%
- B. 113.50%
- C. 125%
- D. 98%
Answer: B
Explanation:
Create a filter on date field and select only July 2020 and Jan 2021.
Graphical user interface, application Description automatically generated
Drop Date Month Discrete to Columns and New cases to the Text.
Right-Click on New Cases field and Quick Table Calc ->Percent Difference Graphical user interface, application Description automatically generated
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 63
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. Binders
- C. Storage
- D. Tables
Answer: B
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 64
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: A
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 65
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
NEW QUESTION 66
Connect to the "WorldBank Data" and use the Development Indicators table. Create a relationship between the avg. birth rate and avg. death rate using scatterplot aggregated at the region level, plot death rate on Y-axis and birth rate on X-axis. Add an exponential trendline and find out how many regions are above the trend line?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
After following the steps mentioned in the question your view will look like this:
Here, 5 points are above the exponential trend line.
NEW QUESTION 67
Connect to the "Global Superstore" data source and find out which 'Customer Name' (ignore the customer ID) has returned the highest percentage of his\her orders?
- A. Daniel Lacy
- B. Yoseph Carroll
- C. Michael Oakman
- D. Greg Tran
Answer: A
Explanation:
Left join the Orders and Returns table
Diagram Description automatically generated
Number of orders returned will be order ID from the returns table divide by total orders Graphical user interface, text, application, website Description automatically generated
Drop the customer name and ret order field in the view.
Graphical user interface, text, application, chat or text message Description automatically generated
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 68
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 69
Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Add year and location filter as:
Graphical user interface, application Description automatically generated
Graphical user interface, text, application Description automatically generated
Drop Name, year, month to the rows. Change year and month to discrete from continuous.
A picture containing chart Description automatically generated
So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.
You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.
Map Description automatically generated
NEW QUESTION 70
What are the types of annotations available in Tableau?
- A. Circle
- B. Mark
- C. Point
- D. Area
Answer: B,C,D
Explanation:
Graphical user interface, application, table Description automatically generated
NEW QUESTION 71
__________ function rounds a number to the nearest integer of equal or lesser value.
- A. ROUND
- B. BUFFER
- C. CEILING
- D. FLOOR
Answer: D
Explanation:
Explanation
NEW QUESTION 72
Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in
2014? Use Customer ID.
- A. 3.45%
- B. 5.03%
- C. 4.53%
- D. 4.90%
Answer: A
Explanation:
Explanation
Approach 1 - Using Groups
Drop the Customer ID to the Rows.
Add sub-category to the filter and select phone.
Add Order date to the filter and select the year 2014.
Select all the customers and click on paper clip icon to create the group.
So here we got all the customers who have purchased any product in the Phones subcategory in 2014.
Edit the group and select Include other
Clear the filter shelf, and again add Order date to the filter and select 2015.
Drop Sales to the Text.
Add 'Percent of Total' Quick Table Calculation to the Sales field.
Your view will look like this:
Approach 2 - Using LOD
Create a LOD expressions as:
It will return 1 for the customers who have purchased any product in the Phones sub-category in 2014. For others, it will return 0.
Drop this field to the Rows and add Order date to the filter and select the year 2015.
NEW QUESTION 73
Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?
- A. 0.133134
- B. 0.180067
- C. 0.294316
- D. 0.167531
Answer: A
Explanation:
Go to the Dashboard menu -> Actions -> Add Action -> Filter
Configure the properties as:
Graphical user interface Description automatically generated
Ensure that West Region should be selected in the Region filter.
The final view should be:
Map Description automatically generated
profit increase by 0.133134 for each dollar of sales for the California state
NEW QUESTION 74
......
Pass Tableau Desktop-Certified-Associate Premium Files Test Engine pdf - Free Dumps Collection: https://www.surepassexams.com/Desktop-Certified-Associate-exam-bootcamp.html