Summer Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! Analytics-Con-301 Salesforce Certified Tableau Consultant is now Stable and With Pass Result

Analytics-Con-301 Practice Exam Questions and Answers

Salesforce Certified Tableau Consultant

Last Update 3 days ago
Total Questions : 55

Salesforce Consultant is stable now with all latest exam questions are added 3 days ago. Incorporating Analytics-Con-301 practice exam questions into your study plan is more than just a preparation strategy.

Analytics-Con-301 exam questions often include scenarios and problem-solving exercises that mirror real-world challenges. Working through Analytics-Con-301 dumps allows you to practice pacing yourself, ensuring that you can complete all Salesforce Consultant practice test within the allotted time frame.

Analytics-Con-301 PDF

Analytics-Con-301 PDF (Printable)
$50
$124.99

Analytics-Con-301 Testing Engine

Analytics-Con-301 PDF (Printable)
$58
$144.99

Analytics-Con-301 PDF + Testing Engine

Analytics-Con-301 PDF (Printable)
$72.8
$181.99
Question # 1

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?

Options:

A.  

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

B.  

Connect to the data source via a custom SQL query.

C.  

Use filters, hide unused fields, and aggregate values.

O

D.  

Restrict users from accessing the workbook to reduce server load.

Discussion 0
Question # 2

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?

Options:

A.  

Calc1: DATETRUNC ('month', DATEADD('month', 1, [Order Date]))

Calc2: AVG(DATEDIFF ('week', [Order Date], [Calc1]))

B.  

Calc1: DATETRUNC ('month', DATEADD ('month', 1, [Order Date]))

Calc2: AVG(DATEDIFF ('day', [Order Date], [Calc1]))

C.  

Calc1: DATETRUNC ('day', DATEADD('week', 4, [Order Date]))

Calc2: AVG([Order Date] - [Calc1])

D.  

Calc1: DATETRUNC ('day', DATEADD ('day', 31, [Order Date]))

Calc2: AVG ([Order Date] - [Calc1])

Discussion 0
Question # 3

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?

Options:

A.  

Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.

B.  

Publish a live connection to Tableau Server.

C.  

Publish an incremental refresh every Saturday.

D.  

Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.

Discussion 0
Question # 4

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?

Options:

A.  

Strings are fastest, followed by integers, and then Booleans.

B.  

Integers are fastest, followed by Booleans, and then strings.

C.  

Strings, integers, and Booleans all perform the same.

D.  

Booleans are fastest, followed by integers, and then strings.

Discussion 0
Question # 5

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.

Options:

A.  

Whether or not the client plans to leverage single sign-on (SSO)

B.  

Whether or not there are large numbers of concurrent extract refreshes

C.  

Whether or not the client needs the ability to connect to public, cloud-based data sources

D.  

Amount of data storage used on the client's existing server

Discussion 0
Question # 6

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?

Options:

A.  

Use inbuilt dashboards in Tableau Server to troubleshoot the performance.

B.  

Use Performance Recording on Tableau Server.

C.  

Use Performance Recording in Tableau Desktop.

D.  

Run Workbook Optimizer.

Discussion 0
Question # 7

A client currently has a workbook with the table shown below.

Question # 7

Which method will produce the output for the Total Sales Value field for all the categories shown in the table?

Options:

A.  

Quick Table Calculation

B.  

A Window Function

C.  

Level of Detail (LOD) Calculation

D.  

MAX() Function

Discussion 0
Question # 8

A client wants to flag orders that have sales higher than the regional average.

Which calculated field will produce the required result?

Options:

A.  

[Sales]

>

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

B.  

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

>

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

C.  

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

>

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

D.  

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

>

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

Discussion 0
Question # 9

A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.

Question # 9

What should the consultant use to transform the table in the most efficient manner?

Options:

A.  

A calculated field that uses the TRIM function

B.  

A calculated field that uses the LEFT function

C.  

The Split option

D.  

The Aliases option

Discussion 0
Question # 10

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

Question # 10

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Get Analytics-Con-301 dumps and pass your exam in 24 hours!

Free Exams Sample Questions