Tableau Certified Consultant Questions and Answers
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 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 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 of
the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?
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?
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?
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 client wants to migrate their Tableau Server to Tableau Cloud. The Tableau Server is configured with three sites: Finance, Strategy, and Marketing. A
consultant must provide a solution that minimizes user impact and costs.
Which configuration should the consultant recommend for Tableau Cloud to meet the client's requirements?
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 university has data on its undergraduate students and their majors by grade level (Freshman, Sophomore, Junior, Senior). The university is interested in
visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?
A client currently has a workbook with the table shown below.
Which method will produce the output for the Total Sales Value field for all the categories shown in the table?
A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
· SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values
A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query."
Which step should the consultant take to resolve this issue?
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 an
extract. The extract will include partial data from the SQL Server data source.
Which action will reduce the amount of data in the extract?
From the desktop, open the CC workbook.
Open the Manufacturers worksheet.
The Manufacturers worksheet is used to
analyze the quantity of items contributed by
each manufacturer.
You need to modify the Percent
Contribution calculated field to use a Level
of Detail (LOD) expression that calculates
the percentage contribution of each
manufacturer to the total quantity.
Enter the percentage for Newell to the
nearest hundredth of a percent into the
Newell % Contribution parameter.
From the File menu in Tableau Desktop, click
Save.
From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.
From the desktop, open the CCworkbook. Use the US PopulationEstimates data source.
You need to shape the data in USPopulation Estimates by using TableauDesktop. The data must be formatted asshown in the following table.
Open the Population worksheet. Enterthe total number of records contained inthe data set into the Total Recordsparameter.
From the File menu in Tableau Desktop,click Save.
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.