Salesforce Analytics-Con-301 Exam : Salesforce Certified Tableau Consultant

A client calculates the percent of total sales for a particular region compared to all regions.

Which calculation will fix the automatic recalculation on the % of total field?

• A. {FIXED [Region]:sum([Sales])}
• B. {FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])
• C. {FIXED [Region]:sum([Sales])}/SUM([Sales]}
• D. {FIXED [Region]:[Sales]}/{FIXED: SUM([Sales])}

A Tableau consultant is asked to evaluate a workbook that is slow to respond and make a recommendation on possible performance improvements. The workbook connects to three extract data sources from an SQL database. The sheets are used in five dashboards. The consultant runs a performance recording on the workbook and notices that the largest amount of time is spent on rendering the visualizations.
What is the most effective approach to reduce the workbook's rendering time?

• A. Update worksheets to reduce the number of records displayed.
• B. Filter the unused data before bringing it into the workbook.
• C. Change the connections to live.
• D. Change the dashboards' size to Automatic.

A company has a sales team that is segmented by territory. The team's manager wants to make sure each sales representative can see only data relevant to that representative's territory in the team Sales Dashboard.
The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.
What should the consultant recommend to meet the company's requirements?

• A. Create one group for each territory and assign sales representatives to the appropriate groups. Map each group to a territory in the Sales Dashboard. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
• B. Create a user filter in the Sales Dashboard workbook and map each sales representative to the territories they are responsible for. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
• C. Create separate workbooks for each territory. Publish each dashboard to the same Sales Dashboard project, and set permissions so each sales representative can see only the dashboards for their territories.
• D. Create a data source by joining the sales data table to an entitlements data table. Add a data source filter to restrict access and publish the data source. Connect the Sales Dashboard to this published data source.

Which technique should a Tableau consultant use to optimize workbook performance with a live data source?

• A. Use Custom SQL for Tableau query optimization.
• B. Use Compute Calculations Now for live data sources to materialize calculations.
• C. Use larger sets of more granular records in Table Calculations instead of smaller sets of aggregated records.
• D. Use numbers and Booleans instead of strings and dates.

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?

• A. Use inbuilt dashboards in Tableau Server to troubleshoot the performance.
• B. Use Performance Recording on Tableau Server.
• C. Use Performance Recording in Tableau Desktop.
• D. Run Workbook Optimizer.