Online Access Free TCC-C01 Practice Test

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

• A.Limit data to current and previous years as well as to the last day of each month to eliminate the need to use the averages.
• B.Limit data to current and previous years and leave data at daily level to calculate the averages in the report.
• C.Move calculating averages to data layer and aggregate dates to monthly level.
• D.Limit data to current and previous years, move calculating averages to data layer, and aggregate dates to monthly level.

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.Select a previous version from Tableau Server, download it, and republish that data source.
• B.Request that a server administrator restore a Tableau Server backup.
• C.Select a previous version from Tableau Server, and then click Restore.
• D.Delete and recreate the data source manually.

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 filter action, set "Run action on" to Menu, and set "Clearing the selection will" to Show all values.
• C.Add a highlight action and set Target Highlighting to Sub-Category.
• D.Add a highlight action and set Target Highlighting to All Fields.

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?

• A.Split some visualizations on the dashboard into many smaller visualizations on the same dashboard.
• B.Restrict users from accessing the workbook to reduce server load.
• C.Connect to the data source via a custom SQL query.
• D.Use filters, hide unused fields, and aggregate values.