Salesforce Certified Tableau Data Analyst Dumps (V8.02) Are Available: The Key to Mastering the Salesforce Certified Tableau Data Analyst Credential

1. DRAG DROP

You have a dataset that contains daily sales by business segment from 2017 to the present.

You want to use monthly historical trends to predict sales by segment in the future.

Which three actions should you perform m order? (Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

2. Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Filter the table to show the Top 10 NOC based on the number of medals won.

3. Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.

Create a filed map to show the distribution of total Sales by State across the United States.

4. You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

5. You have the Mowing two tables that contains data about the books in a library.

Both tables are incomplete so there are books missing from the tables.

You need to combine the tables. The solution must ensure that all the data is retained.

Which type of join should you use?

6. You have a database that includes field named sales, City and Region.

You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.

What should you do?

7. HOTSPOT

You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020. You have a worksheet that shows the orders from 2019.

You need to configure the worksheet to show the orders from 2020 without reloading the data.

Which option should you select?

8. HOTSPOT

You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.

How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula)

9. Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.

Add a distribution band on Profit to show the standard deviation from- 1 to 1.

10. From Tableau Desktop you sign in lo a Tableau Server site.

What appears in the list of available data sources when you search for a published data source?

11. You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer.

Which formula should you use for the filter?

12. You have the Mowing dashboard.

Which two elements are floating? Choose two.

13. Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.

Create a histogram on the Quantity field by using bin size of 3.

14. You have the following dashboard that contains two visualizations.

You want to show only visualization at time. Users must be able to switch between visualizations.

What should you me?

15. You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

16. DRAG DROP

You conned to a Microsoft SQL Server database

You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned

How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

17. You have the following chart that shows the cumulative of sales from various dates.

You want the months to appear as shown in the following chart.

What should you do?

18. You have the following dataset.

When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

19. Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.

Replace the existing data source with the Netflix_2019 data source.

20. HOTSPOT

You have a dataset that has four fields named Category. Profit Sates and Customer Name.

You need to create the following visualization.

21. Open the link to Book1 found on the desktop. Open the sales dashboard.

Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

22. You want to add a comment to March 2020 as shown in the following visualization.

You have the following sets in a Tableau workbook

• Top N Customers

• Customers of 2020

• Top N Products

• Sellers of 2020

Which two sets can you combine? Choose two

23. DRAG DROP

You company has two divisions located in the United States and Germany Bach division has a separate database.

The following is a sample of the sales data for the division in the United States.

The following is a sample of the sales data for me division in Germany.

You have population data in a file named Populatio.csv. the following is a sample of the data.

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.

You need to prepare the data to support the planned visualization. The data source must support being published.

Which four actions should you perform in order? (Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options. Use Answer Area arrows to re-order the options)

24. You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis. You need to configure be shapes to be much larger than the line.

What should you do?

25. You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.

You create several filters.

From the Data Source page you plan to add data source fillers

When type of filter will appear in the Edit Data Source Filters dialog box?

26. 1.You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

27. You have the following tiled dashboard that has one sheet.

You want to replace fit sheet with Sheet2.

What should you do?

28. DRAG DROP

You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.

Which three actions should you perform in orders? (Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

29. Open the link to Book1 found on the desktop. Open the Line worksheet.

Modify the chart to show only main and max values of both measures in each region.

30. You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.

You need to ensure that the extract also refreshes on the last day of the month at 18:00.

What should you do?

31. You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers.

How should you share me dashboard with the healthcare workers?

32. You have a line chart on a worksheet.

You want to add a comment to March 2020 as shown in the following visualization.

What should you do?

33. A colleague provides you with access to a folder that contains the following files:

• Sates.csv

• Bookl.twb

• Sates.hyper

• Export.mdb

Which He contains an extract?

34. You have the following bar chart.

You want the chart to appear as shown in the Mowing exhibit.

What should you add?

35. You are the owner of an alert.

You receive an email notification that the alert was suspended

From where can you resume the suspended alert?

36. You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

37. You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.

What should you select?

38. You have the following visualization.

The Last() calculation is set to compute using Table (across)

Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

39. Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

40. HOTSPOT

You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

41. Open the link to Book1 found on the desktop. Use the Superstore data source.

Split the Customer Name field into two fields named First Name and Last Name.

42. Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.

Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

43. You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.

What should you do from Tableau Desktop?

44. You have the following dataset in Microsoft Excel.

You are using interpreter to cleans the dataset.

Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

45. You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?