Free Salesforce Analytics-DA-201 Practice Exam with Questions & Answers

To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.

The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user] ) = USERNAME() is not a valid expression in Tableau. ‘S’ + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of “S”. References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm

In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME] , which will return true for rows where the Tableau_User_Name matches the current user ' s username.

A Go to URL action is the correct Tableau action for opening an email client from a dashboard object. Tableau URL actions can target external resources and support the mailto: URL scheme. The analyst can configure the source sheet or mark represented by the envelope icon and use a URL such as mailto:support@example.com. When the user activates the configured action, the operating system opens the default email application with the destination address populated. Change Set Values modifies set membership, Filter actions restrict marks in target views, and Go to Sheet navigates to another worksheet, dashboard, or story in the same workbook. None of those actions can launch a pre-addressed email. Therefore, Go to URL is the appropriate action type for the requirement.

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To ensure that the data is updated every hour on Tableau Server, you would need to go to the " Extract Refreshes " option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

A full outer join preserves every row from both physical tables, returning matched records where possible and null values where a corresponding row does not exist. That directly satisfies the requirement to retain books that appear in only one of the two incomplete tables. A Tableau relationship can also satisfy the requirement because relationships keep logical tables separate and defer physical joining until analysis time. Tableau dynamically determines the appropriate joins based on fields used in the visualization and makes the row and column data from related tables potentially available without permanently collapsing the tables. Left or right joins would discard unmatched rows from one side, while an inner join retains only matches. Therefore, Full outer join or Relationship model is the correct combination.

A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.