Desktop-Certified-Associate PDF Dumps Jan 03, 2022 Exam Questions – Valid Desktop-Certified-Associate Dumps
Ultimate Desktop-Certified-Associate Guide to Prepare Free Latest Tableau Practice Tests Dumps
For more info read reference
Desktop Certified Associate Exam
NEW QUESTION 28
Which of the following are true regarding parameter actions?
- A. While creating the parameter action, you must specify the aggregation.
- B. You can create multiple parameter actions in your dashboard.
- C. Using parameter action, you can update the reference line.
- D. The aggregation that you choose for the parameter action can be different than the aggregation used for the field in the view.
Answer: B,C,D
Explanation:
While creating the parameter action, it is not mandatory to specify the aggregation.
All others are true.
Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm
NEW QUESTION 29
Connect to the "WorldBank Data" and use the Development Indicators table. Create a relationship between the avg. birth rate and avg. death rate using scatterplot aggregated at the region level, plot death rate on Y-axis and birth rate on X-axis. Add an exponential trendline and find out how many regions are above the trend line?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
After following the steps mentioned in the question your view will look like this:
Here, 5 points are above the exponential trend line.
NEW QUESTION 30
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. $527
- B. $427
- C. $403
- D. $503
Answer: C
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 31
Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?
- A. 26.41
- B. 26.02
- C. 26.33
(Correct) - D. 26.72
Answer: C
Explanation:
Drop the Age to the columns and change the aggregation to AVG.
Drop Gold Medals field to filter and select All values ->
Graphical user interface, text, application, email Description automatically generated
Change 1 from 0.
Graphical user interface, application Description automatically generated
NEW QUESTION 32
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 33
Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?
- A. $2,263,137
- B. $483,269
- C. $414,302
- D. $2,385,198
Answer: B
Explanation:
Find the minimum order date for each customer
Graphical user interface, text, website Description automatically generated
Drop the order date, Min Order date, and Sales to the view
A picture containing graphical user interface Description automatically generated
$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.
NEW QUESTION 34
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 35
Which of the following are true regarding custom geocoding and data blending?
- A. Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending
- B. In data blending, you can use any data but custom geocoding requires text file based data
- C. Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending
- D. You can create new geographic roles both in data blending and custom geocoding
Answer: A,B
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 36
To create this view, what all you have to do from the following options?
Larger image
- A. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
- B. Drop the measure to the color marks card
- C. Add the Columns Totals on Top from Analysis Menu
- D. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
Answer: B,D
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 37
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: C
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 38
Use custom geocoding, when you need ___________ locations to map your data.
- A. States
- B. Tableau generated
- C. Default
- D. User-defined
Answer: D
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 39
Which of the following are true when you use the cube data source in Tableau?
- A. You cannot create groups when working with a cube data source.
- B. The cube data source can only be used as a secondary data source for blending data in Tableau.
- C. Forecasting and trend lines are not supported.
- D. Data source filters are not available.
Answer: A,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 40
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. North Carolina, South Carolina, Virginia
- B. California, Idaho, Nevada
- C. New York, Massachusetts, Rhode Island
- D. Texas, New Mexico, Colorado
Answer: B
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 41
Which LOD calculations can be used in Columns shelf to create this view?
Larger image
- A. { FIXED [Region] : SUM([Profit])}
- B. {SUM([Profit])}
- C. { FIXED [Category] : SUM([Profit])}
- D. {FIXED : SUM([Profit])}
Answer: B,D
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 42
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
- A. Using Union
- B. Using Join Calculations
- C. Using Blend
- D. Using cross-database join
Answer: B
Explanation:
Explanation
Use join Calculations while joining two tables.
NEW QUESTION 43
......
Passing Key To Getting Desktop-Certified-Associate Certified Exam Engine PDF: https://pass4sure.examcost.com/Desktop-Certified-Associate-practice-exam.html
