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.)
To ensure that all users can view the worksheets in the workbook after publishing to Tableau Server, you can change the data source to an extract before you publish and embed the credentials when you publish the workbook. By changing the data source to an extract, it eliminates the need for live connection to the SQL Server database, allowing users to view data without database access. Embedding credentials ensures that Tableau Server can access the database on behalf of the users, granting them the necessary permissions to view the data.
D. Change the data source to an extract: An extract is a copy of the database data stored within the workbook itself. By using an extract, the workbook doesn't need a live connection to the SQL Server database, allowing users to view the data even if they don't have access to the original source. E. Embed the credentials when you publish the workbook: When embedding credentials, you provide the username and password for the SQL Server database within the published workbook. This allows Tableau Server to access the database on behalf of the users, enabling them to view the data despite not having individual access.
B. Configure the local file permissions to the workbook file and then publish the workbook: By setting appropriate permissions to the workbook file locally before publishing, you ensure that all users on the Tableau Server site can access it. D. Change the data source to an extract before you publish: By converting the data source to an extract, you eliminate the need for live database access. This ensures that users on the Tableau Server can view the data without needing direct access to the Microsoft SQL Server database.