QUESTION 58
SIMULATION
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle.
From the File menu in Tableau Desktop, click Save.

QUESTION 59
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which type of calculation is the consultant able to move?

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

QUESTION 61
A client wants guidance for Creators to build efficient extracts from large data sources.
What are three Tableau best practices that the Creators should use? Choose three.

QUESTION 62
A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client’s requirements?

QUESTION 63
A client is migrating their data warehouse. They visualize the data in workbooks hosted on Tableau Server with Tableau Data Management enabled and want to see how many workbooks will be impacted.
What should the consultant do to quickly identify how many workbooks will be impacted?

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

QUESTION 65
A database contains two related tables at different levels of granularity. The client wants to make all data available in Tableau Prep at the original level of granularity.
Which two solutions in Tableau meet the client’s requirements? Choose two.

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

The Sales percentage is inadvertently recalculated each time the filter is applied to the Region.

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

QUESTION 67
A client has a dashboard that renders in less than 10 seconds. The client receives a request to add a new calculated field that will return TRUE if a Project contains any one of the values “Project 1” or “Project 2” and FALSE otherwise. After adding the function found below, the dashboard’s render time increases to 14 seconds from 10 seconds.
[Project] = ‘Project 1’ OR [Project] = ‘Project 2’
Which function should the consultant use to reduce the render time?

QUESTION 68
A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server.
Which two features should the business analyst use to create the view? Choose two.

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

QUESTION 70
A company’s Tableau Cloud admin wants to maintain control over what content gets published to its site for viewers, while also supporting self-service for dashboard creators.
Which governance strategy should the admin implement?

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

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

QUESTION 73
A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The consultant needs to implement a dashboard design that provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?

QUESTION 74
A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The consultant needs to implement a dashboard design that provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?