New 2026 Realistic Analytics-Con-301 Dumps Test Engine Exam Questions in here [Q32-Q48]

4.3/5 - (3 votes)

New 2026 Realistic Analytics-Con-301 Dumps Test Engine Exam Questions in here

Updated Official licence for Analytics-Con-301 Certified by Analytics-Con-301 Dumps PDF

NEW QUESTION 32
A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.
Which two actions should the client use to access the necessary metadata? Choose two.

Connect directly to the Site Content data source within the Admin Insights project.

Query metadata through the GraphiQL engine.

Access metadata through the Metadata API.

Download metadata through Tableau Catalog.

NEW QUESTION 33
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

NEW QUESTION 34
A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?

[Sales]
>
{ FIXED [Order ID] : SUM([Sales]) }

{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) }

{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

{ FIXED [Order ID] : SUM([Sales]) }
>
{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

NEW QUESTION 35
SIMULATION
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.

See the complete Steps below in Explanation
Explanation:
To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:
Open the CC Workbook and Access the Worksheet:
From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.
Calculate Cumulative Sales Percentage:
Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select ‘Create Calculated Field’.
Name this field “Cumulative Sales Percentage”.
Enter the following formula to calculate the running sum of sales as a percentage of the total sales:
(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))
Click ‘OK’ to save the calculated field.
Add the Cumulative Sales Percentage Line to the Chart:
Drag the “Cumulative Sales Percentage” field to the Rows shelf, placing it next to the existing Sales measure.
Ensure that the cumulative line appears as a continuous line. Right-click on the “Cumulative Sales Percentage” field on the Rows shelf, select ‘Change Chart Type’, and choose ‘Line’.
Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the “Cumulative Sales Percentage” and select ‘Synchronize Axis’ if it’s on a dual-axis setup.
Format the Cumulative Sales Percentage Line:
Click on the “Cumulative Sales Percentage” line in the visualization.
Navigate to the ‘Format’ pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.
Save Your Changes:
From the File menu, click ‘Save’ to ensure all your changes are stored.
References:
Tableau Help: Provides additional details on creating calculated fields and customizing line charts.
Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.
By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.

NEW QUESTION 36
A client is using Tableau to visualize data by leveraging security token-based credentials. Suddenly, sales representatives in the field are reporting that they cannot access the necessary workbooks. The client cannot recreate the error from their offices, but they have seen screenshots from the field agents. The client wants to restore functionality for the field agents with minimal disruption.
Which step should the consultant recommend to accomplish the client’s goal?

Ensure that “Allow Refresh Access” was checked when the data source was published.

Change the data source permissions for the connection to “Prompt User.”

Ask the workbook owners to republish the workbooks to refresh the security token.

Renew the security token via the Data Connection on Tableau Server.

NEW QUESTION 37
An analyst needs to interactively set a reference date to drive table calculations without leaving a view.
Which action should the analyst use?

Running action

Filter action

Parameter action

Highlight action

NEW QUESTION 38
A consultant has a view using a table calculation to calculate percent of total Sales by Category. The consultant would like to filter out particular categories, but wants the percent of total calculation to remain steady even as they filter items in or out.
What should the consultant do to achieve the desired impact?

Filter Category by using a Context Filter instead of a Dimension Filter.

Filter Category by using a Data Source Filter instead of a Dimension Filter.

Create an aggregate expression, and then use that instead of the table calculation.

Create a FIXED Level of Detail (LOD) expression, and then use that instead of the table calculation.

NEW QUESTION 39
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

NEW QUESTION 40
SIMULATION
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.

From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.

NEW QUESTION 41
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.

NEW QUESTION 42
A Tableau Server customer is interested in measuring content and platform usage. Which two features should the consultant use? Choose two.

Tableau Pulse

Tableau Server repository

Admin Insights page

Server Status page

NEW QUESTION 43
A client has a data source that stores a time stamp for each time a user interacts with a product feature. They visualize 3 years of data at the daily level. As adoption has grown over the last 6 months, the dashboard performance has steadily decreased, despite connecting via a data extract that is set to refresh every hour.
A Tableau consultant needs to improve performance of the dashboard with the least impact to the visualization.
Which option meets these requirements without additional cost?

Add extract filters to limit the number of product features visualized.

Invest in an extract, transform, load (ETL) tool to aggregate the data to a daily level.

Decrease the extract refresh to once a day.

Leverage Tableau Prep to aggregate the data to the daily product level.

NEW QUESTION 44
A consultant is tasked with improving the performance of a large workbook that contains multiple dashboards, each of which leverages a separate data source. What is one way to improve performance?

Convert Data Source filters to Quick Filters.

Convert any extracted data sources to live data sources.

Restrict the users who can access the workbook.

Split the workbook into multiple workbooks.

NEW QUESTION 45
A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there 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.

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

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

{FIXED [Region]:[Sales]}/{FIXED: SUM([Sales])}

{FIXED [Region]:sum([Sales])}

{FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])

{FIXED [Region]:sum([Sales])}/SUM([Sales]}

NEW QUESTION 47
A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?

Limit data to current and previous years and leave data at daily level to calculate the averages in the report.

Limit data to current and previous years, move calculating averages to data layer, and aggregate dates to monthly level.

Move calculating averages to data layer and aggregate dates to monthly level.

Limit data to current and previous years as well as to the last day of each month to eliminate the need to use the averages.

NEW QUESTION 48
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?

Use inbuilt dashboards in Tableau Server to troubleshoot the performance.

Use Performance Recording on Tableau Server.

Use Performance Recording in Tableau Desktop.

Run Workbook Optimizer.

Salesforce Analytics-Con-301 Exam Syllabus Topics:

Topic	Details
Topic 1	Data Visualization: This section evaluates the Tableau Consultant’s ability to design effective visual analytics solutions. It involves creating dashboards and visual reports that enhance user understanding, employing techniques like dynamic actions and advanced chart types, and ensuring performance optimization for an interactive user experience.
Topic 2	Business Consulting: For Tableau Consultants, this section involves designing and troubleshooting calculations and workbooks to meet advanced analytical use cases. It covers selecting appropriate chart types, applying Tableau’s order of operations in calculations, building interactivity into dashboards, and optimizing workbook performance by resolving resource-intensive queries and other design-related issues.
Topic 3	IT Management: This domain measures skills related to managing Tableau environments. It includes planning server upgrades, recommending deployment solutions (on-premise or cloud), and ensuring alignment between technical and business requirements for analytics infrastructure. It also involves troubleshooting and optimizing system performance relevant to Tableau Server and Cloud deployments.
Topic 4	Business Analysis: This section of the exam measures skills of Tableau Consultants focusing on evaluating the current state of analytics within an organization. It covers mapping business needs to Tableau capabilities, translating analytical requirements to best practices in Tableau, and recommending appropriate deployment options like Tableau Server or Tableau Cloud. It also includes evaluating existing data structures for supporting business needs and identifying performance risks and opportunities.