Salesforce Certified Tableau Consultant Exam Dumps (V8.02) – Practice Real Exam Questions to Strengthen Your Trust

1. 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?

2. 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.

3. 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.

4. 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?

5. 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?

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

Which calculation should the consultant recommend?

7. 1.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?

8. 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?

9. 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?

10. 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?

11. 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?

12. 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 BrowserID 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?

13. 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?

14. 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?

15. 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?

16. 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?

17. 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?

18. 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?

19. 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?

20. 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?