Salesforce Analytics-Con-301 Exam Dumps (V9.02): Reliable Study Materials to Help You Prepare for the Salesforce Certified Tableau Consultant Exam

1. A client has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departments give different answers to the same business questions, and the departments cannot trust the data. The client wants to know what causes data sources to return different data.

Which tool should the client use to identify this issue?

2. SIMULATION

From the desktop, open the NYC Property Transactions workbook.

You need to record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook. Ensure that you start the recording as soon as you open the workbook. Open the Property Transactions dashboard, reset the filters on the dashboard to show all values, and

stop the recording. Save the recording in C:CCData.

Create a new worksheet in the performance recording. In the worksheet, create a bar chart to show the elapsed time of each command name by worksheet, to show how each sheet in the Property Transactions dashboard contributes to the overall load time.

From the File menu in Tableau Desktop, click Save. Save the performance recording in C:CCData.

3. A transport and delivery company uses a command center dashboard in its logistics and distribution hubs. The dashboard is displayed on screens to show fleet movements, delivery status, and warehouse operations. The company needs the dashboard to provide up-to-date information without human intervention. The company's environment cannot access the internet, and the data source is configured to maintain a real-time connection.

How should the company meet this requirement?

4. A client is using Tableau to visualize data by leveraging security token-based credentials. Suddenly, sales representatives in the field are reporting that they cannot access the necessary workbooks. The client cannot recreate the error from their offices, but they have seen screenshots from the field agents. The client wants to restore functionality for the field agents with minimal disruption.

Which step should the consultant recommend to accomplish the client's goal?

5. A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version.

The data is stored in the format shown below in the related table, with a NULL Browser ID stored in the Site Visitor Table if an unknown browser version accesses their website.

The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed. The client wants to improve the performance of the dashboard while also getting an accurate count of site visitors.

Which modifications to the data tables and join should the consultant recommend?

6. A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server audit, a consultant notices that the asset permissions for the client's top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.

The consultant recommends checking "Apply to Nested Projects" to enforce compliance.

Which impact will the consultant's recommendation have on access to the existing nested projects?

7. 1.A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.

Which calculation should the consultant use?

8. An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.

The consultant needs to know the average number of days that a customer must wait before a product is shipped.

Which calculation should the consultant use?

9. A client is considering migrating from Tableau Server to Tableau Cloud.

Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.

10. A client has a large data set that contains more than 10 million rows.

A consultant wants to calculate a profitability threshold as efficiently as possible.

The calculation must classify the profits by using the following specifications:

. Classify profit margins above 50% as Highly Profitable.

. Classify profit margins between 0% and 50% as Profitable.

. Classify profit margins below 0% as Unprofitable.

Which calculation meets these requirements?

11. A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.

How should the shipping clerk create a chart that depicts the above information?

12. A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.

Which two actions should the client use to access the necessary metadata? Choose two.

13. A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.

Which approach should the consultant recommend for the client to make this determination?

14. SIMULATION

From the desktop, open the CC workbook.

Open the Incremental worksheet.

You need to add a line to the chart that shows the cumulative percentage of sales contributed by each product to the incremental sales.

From the File menu in Tableau Desktop, click Save.

15. SIMULATION

From the desktop, open the CC workbook.

Open the City Pareto worksheet.

You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle.

From the File menu in Tableau Desktop, click Save.

16. SIMULATION

From the desktop, open the CC workbook.

Open the Manufacturers worksheet.

The Manufacturers worksheet is used to analyze the quantity of items contributed by each manufacturer.

You need to modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression that calculates the percentage contribution of each manufacturer to the total quantity.

Enter the percentage for Newell to the nearest hundredth of a percent into the Newell % Contribution parameter.

From the File menu in Tableau Desktop, click Save.

17. A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client's requirements?

18. A client's fiscal calendar runs from February 1 through January 31.

How should the consultant configure Tableau to use the client's fiscal calendar when building date charts?

19. A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of the report to the sales and marketing groups in the most efficient manner.

Which approach should the consultant recommend?

20. A client has a published data source in Tableau Server and they want to revert to the previous version of the data source. The solution must minimize the impact on users.

What should the consultant do to accomplish this task?

21. A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.

Which calculation should the consultant recommend?

22. A company has a data source for sales transactions.

The data source has the following characteristics:

. Millions of transactions occur weekly.

. The transactions are added nightly.

. Incorrect transactions are revised every week on Saturday.

・ The end users need to see up-to-date data daily.

A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.

What should the consultant do to create and publish the data?

23. A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.

. Group 1: Viewers who cannot see any information on profitability

. Group 2: Viewers who can see profit and profit margin

. Group 3: Viewers who can see profit margin but not the value of profit

Which approach should the consultant use to provide the required level of access?

24. A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud.

The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer]

Which column in the table below should the data analyst reference in the calculation?

25. SIMULATION

From the desktop, open the CC workbook. Use the US Population Estimates data source.

You need to shape the data in US Population Estimates by using Tableau Desktop.

The data must be formatted as shown in the following table.

Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter.

From the File menu in Tableau Desktop, click Save.

26. SIMULATION

Use the following login credentials to sign in to the virtual machine:

Username: Admin

Password: The following information is for technical

support purposes only: Lab Instance: 40201223

To access Tableau Help, you can open the Help.pdf file on the desktop.

From the desktop, open the CC workbook.

Open the Categorical Sales worksheet.

You need to use table calculations to compute the following:

. For each category and year, calculate the average sales by segment.

. Create another calculation to compute the year-over-year percentage change of the average sales by category calculation.

Replace the original measure with the year-over-year percentage change in the crosstab.

From the File menu in Tableau Desktop, click Save.

27. A client is using the Tableau Content Migration Tool to move content from an old Tableau Server to a new Tableau Server.

Which content will need to be moved using a different tool or process?

28. A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals.

The files have the following attributes:

. All files have the same schema.

. Multiple files have something in common among their file names.

. Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

29. A client wants to provide sales users with the ability to perform the following tasks:

・ Access published visualizations and published data sources outside the company network.

・ Edit existing visualizations.

・ Create new visualizations based on published data sources.

. Minimize licensing costs.

Which site role should the client assign to the sales users?

30. A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.

What should the consultant recommend to limit the data source for optimal performance?

31. An analyst needs to interactively set a reference date to drive table calculations without leaving a view.

Which action should the analyst use?

32. A client wants to flag orders that have sales higher than the regional average.

Which calculated field will produce the required result?

33. For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.

What is the most performant approach to model the data for a live connection?

34. A client wants to see the average number of orders per customer per month, broken down by region.

The client has created the following calculated field:

Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}

The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.

The client asks a consultant to rewrite the calculation so the result meets their expectation.

Which calculation should the consultant use?

35. A client has a dashboard that uses a bar chart to visualize sales by Sub-Category and a detail table that has all the orders for the products within Sub-Category. The table has more than 10,000 rows of data and is slow to load.

A consultant plans to add an action so when the client interacts with the bar chart, only the relevant data appears in the table.

What will provide the fastest rendering of the dashboard?

36. An executive-level workbook leverages 37 of the 103 fields included in a data source. Performance for the workbook is noticeably slower than other workbooks on the same Tableau Server.

What should the consultant do to improve performance of this workbook while following best practice?

37. A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.

Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.

Which approach should the consultant use to produce the desired result?

38. A client is migrating their data warehouse. They visualize the data in workbooks hosted on Tableau Server with Tableau Data Management enabled and want to see how many workbooks will be impacted.

What should the consultant do to quickly identify how many workbooks will be impacted?

39. A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there is a performance difference among these three data types.

What should the consultant tell the customer?

40. A client uses Tableau Data Management and notices that when they view a data source, they sometimes see a different count of workbooks in the Connected Workbooks tab compared to the lineage count in Tableau Catalog.

What is the cause of this discrepancy?