Question 1

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

Question 2

A large organization uses Tableau for business analytics and wants to implement a version control strategy to manage changes in Tableau workbooks effectively.What is the best practice for version control in Tableau?

Options :

A : Utilize a third-party version control system like Git for managing Tableau workbook versions

B : Rely on Tableau Server-s built-in version history feature to manage and track changes in workbooks

C : Encourage users to manually maintain different versions of workbooks by saving copies with different names

D : Implement an automated script to backup and store different versions of Tableau workbooks periodically

Answer: B

Question 3

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 4

When translating analytical requirements into the Tableau context, what is a best practice for ensuring effective dashboard design?

Options :

A : Using as many varied chart types as possible to display data diversity

B : Prioritizing clear and intuitive visualizations that align with the users' data interpretation skills

C : Designing the dashboard layout to be identical to existing report formats

D : Incorporating complex calculations and data models visible to end-users for transparency

Answer: B

Question 5

A consultant is tasked with setting up RLS for a university’s Tableau project, where department heads should have access to their department’s data and the university-wide data, while individual professors should only access data from their respective departments.How should the consultant implement RLS?

Options :

A : Implement RLS based solely on individual user roles without considering departmental hierarchies

B : Establish a hierarchical RLS structure based on the university-s departmental organization

C : Assign the same access level to all staff members, irrespective of their roles

D : Manually update RLS settings each semester to reflect changes in staff and department heads

Answer: B