You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
EmployeeInfo is the first table that is dragged to the canvas,
The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
Not all records have an exact match.
Which type of join should the analyst use?
A colleague provides a Data Analyst with access to a folder that has the following files:
Sales.csv
Book1.json
Sales.tds
Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
A Data Analyst has received a request to provide a dashboard related to employee time logs. The employees are entering their time using mobile devices throughout the day and data is stored in a cloud-based database. The end users would like to receive data on their dashboard in as close to real-time as possible.
How should the analyst best create a data source to meet these requirements?
You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.
Below are some of the values in the Order_ID field:
Which calculation should a Data Analyst use to return the two-letter combinations starting with the letter " P " for each of these values?
TESTED 06 Jul 2026
