Practice Free Salesforce Certified Tableau Consultant Exam Online Questions
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?
- A . Request that a server administrator restore a Tableau Server backup.
- B . Delete and recreate the data source manually.
- C . Select a previous version from Tableau Server, download it, and republish that data source.
- D . Select a previous version from Tableau Server, and then click Restore.
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?
- A . Current custom access will be maintained, but new custom permissions will not be granted.
- B . Access will be automatically rolled back to the top-level project permissions immediately.
- C . Users will be prompted to manually update permissions for all nested projects.
- D . Users will be notified that they will automatically lose access to content after 30 days.
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?
- A . Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and use the calculation in the view in the report.
- B . Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table data to create user filters in the report.
- C . Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to Group 2 and use the calculation in the view in the report.
- D . Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
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?
- A . Add a filter action, set "Run action on" to Select, and set "Clearing the selection will" to Exclude all values.
- B . Add a highlight action and set Target Highlighting to Sub-Category.
- C . Add a highlight action and set Target Highlighting to All Fields.
- D . Add a filter action, set "Run action on" to Menu, and set "Clearing the selection will" to Show all values.
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?
- A . Strings are fastest, followed by integers, and then Booleans.
- B . Integers are fastest, followed by Booleans, and then strings.
- C . Strings, integers, and Booleans all perform the same.
- D . Booleans are fastest, followed by integers, and then strings.
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?
- A . Relating the tables in Tableau Desktop
- B . Blending the first two tables with the third
- C . Joining the tables in Tableau Prep
- D . Joining the tables in Tableau Desktop
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?
- A . Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
- B . Publish a live connection to Tableau Server.
- C . Publish an incremental refresh every Saturday.
- D . Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.