Question 1

In a Tableau workbook, you are tasked with calculating the total quarterly sales for each salesperson in each region. The data includes sales figures for multiple salespersons across different regions.What is the best approach to achieve this calculation?

Options :

A : Aggregate total sales at the global level, then use filters to view sales by salesperson and region

B : Use an INCLUDE Level of Detail (LOD) expression to sum sales for each salesperson within each region

C : Create a calculated field that sums up sales for each salesperson, irrespective of region

D : Implement a WINDOW_SUM function to calculate the total sales across all regions and salespersons

Answer: B

Question 2

In a Tableau workbook that connects to a large dataset, you find that several views are slow due to calculated fields performing row-level string manipulations.To enhance performance, which of the following actions should you take regarding these calculations?

Options :

A : Implement these string manipulation calculations in the underlying database prior to Tableau-s use

B : Replace string manipulations with numerical calculations within Tableau

C : Increase the data refresh rate for the Tableau workbook

D : Split the workbook into multiple smaller workbooks

Answer: A

Question 3

You have created a complex FIXED Level of Detail (LOD) expression in Tableau to calculate average sales per store, but the results seem incorrect when filters are applied to the dashboard.What is the most likely cause of this issue?

Options :

A : The FIXED LOD expression is not including the dimensions used in the filters

B : The calculated field for average sales is not using the correct aggregation method

C : The filters need to be converted to context filters to affect the FIXED LOD calculation

D : The workbook does not have enough computational resources to process the FIXED LOD expression

Answer: C

Question 4

Users are reporting that they cannot access Tableau Server, and initial checks indicate that there are no issues with the Tableau Server itself.What should be the next step in troubleshooting this problem?

Options :

A : Check the user permissions in Tableau Server to ensure users have the correct access rights

B : Verify the network connectivity and firewall settings to rule out network-related issues

C : Instruct users to clear their browser cache and restart their devices

D : Increase the Tableau Server-s hardware resources to handle more user connections

Answer: B

Question 5

You are tasked with analyzing monthly sales data in Tableau and need to calculate the running total of sales, as well as the percentage change from the previous month.Which type of calculation is most suitable for this task?

Options :

A : Use a BASIC calculation to sum the total sales and then a separate BASIC calculation for the percentage change

B : Implement a WINDOW_SUM function for the running total and a WINDOW_AVG function for the percentage change

C : Use a WINDOW_SUM function for the running total and a WINDOW_AVG function to compare it against the previous month-s total

D : Utilize a WINDOW_SUM function for the running total and a QUICK_TABLE_CALCULATION for the percentage change

Answer: D

Free Analytics-Con-301 Mock Exam – Practice Online Confidently

Buying Options: