Analytics-Con-301 Exam Training Practice Tests (Salesforce Certified Tableau Consultant)]

Question 1

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.

Correct Answer:

See the complete Steps below in Explanation:
Explanation:
To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* Double-click on the CC workbook from the desktop to open it in Tableau Desktop.
* Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.
* Modify the Percent Contribution Calculated Field:
* Navigate to the Data pane and find the "Percent Contribution" calculated field.
* Right-click on the "Percent Contribution" field and select 'Edit'.
* Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:
{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}
* This formula uses {FIXED [Manufacturer]: SUM([Quantity])} to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity
{SUM([Quantity])} calculates the grand total across all manufacturers. The division calculates the percentage contribution.
* Click 'OK' to save the updated calculated field.
* Enter Percentage for Newell:
* With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.
* Identify the value corresponding to 'Newell' in the updated visualization.
* Round this value to the nearest hundredth of a percent as required.
* Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.
* Save Your Changes:
* From the File menu, click 'Save' to store all the modifications you have made to the workbook.
References:
Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.
Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.
By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity.
Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.

Question 2

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 it may be an option in the future.
What should the consultant recommend as the safest and easiest way to manage for the long term?

A. Create User filters based on data policies and apply them to a published data source. B. Create User filters in each view of each report using set filters and option Server/Create User Filter. C. 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. D. Create User filters based on data policies and apply them to views using set filters and option Server
/Create User Filter.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

A Tableau consultant is tasked with creating a line graph that shows daily temperature fluctuations. The below set of data to use to create a dashboard.
How should the consultant manipulate the data to support the business need?

A. Request a new set of data that is aggregated to the day level. B. Create a Level of Detail (LOD) calculation that will aggregate the data at the requested daily level. C. Pivot the data before the requested visualization can be created.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

A customer plans to do an in-place upgrade of their single node Tableau Server from 2023.1 to the most recent version.
What is the correct sequence to prepare for an in-place upgrade?

A. * In the production environment:
* Disable scheduled tasks.
* Uninstall Tableau Server 2023.1.
* Run the upgrade script for the most recent version of Tableau Server.
* Confirm everything works as expected and test new features. B. * In a non-production environment:
* Clone a copy of existing production environment to create a VM snapshot.
* Restore the VM snapshot into the non-production environment.
* Run the upgrade script for the most recent version of Tableau Server.
* Confirm everything works as expected and test new features.
* Redirect user traffic from the production environment to the non-production environment. C. * In a non-production environment:
* Install the most recent version of Tableau Server.
* Back up the existing production environment.
* Restore settings and backup into the non-production environment.
* Confirm everything works as expected and test new features.
* Redirect user traffic from the production environment to the non-production environment. D. * In the production environment:
* Disable scheduled tasks.
* Run the upgrade script for the most recent version of Tableau Server.
* Confirm everything works as expected and test new features.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

A client wants to view stores serviced by delivery drivers on a map. The have the information provided in the table below:

What does the client need to do to plot exact street addresses on the map?

A. Custom geocode the street addresses. B. Add a Map layer to the visualization. C. Change the data type of Street Address 1 and Street Address 2 to the Geographic role. D. Establish a hierarchy of State > City > Street Address 1 > Street Address 2.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

A client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter.
For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1-2020 Q4.
Which table calculation should produce the desired result?

A. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), FIRST(), FIRST() + 3) B. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), LAST()-3, LAST()) C. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), INDEX(), INDEX() + 3) D. SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), 3, 0)

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

A client is concerned that a dashboard has experienced degraded performance after they added additional quick filters. The client asks a consultant to improve performance.
Which two actions should the consultant take to fulfill the client's request? Choose two.

A. Modify filters to include an "Apply" button. B. Use Filter Actions instead of quick filters. C. Ensure filters are set to display "Only Relevant Values" instead of "All Values in Database." D. Add existing filters to Context.

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

A client is evaluating which user roles to assign to managers. The managers need to view dashboards, create Data-Driven Alerts, and perform ad hoc analysis of existing Tableau data sources. A consultant must provide a solution that minimizes licensing costs.
Which role should the consultant recommend be assigned to the managers?

A. Creator B. Viewer C. Explorer D. Site Administrator

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.

They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse structure.
What should the client do to achieve the desired result?

A. Use Tableau Prep to add new rows. B. Update the Widget Inventory Table to be a daily snapshot. C. Use Tableau Desktop to visualize null values. D. Create a temporary table in the database.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Salesforce Certified Tableau Consultant - Analytics-Con-301 Exam Practice Test