Summer Special Discount 60% Offer - Ends in 0d 00h 00m 00s - Coupon code: brite60

ExamsBrite Dumps

Salesforce Certified Tableau Consultant Question and Answers

Salesforce Certified Tableau Consultant

Last Update Oct 1, 2025
Total Questions : 55

We are offering FREE Analytics-Con-301 Salesforce exam questions. All you do is to just go and sign up. Give your details, prepare Analytics-Con-301 free exam questions and then go for complete pool of Salesforce Certified Tableau Consultant test questions that will help you more.

Analytics-Con-301 pdf

Analytics-Con-301 PDF

$42  $104.99
Analytics-Con-301 Engine

Analytics-Con-301 Testing Engine

$50  $124.99
Analytics-Con-301 PDF + Engine

Analytics-Con-301 PDF + Testing Engine

$66  $164.99
Questions 1

A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.

IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END

Which calculation will produce the correct result?

Options:

A.  

IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END

B.  

IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END

C.  

COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)

D.  

COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)

Discussion 0
Questions 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?

Options:

A.  

Create User filters based on data policies and apply them to views using set filters and option Server/Create User Filter.

B.  

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.

C.  

Create User filters based on data policies and apply them to a published data source.

D.  

Create User filters in each view of each report using set filters and option Server/Create User Filter.

Discussion 0
Questions 3

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?

Options:

A.  

Line and bubble charts

B.  

Waterfall chart and tree map

C.  

Gantt and bar charts

D.  

Scatter plot and pie chart

Discussion 0
Questions 4

A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data

source.

Which Tableau tool should the consultant use?

Options:

A.  

Data Management

B.  

Prep Conductor

C.  

Activity Log

D.  

Tableau Advanced Management

Discussion 0
Questions 5

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.

Options:

A.  

Keep only the data required for analysis by using extract filters.

B.  

Use aggregate data for visible dimensions, whenever possible.

C.  

Use only live connections as they are always faster than extracts.

D.  

Include all the data from the original data source in the extract.

E.  

Hide all unused fields.

Discussion 0
Questions 6

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?

Options:

A.  

Build one dashboard that has desktop, tablet, and phone layouts, and fix the size of the layouts.

B.  

Build one dashboard and fix the size of the dashboard.

C.  

Build one dashboard and set the size to Automatic.

D.  

Build one dashboard for each type of device and fix the size of the layouts.

Discussion 0
Questions 7

From the desktop, open the CC workbook. Use the US Population Estimates data source.

You need to shape the data in US Population Estimates by using Tableau Desktop. The data must be formatted as shown in the following table.

Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter.

From the File menu in Tableau Desktop, click Save.

Options:

Discussion 0
Questions 8

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.

Options:

Discussion 0
Questions 9

From the desktop, open the NYC

Property Transactions workbook.

You need to record the performance of

the Property Transactions dashboard in

the NYC Property Transactions.twbx

workbook. Ensure that you start the

recording as soon as you open the

workbook. Open the Property

Transactions dashboard, reset the filters

on the dashboard to show all values, and

stop the recording. Save the recording in

C:\CC\Data\.

Create a new worksheet in the

performance recording. In the worksheet,

create a bar chart to show the elapsed

time of each command name by

worksheet, to show how each sheet in

the Property Transactions dashboard

contributes to the overall load time.

From the File menu in Tableau Desktop,

click Save. Save the performance

recording in C:\CC\Data\.

Options:

Discussion 0
Questions 10

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.

Options:

Discussion 0
Questions 11

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.

Options:

Discussion 0
Questions 12

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.

Options:

Discussion 0
Questions 13

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?

Options:

A.  

Published data sources that use live connections

B.  

Tableau Prep flows

C.  

Published data sources that use extracts

D.  

Workbooks

Discussion 0
Questions 14

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?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Questions 15

A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:

Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}

The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher

than the customer expects.

The client asks a consultant to rewrite the calculation so the result meets their expectation.

Which calculation should the consultant use?

Options:

A.  

{INCLUDE [Customer ID]: COUNTD([Order ID])}

B.  

{FIXED [Customer ID], [Region]: COUNTD([Order ID])}

C.  

{EXCLUDE [Customer ID]: COUNTD([Order ID])}

D.  

{FIXED [Customer ID], [Region], [Order Date]: COUNTD([Order ID])}

Discussion 0
Questions 16

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?

Options:

A.  

Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and

use the calculation in the view in the report.

B.  

Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table

data to create user filters in the report.

C.  

Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to

Group 2 and use the calculation in the view in the report.

D.  

Specify with user filters in each view individuals who can see profit, profit margin, or none of these.

Discussion 0