Salesforce Analytics-Con-301 Free Certification Exam Questions Answer Feb 2026 update

Question # 11

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.

Question # 12

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.

Question # 13

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?

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 data

source.

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.

Question # 14

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.

Question # 15

A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations)

is required for the files before designing the visuals. The files have the following attributes:

. All files have the same schema.

. Multiple files have something in common among their file names.

. Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

Use join option to combine/merge all the files together before doing the data transformation (calculations).

Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).

Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.

Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.

Explanation:

Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries. This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.

[References: The answer is based on the best practices for creating efficient calculations in Tableau, as described in Tableau’s official documentation, which suggests using basic and aggregate calculations to improve performance1. Additionally, the process of materializing calculations in extracts is detailed in Tableau’s resources2., Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:, Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process., Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward., Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file., References:, Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation., , ]

Question # 16

A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server

audit, 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.

Question # 17

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

Question # 18

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?

Split some visualizations on the dashboard into many smaller visualizations on the same dashboard.

Connect to the data source via a custom SQL query.

Use filters, hide unused fields, and aggregate values.

OD. Restrict users from accessing the workbook to reduce server load.

Question # 19

A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant

used a quick table calculation to create the labels.

Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.

Which approach should the consultant use to produce the desired result?

Use a calculation with TOTAL() function instead of a quick table calculation.

Add the [Profit] filter to the context.

Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())

Filter with the table calculation used to create labels.

Explanation:

When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.

[References: The solution is based on the principles of context filters and their order of operations in Tableau, which are documented in Tableau’s official resources and community discussions123., , , When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a "context filter," which effectively changes how data is filtered in calculations:, Create a Context Filter: Right-click on the profit filter and select "Add to Context". This action changes the order of operations in filtering, meaning the context filter is applied first., Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set., View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data., References:, Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data., , ]

Question # 20

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.

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., , , ]

Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Free Practice Questions for Salesforce Analytics-Con-301 Exam

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation: