This page was exported from Top Exam Collection [ http://blog.topexamcollection.com ] Export date:Sat Apr 19 18:54:55 2025 / +0000 GMT ___________________________________________________ Title: [May-2022 Newly Released] Desktop-Certified-Associate Dumps for Tableau Desktop Certified Associate Certified [Q45-Q61] --------------------------------------------------- [May-2022 Newly Released] Desktop-Certified-Associate Dumps for Tableau Desktop Certified Associate Certified Updated Verified Desktop-Certified-Associate dumps Q&As - 100% Pass What is the Salary of Tableau Desktop Certified Associate Certified Professional India : 5021013 RupeesUnited States: 67,000 USDUK: 48850 Pounds   NO.45 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?  United States  Chile  Japan  Indonesia ExplanationSelect 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 generatedDrop the Country to the color, so our view will look like this:Chart Description automatically generatedNow 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 generatedNO.46 Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?  26.33(Correct)  26.41  26.72  26.02 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 generatedChange 1 from 0.Graphical user interface, application Description automatically generatedNO.47 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?  0  1000  2000  3000 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 generatedDrop the Total Death to Label.Chart, histogram Description automatically generatedThe total number of deaths reported in the bin of 2000.Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.NO.48 In Forecast, what is the shaded region?  forecast model  exponential smoothing  prediction interval  none of these ExplanationRefer:https://help.tableau.com/current/pro/desktop/en-us/forecast_create.htmNO.49 Connect to the “Global Superstore” data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?  0  1  2  3 ExplanationFirst, create a set using the Product Name. Select the Top condition as:Drop this Set to the filters shelf and select IN only.Drop this Set to the filters shelf and select IN only.Drop the Category, Top 10 profitable products and Product Name to the view:NO.50 Which of the following are true regarding custom geocoding and data blending?  Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending  In data blending, you can use any data but custom geocoding requires text file based data  Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending  You can create new geographic roles both in data blending and custom geocoding Refer to the quick comparison of data blending and custom geocoding –https://help.tableau.com/current/pro/desktop/en-us/maps_customgeocode_datablend.htmNO.51 Connect to the “Flight” data source and find out which carrier was having the highest percentage of delayed flights in 2013?  JetBlue  Frontier  ExpressJet  American ExplanationCreate 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:NO.52 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?  1  2  3  4 Add year and location filter as:Graphical user interface, application Description automatically generatedGraphical user interface, text, application Description automatically generatedDrop Name, year, month to the rows. Change year and month to discrete from continuous.A picture containing chart Description automatically generatedSo, 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 generatedNO.53 Which of these chart types are primarily used to compare measures against goals?  Bar-in-Bar Chart  Histogram  Bullet graphs  Pareto chart ExplanationBar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.NO.54 Connect to the “Covid data” source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.  -0.56  -0.67  -0.69  -0.58 Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.Click on the Show/Hide card and enable the Summary Card.Chart, line chart Description automatically generatedYou will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.Graphical user interface, application Description automatically generatedNO.55 In a combined axis chart, using which field we get multiple measures on a single axis?  Measure Names  Measure Values  Number of records  None of the above By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generatedNO.56 Connect to the “Global Superstore” data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?  6  8  10  12 ExplanationCalculate the Profit Ratio:Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.Drop the Order date to Rows and drill-down it to Quarters.Drop the profit ratio >.25 field to Text:NO.57 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?  6.58%  0.27%  3.45%  5.61% Create a calculated field as:Graphical user interface, text, application Description automatically generatedDrop 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 generatedGraphical user interface, application, table, Word Description automatically generatedNO.58 Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?  Go to Dashboard->Actions and create the go to URL action  Go to Dashboard->Actions and create the go to sheet action  Go to Dashboard->Actions and create the Highlight action  Right-click on the view, go to format, and provide the URL. Go to Dashboard->Actions and create the go to sheet actionGraphical user interface, application Description automatically generatedNO.59 When it is recommended to create multiple table extracts?  If incremental refresh is configured  If we are using extract filters to limit the data  If row-level security needs to be enforced  None of the above 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-94776NO.60 I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don’t need. For example – We don’t have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?Larger image  You will select Exclude Values in a filter card options  You will select Only Relevant Values in a filter card options  You will select Format filter and Set Control in a filter card options  You will select Wild card match in a filter card options Go to Filter card options, and Select Only Relevant valuesGraphical user interface, text, application Description automatically generatedNO.61 Connect to the “Global Superstore” data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?  Belkin Router, USB  Cisco Smart Phone, Full Size  Nokia Smart Phone, with Caller ID  Bush Classic Bookcase, Pine ExplanationDrop the Product Name to the filters and Select Top 10 based on Sum of Profit.Drop the Product Name to the Rows and Profit to the Text.Drop the Market to the filter and select the Europe.Your view will look like this:Here, you are getting only 9 products.Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.View: Loading … Latest Desktop-Certified-Associate Exam Dumps Tableau Exam from Training: https://www.topexamcollection.com/Desktop-Certified-Associate-vce-collection.html --------------------------------------------------- Images: https://blog.topexamcollection.com/wp-content/plugins/watu/loading.gif https://blog.topexamcollection.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-05-11 07:26:29 Post date GMT: 2022-05-11 07:26:29 Post modified date: 2022-05-11 07:26:29 Post modified date GMT: 2022-05-11 07:26:29