You have the following dashboard.

Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?

• A.From the context menu of Sales over lime select Remove Dashboard Item
• B.From the context menu of Profits by Stale deselect Use as Filter
• C.From the context menu of Sales over time select Ignore Actions
• D.From the context menu of Sales over time select Deselect

Comment: *

Name: *

Email: *

Verification: *

You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?

• A.From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter
• B.From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
• C.From the context menu of Detail table, select Ignore Actions.
• D.From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.

Comment: *

Name: *

Email: *

Verification: *

You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should you use?

• A.Left only
• B.Union
• C.Inner
• D.Left
• E.Full outer

Comment: *

Name: *

Email: *

Verification: *

You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.

• A.The data must be extracted.
• B.The data source must be stored as a hyper file.
• C.The credentials must be embedded.
• D.The data source must use a live connection.

Comment: *

Name: *

Email: *

Verification: *

You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Correct Answer:

Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
FIRST ()
0
COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

Comment: *

Name: *

Email: *

Verification: *