<< Prev Question Next Question >>

Question 4/21

You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform m order? (Place the three correct options in order.)

Recent Comments (The most recent comments are at the top.)

Aisiah D - Nov 12, 2022

I think the answer not correct, pay attention in the question "You want to use Tableau Prep to join the two datasets".
it's said "Tableau Prep", so if there is no "Open Tableau Prep" the assumption is Tableau Prep already Open.

then the actions :
1. From the connection pane, connect to both datasets
2. Join both datasets and select the join type
3. Specify the Employee Name as the join key
https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (21q)
Question 1: You have the following data source in tableau Server. (Exhib...
1 commentQuestion 2: Open the link to Book1 found on the desktop. Open the Catego...
Question 3: You conned to a Microsoft SQL Server database You need to cr...
1 commentQuestion 4: You have the following two datasets: * A Microsoft Excel wor...
Question 5: Open the link to Book1 found on the desktop. Open the Histog...
1 commentQuestion 6: You have a dashboard that contains confidential information ...
Question 7: Open the link to Book1 found on the desktop. Open the sales ...
1 commentQuestion 8: You company has two divisions located in the United States a...
1 commentQuestion 9: You have a Tableau workbook that contain three worksheets na...
1 commentQuestion 10: You have the following dataset that contain null values in t...
1 commentQuestion 11: You have the following visualization. (Exhibit)...
Question 12: You have the following dataset in Microsoft Excel. (Exhibit)...
1 commentQuestion 13: You want to connect a Tableau workbook to a dataset in a Mic...
1 commentQuestion 14: You have the following bar chart. (Exhibit) You want the cha...
Question 15: Open the link to Book1 found on the desktop. Open the Line w...
1 commentQuestion 16: You have a dataset that contains daily sales by business seg...
Question 17: You have the following dashboard. (Exhibit) Currently the ma...
1 commentQuestion 18: You have the following dataset. (Exhibit) You need to create...
Question 19: You publish a dashboard tut uses an attract. The extract ref...
Question 20: A colleague provides you with access to a folder that contai...
Question 21: in which throe formats can you export a worksheet from the W...