Free Tableau Certified Consultant Exam TCC-C01 Exam Practice Test

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 thirdtable contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludesusing an extract.What is the most performant approach to model the data for a live connection?

• Relating the tables in Tableau Desktop
• Blending the first two tables with the third
• Joining the tables in Tableau Prep
• Joining the tables in Tableau Desktop

A client needs to design row-level security (RLS) measures for their reports. The client does not currently have Tableau Data Management Add-on, and itmay be an option in the future.What should the consultant recommend as the safest and easiest way to manage for the long term?

• Create User filters based on data policies and apply them to views using set filters and option Server/Create User Filter.
• Create User filters for each report using a table joined to its data source and using the option Apply to All Sheet Using the Data Source.
• Create User filters based on data policies and apply them to a published data source.
• Create User filters in each view of each report using set filters and option Server/Create User Filter.

A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.Which calculation should the consultant recommend?

• DATEPART('weekday', [Order Date])>=6
• DATEPART('iso-weekday', [Order Date])>=6
• DATENAME('iso-weekday', [Order Date])>=6
• DATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7

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?

• Calc1: DATETRUNC ('month', DATEADD('month', 1, [Order Date])) Calc2: AVG(DATEDIFF ('week', [Order Date], [Calc1]))
• Calc1: DATETRUNC ('month', DATEADD ('month', 1, [Order Date])) Calc2: AVG(DATEDIFF ('day', [Order Date], [Calc1]))
• Calc1: DATETRUNC ('day', DATEADD('week', 4, [Order Date])) Calc2: AVG([Order Date] - [Calc1])
• Calc1: DATETRUNC ('day', DATEADD ('day', 31, [Order Date]))
• Calc2: AVG ([Order Date] - [Calc1])

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 thefollowing 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 profitWhich approach should the consultant use to provide the required level of access?

• 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 anduse the calculation in the view in the report.
• Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the tabledata to create user filters in the report.
• 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 toGroup 2 and use the calculation in the view in the report.
• Specify with user filters in each view individuals who can see profit, profit margin, or none of these.

A client has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departmentsgive 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?

• Tableau Prep Conductor
• Ask Data
• Tableau Catalog
• Tableau Resource Monitoring Tool

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?

• ZN([Sales])*(1 - ZN([Discount]))
• CASE [Sector Parameter] WHEN 1 THEN "green" WHEN 2 THEN "yellow"
• SUM([Profit])/SUM([Sales])
• POWER(ZN(SUM([Sales]))/ LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))
• - 1
• END

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 tothat 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, theteam does not have a Tableau Data Management license.What should the consultant recommend to meet the company's requirements?

• Create one group for each territory and assign sales representatives to the appropriate groups. Map each group to a territory in the SalesDashboard. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
• Create separate workbooks for each territory. Publish each dashboard to the same Sales Dashboard project, and set permissions so eachsales representative can see only the dashboards for their territories.
• 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 thedata source. Connect the Sales Dashboard to this published data source.
• 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.

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?

• Published data sources that use live connections
• Tableau Prep flows
• Published data sources that use extracts
• Workbooks

A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create anextract. The extract will include partial data from the SQL Server data source. Which action will reduce the amount of data in the extract?

• Use an extract filter.
• Aggregate the extract to the visible dimensions.
• Define the filters by using custom SQL.
• Set up the extract as an incremental refresh.