Tableau Desktop Specialist — Question 42

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.

You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.

What are two ways to ensure that all the users can view the worksheets in the workbook? (Choose two.)

Answer options

• A. Remove all the data source filters before you publish
• B. Configure the local file permissions to the workbook file and then publish the workbook
• C. Export the data to a csv before you publish
• D. Change the data source to an extract before you publish
• E. Embed the credentials when you publish the workbook

Correct answer: D, E

Explanation

Changing the data source to an extract (D) enables the workbook to be self-contained, allowing users to access the data without needing direct database access. Embedding the credentials (E) ensures that users can authenticate and view the data as needed. The other options do not address the access issue effectively; removing filters or changing file permissions does not solve the core problem of database access, and exporting to a CSV would limit interactivity.