Quality Desktop-Certified-Associate PDF Dumps - Desktop-Certified-Associate Exam Questions
Most UptoDate Tableau Desktop-Certified-Associate Exam Dumps PDF 2021
NEW QUESTION 35
When we blend the data, sometimes a Null value appears in place of data. What could be the possible reasons for the same?
- A. The data to combine is at different level of detail.
- B. The secondary data source does not contain values for the corresponding values in the primary data source.
- C. The data types of the fields you are blending on are different.
- D. The values in the primary and secondary data sources use different casing.
Answer: B,C,D
Explanation:
Explanation
Refer section "Null values appear after blending data sources" at
https://help.tableau.com/current/pro/desktop/enus/
multipleconnections_troubleshooting.htm
NEW QUESTION 36
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. Storage
- C. Tables
- D. Binders
Answer: D
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 37
Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.
- A. $3,251
- B. $987
- C. $517
- D. $3,448
Answer: C
Explanation:
Select California State from the Map
NEW QUESTION 38
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. 5.03%
- B. 4.53%
- C. 3.45%
- D. 4.90%
Answer: C
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 39
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.03
- D. 78.286
Answer: D
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 40
In a combined axis chart, using which field we get multiple measures on a single axis?
- A. None of the above
- B. Measure Values
- C. Number of records
- D. Measure Names
Answer: D
Explanation:
By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generated
NEW QUESTION 41
Which of the following are true regarding the data highlighter in Tableau?
- A. You can turn on the highlighter for any field available in your view.
Table Description automatically generated
- B. If you want to change the format for the highlighter card after you turn it on, select Format > Highlighter.
- C. If you update the underlying data source for your view the data shown in the highlighter is automatically updated too.
- D. If you have multiple highlighters showing on a dashboard, only one highlighter can be active at a time.
Answer: B,C,D
Explanation:
The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.
Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm
NEW QUESTION 42
Connect to the "Flight" data source and create a hierarchy as City-Airport Name-Carrier Name. Find out which combination was having the lowest number of on-time flights?
- A. Boston-Logan International-SkyWest
- B. Phoenix-Phoenix Sky Harbor International-Pinnacle
- C. Orlando-Orlando International-SkyWest
- D. Salt Lake City-Salt Lake City International-Mesa
Answer: B
Explanation:
Explanation
Create a hierarchy using City-Airport Name-Carrier Name.
Filter using Ontime Category field and select the Ontime.
Drop the hierarchy to the view and Number of flights to the Text.
Check each combination from the answers:
NEW QUESTION 43
Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than
600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?
- A. 42.84%
- B. 32.25%
- C. 32.38%
- D. 44.33%
Answer: D
Explanation:
Explanation
Create the Calculated field 'Math Performers':
Drop the Math Performer field to the Rows and drop gender to filter, select 'Men' Drop the Number of Records (if tableau version prior to 2020.2) to the Text Or Drop the Education.csv(Count) (tableau version 2020.2 and after) to the Text Apply 'Percent of Total' Quick table calculation to the field on the Text marks card:
NEW QUESTION 44
When it is recommended to create multiple table extracts?
- A. None of the above
- B. If we are using extract filters to limit the data
- C. If incremental refresh is configured
- D. If row-level security needs to be enforced
Answer: D
Explanation:
It is recommended to create multiple table extracts when row-level security needs to be enforced.
Refer:
https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776
NEW QUESTION 45
How the ATTR() is defined in Tableau?
- A. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
- B. IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END
- C. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
- D. IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END
Answer: D
Explanation:
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function
NEW QUESTION 46
Extract can't be created in which of the scenario?
- A. When you perform the blend
- B. When you perform cross-database joins
- C. When you perform the union
- D. When you perform the traditional join
Answer: A
Explanation:
A blend is worksheet-specific, so you cannot create the extract while creating a blend.
NEW QUESTION 47
In table calculations, partitioning fields define the direction of the calculation.
- A. FALSE
- B. TRUE
Answer: A
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 48
How to add reference lines in a view? (Select correct two answers)
- A. Using Data Pane
- B. Using Analysis Menu
- C. Using Analytics pane
- D. Right Click on Axis and Add Reference Line
Answer: C,D
Explanation:
Using Analytics pane:
Graphical user interface, application Description automatically generated
Right Click on Axis and Add Reference Line:
Graphical user interface, application Description automatically generated
NEW QUESTION 49
Connect to the "Global Superstore" data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?
- A. Exponential
- B. Linear
- C. Polynomial, Degree 3
- D. Polynomial, Degree 2
Answer: B
Explanation:
Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.
Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.
Chart, line chart Description automatically generated
NEW QUESTION 50
Use custom geocoding, when you need ___________ locations to map your data.
- A. User-defined
- B. Default
- C. Tableau generated
- D. States
Answer: A
Explanation:
Explanation
Custom geocoding means that you assign latitude and longitude coordinates toyour locations so Tableau can plot them accurately.
Refer:https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm
NEW QUESTION 51
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. Copiers
- B. Paper
- C. Labels
- 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 52
Connect to the "Global Superstore" data source and use the Orders table. Create a map that shows the number of unique customers in Australia. Find the state of Queensland. Which neighboring state has the minimum number of unique customers?
- A. Australian Capital Territory
- B. New South Wales
- C. Northern Territory
- D. South Australia
Answer: C
Explanation:
Explanation
Drop the country field to the view and also to the filter and select Australia.
Drop the State to the detail marks card.
Create the Unique Customer field to the Label.
Your view will look like this:
Northern Territory has the minimum unique customers - 19.
NEW QUESTION 53
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. Japan
- C. Indonesia
- D. United States
Answer: D
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 54
What are the types of annotations available in Tableau?
- A. Area
- B. Circle
- C. Point
- D. Mark
Answer: A,C,D
Explanation:
Graphical user interface, application, table Description automatically generated
NEW QUESTION 55
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. $403
- C. $527
- D. $503
Answer: B
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 56
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: D
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 57
Which of these chart types are primarily used to compare measures against goals?
- A. Histogram
- B. Bullet graphs
- C. Bar-in-Bar Chart
- D. Pareto chart
Answer: B,C
Explanation:
Explanation
Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.
NEW QUESTION 58
......
100% Free Tableau Desktop Certified Associate Desktop-Certified-Associate Dumps PDF Demo Cert Guide Cover: https://www.actual4dump.com/Tableau/Desktop-Certified-Associate-actualtests-dumps.html