Question 1

A Tableau workbook is connected to a large dataset and uses numerous calculated fields for data cleansing, such as trimming whitespace and converting strings to standardized formats.

The workbook’s performance is significantly slow. What is the best approach to address this issue?

Options :

A : Move the data cleansing calculations to the data source level, possibly using ETL processes

B : Use Tableau Prep to handle these data cleansing operations before loading the data into Tableau

C : Replace the calculated fields with equivalent Tableau functions to improve efficiency

D : Increase the processing power of the Tableau Server

Answer: A

Question 2

Your company follows a fiscal year that starts in July. In Tableau, you need to create a view that compares quarterly sales figures based on this fiscal calendar.

Which approach should you take to accurately represent fiscal quarters?

Options :

A : Use the standard DATEPART function to extract quarters and create a calculated field for comparison

B : Create a calculated field that modifies the DATEPART function to align with the fiscal year starting in July

C : Implement a FIXED Level of Detail (LOD) expression to segregate data by standard calendar quarters

D : Use the DATETRUNC function to truncate dates to the nearest quarter without adjusting for the fiscal year

Answer: B

Question 3

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 4

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

Question 5

In a healthcare organization using Tableau, there is a need to organize content so that clinical staff can easily access patient care dashboards, while administrative staff can access operational reports.

What is the best strategy to organize this content in Tableau?

Options :

A : Consolidate all dashboards and reports into a single project for ease of access

B : Organize content into distinct projects based on function, such as 'Clinical' and 'Administrative', with appropriate access permissions

C : Encourage users to create personal copies of dashboards for customized access

D : Implement row-level security on all dashboards to control data visibility based on the user-s role

Answer: B