Free Tableau Certified Consultant Exam TCC-C01 Exam Practice Test

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?

• Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
• Publish a live connection to Tableau Server.
• Publish an incremental refresh every Saturday.
• Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.

A university has data on its undergraduate students and their majors by grade level (Freshman,Sophomore, Junior, Senior). The university is interested invisualizing the path students take as they change majors across grade levels. Which visualization type should the consultant recommend?

• Chord Chart
• Tree Chart
• Radar Chart
• Sankey Diagram

A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Serveraudit, 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?

• Current custom access will be maintained, but new custom permissions will not be granted.
• Access will be automatically rolled back to the top-level project permissions immediately.
• Users will be prompted to manually update permissions for all nested projects.
• Users will be notified that they will automatically lose access to content after 30 days.

A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility ofthe report to the sales and marketing groups in the most efficient manner. Which approach should the consultant recommend?

• Grant access to the report on the Tableau Server only to the members of sales and marketing user groups.
• Prepare a row-level security (RLS) entitlement table to define limitations of the access and use it to build user filters in the report's datasource.
• Add user filters from Tableau Server to each worksheet and select only sales and marketing user groups.
• Use user groups defined on Tableau Server to build user filters in the report's data source.

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.

• Whether or not the client plans to leverage single sign-on (SSO)
• Whether or not there are large numbers of concurrent extract refreshes
• Whether or not the client needs the ability to connect to public, cloud-based data sources
• Amount of data storage used on the client's existing server

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

• IF [ProfitMargin]>0.50 Then 'Highly Profitable' ELSEIF [ProfitMargin]>=0 Then 'Profitable'ELSE 'Unprofitable' END
• IF [ProfitMargin]>=0.50 Then 'Highly Profitable' ELSEIF [ProfitMargin]>=0 Then 'Profitable'ELSE 'Unprofitable' END
• IF [ProfitMargin]>0.50 Then 'Highly Profitable' ELSEIF [ProfitMargin]>=0 Then 'Profitable' ELSEIF [ProfitMargin] <0 Then 'Unprofitable' END
• IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable') ELSE 'Unprofitable'
• END

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant ifthere is a performance difference among these three data types. What should the consultant tell the customer?

• Strings are fastest, followed by integers, and then Booleans.
• Integers are fastest, followed by Booleans, and then strings.
• Strings, integers, and Booleans all perform the same.
• Booleans are fastest, followed by integers, and then strings.

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-yearmetrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.Which method is the most efficient in achieving the company's requirements?

• Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.. Add navigation buttons to both dashboards.
• Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View.". Right-click the parameter and select Add to Sheet for both worksheets.. Navigate back to the dashboard and to the upper corner of the two worksheets.. Enable the Use as Filter option.
• Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views.. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you
• created.
• Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following
• calculation: True.
• . Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating
• dashboard object.
• . Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
• "Target Parameter" and "Source Fields" to the parameter and calculated field you created.
• . Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created.

A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be ableto move the calculation to the underlying database, but not at this time. The solution should offer the best performance.Which approach should the consultant use to produce the desired results?

• Filter MONTH/DAY/YEAR on [Ship Date] field and use an option to filter to the latest date value when the workbook opens.
• Filter on calculation [Ship Date]=TODAY()-1.
• Filter on Ship Date field using the Yesterday option.
• Filter on calculation [Ship Date]={MAX([Ship Date])}.