NEW 2021 Certification Sample Questions Desktop-Certified-Associate Dumps & Practice Exam
Desktop-Certified-Associate Deluxe Study Guide with Online Test Engine
NEW QUESTION 52
Connect to the "Flight" data source and find out which carrier was having the highest percentage of delayed flights in 2013?
- A. American
- B. JetBlue
- C. ExpressJet
- D. Frontier
Answer: D
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 53
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 54
While creating which of the chart type, we turn off the stack marks from the analysis menu?
- A. Combined Axis chart
- B. Box and whisker plots
- C. Bullet graphs
- D. Bar in bar chart
Answer: D
Explanation:
While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.
NEW QUESTION 55
Which of the following are true when you use the cube data source in Tableau?
- A. The cube data source can only be used as a secondary data source for blending data in Tableau.
- B. Data source filters are not available.
- C. You cannot create groups when working with a cube data source.
- D. Forecasting and trend lines are not supported.
Answer: B,C,D
Explanation:
Cube data sources can only be used as the primary data source for blending data in Tableau.
All others are true.
Refer: https://help.tableau.com/current/pro/desktop/en-us/cubes.htm
NEW QUESTION 56
Groups can be used in a calculated field.
- A. True
- B. False
Answer: A
Explanation:
Group can be used in a calculated field
Graphical user interface, text, application Description automatically generated
NEW QUESTION 57
Connect to the "Global Superstore" data source and create a view to show only those orders which were returned. What is the unique number of orders returned in the North Africa region in the office supplies category? Consider only those orders which were shipped using Standard Class ship mode.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Create an inner join between Orders and Returns table using Order ID
Graphical user interface, application Description automatically generated
Create a calculated field to find the unique order.
Graphical user interface, text, application Description automatically generated
Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:
Graphical user interface, text, application Description automatically generated
NEW QUESTION 58
Which of the following is true about spatial files?
- A. None of the above
- B. You cannot create a dual-axis chart using spatial data
- C. You cannot join spatial data source with the non-spatial data source
- D. You cannot apply filters in your view if it is creates using the 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 59
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.294316
- B. 0.180067
- C. 0.133134
- D. 0.167531
Answer: C
NEW QUESTION 60
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 61
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 62
Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Explanation
In WorldCupMatches table, we have the information of Away goals, and in the WorldCups table, we have the information of the Winner team and goal scored.
In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate row for each match. This is the perfect example to use blend as here we need to first aggregate the data from WorldCupMatches table.
Let's establish the blend relationship between these two data sources, on the basis of Country and Year.
Let's use WorldCups as the primary data source, so add the field from this data source to the view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the rows.
In WorldCupMatches data source, create a calculated field :
Drop this field to the Text, and format it so that it will be shown in percentage.
Out of the given options, only in 1934 host country won the world cup
2010 is the correct answer.
NEW QUESTION 63
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.294316
- B. 0.180067
- C. 0.133134
- D. 0.167531
Answer: C
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 64
To create this view, what all you have to do from the following options?
Larger image
- A. Drop the measure to the color marks card
- B. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
- C. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
- D. Add the Columns Totals on Top from Analysis Menu
Answer: A,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 65
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
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 66
__________ 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 67
......
Desktop-Certified-Associate dumps review - Professional Quiz Study Materials: https://learningtree.actualvce.com/Tableau/Desktop-Certified-Associate-valid-vce-dumps.html