[Dec-2021] Tableau Desktop-Certified-Associate DUMPS WITH REAL EXAM QUESTIONS
2021 New TrainingQuiz Desktop-Certified-Associate PDF Recently Updated Questions
NEW QUESTION 20
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 21
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: B
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 22
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 : SUM([Sales])}
- B. { Exclude [City] : SUM([Sales])}
- C. { Exclude [State] : SUM([Sales])}
- D. {SUM([Sales])}
Answer: B
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 23
Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
- A. New York, Massachusetts, Rhode Island
- B. North Carolina, South Carolina, Virginia
- C. Texas, New Mexico, Colorado
- D. California, Idaho, Nevada
Answer: D
Explanation:
Drop the State field to a view, you will get >1k unknown.
Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.
Also, drop the Order Date to the Filters Shelf and choose Years as:
Graphical user interface, application Description automatically generated
Check for the Year 2013.
Drop the Sales field to the Label in the Marks card, your view should look like this:
Graphical user interface Description automatically generated with medium confidence
Now use the Lasso Selection tool from the Map tools:
Graphical user interface, diagram Description automatically generated
And create the group of states as per our answer options.
Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.
Map Description automatically generated
Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.
Graphical user interface, text, application Description automatically generated
NEW QUESTION 24
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
- A. Using Blend
- B. Using Union
- C. Using cross-database join
- D. Using Join Calculations
Answer: D
Explanation:
Explanation
Use join Calculations while joining two tables.
NEW QUESTION 25
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 26
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 27
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. Forecasting and trend lines are not supported.
- C. Data source filters are not available.
- D. You cannot create groups when working with a cube data source.
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 28
Which LOD calculations can be used in Columns shelf to create this view?
Larger image
- A. { FIXED [Category] : SUM([Profit])}
- B. {SUM([Profit])}
- C. {FIXED : SUM([Profit])}
- D. { FIXED [Region] : SUM([Profit])}
Answer: B,C
Explanation:
{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.
{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.
{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.
NEW QUESTION 29
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 secondary data source does not contain values for the corresponding values in the primary data source.
- B. The data to combine is at different level of detail.
- C. The values in the primary and secondary data sources use different casing.
- D. The data types of the fields you are blending on are different.
Answer: A,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 30
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 31
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 32
Which of the following are the valid dashboard actions in Tableau?
- A. Hover action
- B. URL action
- C. Select action
- D. Filter action
Answer: B,D
Explanation:
Graphical user interface Description automatically generated
NEW QUESTION 33
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 34
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 35
Using the Regional Dashboard twbx file, consider the Obesity dashboard to find out how many counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Here we have to use the Obesity View only, so let's go to that sheet:
Click on go to sheet as per above.
Edit the State filter and select only North Carolina:
Duplicate this sheet as Crosstab
3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate.
Graphical user interface, text, application Description automatically generated
Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I find it easy to get the answers.
NEW QUESTION 36
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 37
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 38
You have connected to an excel sheet that has two tables "orders" and "returns". You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?
- A. It will only be enabled once you save the visualization to Tableau Server
- B. It will only be enabled once you perform the join
- C. It will only be enabled once you perform the data blending
- D. It will only be enabled once you perform the union
Answer: B
Explanation:
Explanation
Select the Extract connection and click on Edit as shown:
If you have single table on the canvas, then Multiple tables option remain disabled:
If you create a join, only then Multiple tables option will be enabled:
NEW QUESTION 39
When it is recommended to create multiple table extracts?
- A. If we are using extract filters to limit the data
- B. None of the above
- C. If row-level security needs to be enforced
- D. If incremental refresh is configured
Answer: C
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 40
Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?
- A. 4.02
- B. 3.43
- C. 3.56
- D. 3.39
Answer: C
Explanation:
Create a Calculation to get the first alphabet of the customer name.
Graphical user interface, text, application Description automatically generated
Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:
NEW QUESTION 41
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. $517
- B. $3,448
- C. $987
- D. $3,251
Answer: A
Explanation:
Select California State from the Map
NEW QUESTION 42
Which type of sort is applied in the Ship Mode field?
Larger image
- A. Field Sort
- B. Alphabetic Sort
- C. Data Source Order
- D. Nested Sort
Answer: D
Explanation:
Refer to Nested Sort section:
https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
NEW QUESTION 43
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 44
......
Latest Desktop-Certified-Associate Pass Guaranteed Exam Dumps Certification Sample Questions: https://www.trainingquiz.com/Desktop-Certified-Associate-practice-quiz.html
