Dumps Moneyack Guarantee - Desktop-Certified-Associate Dumps UpTo 50% Off
Updated Oct-2021 Pass Desktop-Certified-Associate Exam - Real Practice Test Questions
NEW QUESTION 61
Connect to the "Global Superstore" data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?
- A. Labels
- B. Paper
- C. Copiers
- D. Tables
Answer: A,C,D
Explanation:
Graphical user interface, application Description automatically generated
Drop Region at the filter and Select Canada
Drop Profit to columns and Sub-Category to Rows
Then drop the target profit to profit axis, it will create the combined axis chart.
Chart, bar chart Description automatically generated with medium confidence
Now drop the Measure Names field from the Rows to the Color Marks Card.
Chart, bar chart Description automatically generated
Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from
0)
Graphical user interface Description automatically generated with medium confidence
Tables, Labels and Copiers sub-categories has met or exceed the target profit.
Chart Description automatically generated
NEW QUESTION 62
Which of these dashboard actions do not have target sheets?
- A. Go to URL
- B. Change Parameters
- C. Change Set Values
- D. Filter
Answer: A,C
Explanation:
Explanation
Go to the menu Dashboard -> Action -> Add Action
Select Filter, here you will find the Target Sheets
For all other options, you will not find the Target Sheets. Try it yourself.
NEW QUESTION 63
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: A
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 64
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 65
Using the metadata grid, you can rename the remote fields.
- A. TRUE
- B. FALSE
Answer: B
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 66
Connect to the "Significant Volcano Eruption" data source. Using the elevations field, create bins of size 1000 and find out in which bin has the most total deaths?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Select the 'Elevation' field from measures, and go to show me. Click on Histogram.
Right-Click on the "Elevation (bin)" dimension and select Edit. Change the size of bins to 1000.
Graphical user interface, application Description automatically generated
Drop the Total Death to Label.
Chart, histogram Description automatically generated
The total number of deaths reported in the bin of 2000.
Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.
NEW QUESTION 67
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 68
Connect to the "Global Superstore" data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015. What is the profit value of January 2016?
- A. $33,759
- B. $39,921
- C. $46,917
- D. $35,152
Answer: D
Explanation:
Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:
Graphical user interface, text, application Description automatically generated
Go to the Analytics tab and drop the Forecast to your view.
Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months, Graphical user interface, text, application Description automatically generated
$35,152 is the correct answer.
Graphical user interface, chart, line chart Description automatically generated
NEW QUESTION 69
When we create a filter action in a dashboard, what all we must specify so that it will work?
- A. Target Sheet
- B. Source Sheet
- C. Run action on
- D. Target filter on Selected fields
Answer: A,B,C
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 70
Connect to the "Life Expectancy at birth" data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after
2000 for New Zealand.
- A. 78.303
- B. 78.56
- C. 78.286
- D. 78.03
Answer: C
Explanation:
Connect to the "Life Expectancy at birth" excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.
Graphical user interface, application Description automatically generated
Use the data Interpreter, it will correct the data.
Graphical user interface, text, application Description automatically generated
Select the column 1960 to 2000. And Click on the Pivot option
Graphical user interface, text, application Description automatically generated
Rename the two new columns as 'Years' and 'Life Expectancy'
Graphical user interface, application Description automatically generated
Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.
Graphical user interface, text, application, email Description automatically generated
Now, select column 2001 to 2013 and Select Add data to Pivot.
A picture containing graphical user interface Description automatically generated
Select Country and Country Name field, Merge these fields.
Graphical user interface, application Description automatically generated
Rename the merged field as Country.
Let's create the view.
Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).
Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average
Again, right-click on it and edit the table calculation.
Graphical user interface, application Description automatically generated
Update the values as:
Graphical user interface, application, Word Description automatically generated
Result is:
Graphical user interface, application, Word Description automatically generated
NEW QUESTION 71
In table calculations, partitioning fields define the direction of the calculation.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
Explanation
When you add a table calculation, you must use all dimensions in the level of detail either for partitioning (scoping) or for addressing (direction).
Refer:https://help.tableau.com/current/pro/desktop/enus/
calculations_tablecalculations.htm
NEW QUESTION 72
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. Education
- B. Public Affairs
- C. Communication
- D. Business
Answer: B,D
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 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
NEW QUESTION 74
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. Cisco Smart Phone, Full Size
- B. Nokia Smart Phone, with Caller ID
- C. Belkin Router, USB
- D. Bush Classic Bookcase, Pine
Answer: D
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 75
Connect to the "Flight" data source and find out which carrier was having the highest percentage of delayed flights in 2013?
- A. American
- B. Frontier
- C. JetBlue
- D. ExpressJet
Answer: B
Explanation:
Explanation
Create the calculated field:
Drop the carrier name to the view and % of delayed flights to text.
We only have 2013 data, so filter won't make a difference:
NEW QUESTION 76
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 77
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 Exclude Values in a filter card options
- B. You will select Only Relevant Values in a filter card options
- C. You will select Format filter and Set Control in a filter card options
- D. You will select Wild card match in a filter card options
Answer: B
Explanation:
Go to Filter card options, and Select Only Relevant values
Graphical user interface, text, application Description automatically generated
NEW QUESTION 78
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 79
Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?
- A. All of the above
- B. Click the 3 dots on right of your phone layout option and select Auto-Generate Layout
- C. Click the 3 dots on right of your phone layout option and select Optimize Layout
- D. Click the open lock icon on right of your phone layout option
Answer: B,D
Explanation:
Explanation
Refer:https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.htm Go to the section- Phone layouts and the Default dashboard
NEW QUESTION 80
In your view, you are using a background image. How can you find the X and Y coordinates on your image?
- A. Using drop lines
- B. By annotate an area
- C. By annotate a point
- D. Using custom geocoding
Answer: C
Explanation:
Explanation
https://help.tableau.com/current/pro/desktop/enus/
bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation
%20dialog%20box%2C%20click%20OK.
NEW QUESTION 81
Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?
- A. Education
- B. Construction
- C. Retail
- D. Clothing
Answer: D
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 82
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 83
What is the default join type when you blend two data sources?
- A. Right join
- B. Inner join
- C. Left outer join
- D. Outer join
Answer: C
Explanation:
Explanation
Blend is the left outer join after aggregation at the level of granularity.
NEW QUESTION 84
Connect to the "Significant Volcano Eruption" data source. What percentage of total deaths caused by volcanoes which were having a volcano index greater than 2 and elevation greater than 5000?
- A. 6.58%
- B. 5.61%
- C. 0.27%
- D. 3.45%
Answer: A
Explanation:
Create a calculated field as:
Graphical user interface, text, application Description automatically generated
Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.
Graphical user interface, application Description automatically generated
Graphical user interface, application, table, Word Description automatically generated
NEW QUESTION 85
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 86
......
Download Free Tableau Desktop-Certified-Associate Real Exam Questions: https://www.prep4away.com/Tableau-certification/braindumps.Desktop-Certified-Associate.ete.file.html