[Jan-2022] Free Desktop-Certified-Associate Exam Dumps to Improve Exam Score
2022 Realistic Desktop-Certified-Associate Dumps Exam Tips Test Pdf Exam Material
What is the Registration Procedure of Tableau Desktop Certified Associate Exam
The registration procedure for this certification is straightforward. You can simply log onto the site and register for the exam. The only prerequisite needed is that you have previous experience in working with Microsoft Excel. You also need to be a recent graduate or have a Bachelor's degree in a technical field to take part in the examination. Once the exam is taken, the results are available immediately. A passing score will need that you correctly answer at least 70 percent of the questions.
NEW QUESTION 51
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.90%
- C. 4.53%
- D. 3.45%
Answer: D
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 52
Connect to the "Global Superstore" data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?
- A. Standard Class
- B. First Class
- C. Second Class
- D. Same Day
Answer: B,D
Explanation:
Explanation
Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate measures) From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.
Hover on each of the boxes:
Median for the First Class and Same Day ship modes are 84.
NEW QUESTION 53
In LOD calculation, we can use fields from multiple data sources (blended data source)?
- A. False
- B. True
Answer: A
Explanation:
Graphical user interface, text, application, Word, email Description automatically generated
Here, the Location is in a primary data source, and the population field is in a secondary data source.
So the answer is FALSE.
NEW QUESTION 54
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 55
While creating which of the chart type, we turn off the stack marks from the analysis menu?
- A. Combined Axis chart
- B. Bullet graphs
- C. Box and whisker plots
- 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 56
Connect to the "World Cup Results" and use table WorldCups. Create a bar graph using the Year and Matches Played. For how many years the number of matches played was less than 70% of the median?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation
Drop the year to the Columns and change it Discrete. Drop the matches played to the Rows.
Go to the Analytics menu, drop the Distribution band to the view. Select scope as entire table.
Value Computation should be:
Your view will look like this:
NEW QUESTION 57
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 58
Which of the following map layers are available in Tableau?
- A. Area Code Labels
- B. Neighborhoods
- C. Cities Borders
- D. Points of Interest
Answer: A,B,D
NEW QUESTION 59
Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country.
Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?
- A. Japan and 96,812,000
- B. Japan and 9,103,406,453
- C. Indonesia and 95,055,669
- D. Indonesia and 9,103,406,453
Answer: C
Explanation:
Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Graphical user interface, application Description automatically generated
Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
Graphical user interface, text, application Description automatically generated
Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.
Drop the year to the filters shelf and only enter 1963.
Graphical user interface Description automatically generated
Drop Country and Number of Records / volerup(Count) field to the view.
And drop population to the view from the secondary data source. Your view will look like this:
Graphical user interface, text, application, chat or text message Description automatically generated
NEW QUESTION 60
Why we convert a numeric measure to a dimension?
- A. To use this field in LOD
- B. To disaggregate the field
- C. To aggregate the field
- D. To show the labels in your view
Answer: B
Explanation:
Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.
NEW QUESTION 61
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 62
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 63
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 64
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 65
__________ function rounds a number to the nearest integer of equal or lesser value.
- A. BUFFER
- B. ROUND
- C. CEILING
- D. FLOOR
Answer: D
Explanation:
Explanation
NEW QUESTION 66
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. Northern Territory
- C. New South Wales
- D. South Australia
Answer: B
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 67
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. Linear
- B. Polynomial, Degree 3
- C. Exponential
- D. Polynomial, Degree 2
Answer: A
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 68
Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Add the Latitude to Rows and Longitude to columns. Or double click on these fields.
Don't use Latitude (generated)/Longitude (generated) fields.
Drop Location to filter and select 'Alaska Peninsula'
Drop Name to the Label Marks card.
Your view will look like this:
Map Description automatically generated
Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.
A picture containing chart Description automatically generated
There were no eruptions that took place with 30 miles of Black Peak.
NEW QUESTION 69
We can create variable size bins using ___________?
- A. Groups
- B. Calculated Fields
- C. Sets
- D. Hierarchies
Answer: B
Explanation:
Only by using Calculated fields you can create a variable size bin.
NEW QUESTION 70
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 71
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 72
Connect to the "Significant Volcano Eruption" data source. What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Drop year to filter shelf and select from 2000.
Graphical user interface Description automatically generated
Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.
Click on Show Me, and select Box and whisker Plot.
IQR = Upper hinge - Lower hinge
Graphical user interface Description automatically generated with low confidence
Here IQR = 32 -2 = 30
Topic 1, Exam Pool B
Download the Dataset from here:
https://drive.google.com/file/d/1z7LPBQNPWHChteShl0QL3yu_JcvstLGl/view?usp=sharing
Use the above data set to answers the questions under Exam Pool B.
NEW QUESTION 73
Why might this LOD expression for percent of total sales give different results than a table calculation for percent of total sales?
Larger image
- A. The table calculation is not correctly set up
- B. The LOD expression is not correctly set up
- C. The filter is applied before the Table calculation is performed
- D. The market filter is not correctly set up
Answer: C
Explanation:
Explanation
As per the Tableau order of operation, dimension filter is applied before table calculation is computed. However, fixed LOD is executed before the dimension filter. That's why total sales are showing different results.
Reference -https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
NEW QUESTION 74
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. Orlando-Orlando International-SkyWest
- B. Phoenix-Phoenix Sky Harbor International-Pinnacle
- C. Boston-Logan 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 75
......
Is this Certification Worth It?
Certifications have become important in the workplace because of the several benefits they provide. It is a way of encouraging professional development and showing your experience and skills to your employers. You can use this certification as a negotiation tool for salary increases and better working conditions. Skip your regular salary hike for this certification because the benefits are very much real. The certified professionals are preferred over the non-certified professionals because they are knowledgeable, skilled, efficient, and have a higher level of efficiency. Remember that the employers want only the best for them, so you should get this certification because it will enhance your reputation in the industry. Invest in these Tableau Desktop Certified Associate exam dumps and get your certification. Improve your work efficiency and skills by achieving this certification. Desktop Certified Associate Dumps is the best option for you to achieve this certification. Smart Procurement has provided it. Blogs and websites also provide you with the most recent details about this certification exam. Many organizations and companies trust this certification as evidence of your expertise and skills. Post a review about your experience with this certification exam.
Favorite this certification exam because the benefits are real. The latest Tableau Desktop Certified Associate exam dumps are available for you to buy. The working professionals are preferred over the non-working professionals because they are knowledgeable, skilled, efficient, and have a higher level of efficiency. Career opportunities are also given to the certified professionals. They have a better chance of getting promoted to leadership roles or managerial roles because of their experience and knowledge. Device management is also a strong point of this certification exam. Effectively managing all the administrative tasks is a crucial part of this certification exam. Cleared this certification exam, you will be able to work on various projects. The certification exam works as a proof of your skills and abilities. Actions that can be taken now include tableau desktop certified associate exam dumps. Candidates who do not achieve this certification exam experience lower salary and wage increases compared to those who achieve it. Random questions and phrases that cover this certification exam will be asked in the actual certification exam. Days are important in this certification exam.
Powerful Desktop-Certified-Associate PDF Dumps for Desktop-Certified-Associate Questions: https://www.trainingdump.com/Tableau/Desktop-Certified-Associate-practice-exam-dumps.html
Authentic Desktop-Certified-Associate Dumps - Free PDF Questions to Pass: https://drive.google.com/open?id=1P6nGAP60xmmkoz3paoVbT1f5yoIVl88U