Question 1

You are creating a Tableau report to analyze customer purchasing behavior. The report requires a calculation of the average purchase value per customer, but only for those who have made more than five purchases.Which combination of calculations would accurately fulfill this requirement?

Options :

A : Use a FIXED LOD expression to calculate the total purchase value per customer and divide it by the total number of purchases for each customer using a BASIC calculation

B : Implement a calculated field using COUNTD to count the number of purchases per customer, and then use a WINDOW_AVG function to calculate the average purchase value for customers with more than five purchases

C : Create a nested LOD expression: first, use a FIXED LOD to identify customers with more than five purchases, then use another FIXED LOD to calculate the average purchase value for these customers

D : Apply a BASIC calculation to find the average purchase value for all customers and then use a filter to display only customers with more than five purchases

Answer: C

Question 2

A multinational corporation is implementing a Tableau dashboard to track sales performance. Sales managers should access data for their specific region, while executives need access to all regions.What RLS approach should the consultant recommend?

Options :

A : Utilize Tableau-s built-in group filters to assign regional access to sales managers and global access to executives

B : Implement RLS at the database level, restricting access based on user roles

C : Create a single shared login for all users with access to all data

D : Manually update user access rights on a monthly basis to reflect any role changes

Answer: A

Question 3

A company wants to monitor and optimize the performance of their Tableau Server. They need detailed insights into which dashboards are most frequently accessed and the average load times for these dashboards.What kind of custom administrative view should you design to provide these insights?

Options :

A : A view that tracks user logins and logout times to monitor user activity on the server

B : A view that displays the frequency of dashboard access and their respective average load times

C : A view that shows the number of extract refreshes and their completion status

D : A view that details the data source connections used by each dashboard

Answer: B

Question 4

A healthcare organization requires a Tableau solution where doctors can only view patient records for which they are the primary care provider.What is the best way to implement RLS with an entitlement table in this case?

Options :

A : Use a single login for all doctors and trust that they will only access their patients' records

B : Implement an entitlement table that links each doctor to their specific patients based on primary care provider records

C : Assign all doctors the same level of access to all patient records for ease of implementation

D : Manually update access rights for each doctor whenever there is a change in patient assignments

Answer: B

Question 5

You are analyzing sales data in a Tableau workbook and need to calculate a moving average of sales over the past three months for each product category. Additionally, this calculation should adjust dynamically as filters are applied.Which calculation method should you use?

Options :

A : Apply a BASIC moving average calculation using a calculated field

B : Utilize a WINDOW_AVG function with a specified window size of three months

C : Implement a FIXED Level of Detail (LOD) expression to calculate the average sales

D : Use a RUNNING_SUM function to calculate the total sales over the past three months

Answer: B

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

Buying Options: