[Jan-2022] Updated Tableau Desktop-Certified-Associate Dumps – PDF & Online Engine
Desktop-Certified-Associate.pdf - Questions Answers PDF Sample Questions Reliable
NEW QUESTION 51
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. 39 km
- D. 71 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 52
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. North Africa
- C. Eastern Asia
- 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 53
I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don't need. For example - We don't have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?
Larger image
- A. You will select Format filter and Set Control in a filter card options
- B. You will select Exclude Values in a filter card options
- C. You will select Wild card match in a filter card options
- D. You will select Only Relevant Values in a filter card options
Answer: D
Explanation:
Go to Filter card options, and Select Only Relevant values
Graphical user interface, text, application Description automatically generated
NEW QUESTION 54
Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Create a calculated field to compute the contribution of verbal marks in percentage:
Select the Total Score field and using Show me create a histogram.
Edit the Total Score(bin) and provide the Size of bins as 100:
Drop the % Verbal field to the Label, your view will look like this:
Chart, histogram Description automatically generated
NEW QUESTION 55
__________ function rounds a number to the nearest integer of equal or lesser value.
- A. ROUND
- B. CEILING
- C. BUFFER
- D. FLOOR
Answer: D
Explanation:
Explanation
NEW QUESTION 56
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. Click on the Reset matches button to fix this issue.
- C. The city name must be misspelled. Correct the spelling to fix the issue.
- D. More than one city has that name. Update the data type of the field 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 57
What is the default join type when you blend two data sources?
- A. Left outer join
- B. Outer join
- C. Right join
- D. Inner join
Answer: A
Explanation:
Explanation
Blend is the left outer join after aggregation at the level of granularity.
NEW QUESTION 58
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: A
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 59
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. .48
- B. .51
- C. .55
- D. .42
Answer: D
Explanation:
Enable the Summary Card from Show/Hide menu as shown:
Skewness is .42
Graphical user interface, chart Description automatically generated
NEW QUESTION 60
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 9,103,406,453
- B. Indonesia and 95,055,669
- C. Japan and 9,103,406,453
- D. Japan and 96,812,000
Answer: B
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 61
Which of these chart types are primarily used to compare measures against goals?
- A. Pareto chart
- B. Bullet graphs
- C. Histogram
- D. Bar-in-Bar Chart
Answer: B,D
Explanation:
Explanation
Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.
NEW QUESTION 62
Using the metadata grid, you can rename the remote fields.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Explanation
We can rename the field from the metadata grid, but not the remote fields.
Remote field cannot be renamed by any means from Tableau
NEW QUESTION 63
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 64
How to rename the Measure Names field in Tableau?
- A. Rename the field from the Data Source page
- B. Rename the field from the Metadata grid
- C. None of the above
- D. Right Click on Measure Names, and select Rename
Answer: C
Explanation:
Measure Names is Tableau generated field, so you cannot rename it.
NEW QUESTION 65
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 66
Connect to the "Global Superstore" data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?
- A. Bush Classic Bookcase, Pine
- B. Cisco Smart Phone, Full Size
- C. Belkin Router, USB
- D. Nokia Smart Phone, with Caller ID
Answer: A
Explanation:
Explanation
Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.
Drop the Product Name to the Rows and Profit to the Text.
Drop the Market to the filter and select the Europe.
Your view will look like this:
Here, you are getting only 9 products.
Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.
View:
NEW QUESTION 67
Which of the following are true regarding custom geocoding and data blending?
- A. You can create new geographic roles both in data blending and custom geocoding
- B. In data blending, you can use any data but custom geocoding requires text file based data
- C. Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending
- D. Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending
Answer: B,C
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 68
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 69
Which of the following map layers are available in Tableau?
- A. Neighborhoods
- B. Points of Interest
- C. Cities Borders
- D. Area Code Labels
Answer: A,B,D
NEW QUESTION 70
Why we convert a numeric measure to a dimension?
- A. To show the labels in your view
- B. To disaggregate the field
- C. To aggregate the field
- D. To use this field in LOD
Answer: B
Explanation:
Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.
NEW QUESTION 71
To create a choropleth map, your data source should include the following types of information?
- A. Location names or custom polygons
- B. Custom Territories
- C. Background image
- D. Quantitative or qualitative values
Answer: A,D
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_howto_choropleth.htm
NEW QUESTION 72
When we create a filter action in a dashboard, what all we must specify so that it will work?
- A. Run action on
- B. Target filter on Selected fields
- C. Source Sheet
- 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 73
......
Tableau Desktop-Certified-Associate Dumps PDF Are going to be The Best Score: https://www.testpdf.com/Desktop-Certified-Associate-exam-braindumps.html
