Salesforce Analytics-DA-201 - Salesforce Certified Tableau Data Analyst

Tableau CASE logic evaluates one expression and compares its result against the values provided in successive WHEN clauses. In option B, the initial expression evaluates whether aggregated Profit is greater than zero, producing a Boolean result. WHEN TRUE then returns “Profitable,” while the ELSE branch returns “Unprofitable.” The other choices do not follow valid CASE comparison structure. Option A attempts to use OR between string literals inside one WHEN value. Option C places the comparison operators before values rather than supplying values that can be compared against the CASE expression. Option D similarly combines a string literal with an AND condition in a WHEN clause that is being compared against Category. Tableau’s documented CASE structure is CASE < expression > WHEN < value > THEN < result > ... ELSE ... END, making B the valid choice among those provided.

To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])) . This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.

Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):

Student ID 4183: 39 (Rank 1)

Student ID 4220: 71 (Rank 6)

Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)

Student ID 4124: 75.5

Student ID 4050: 64

Student ID 4205: 67

Student ID 4056: 66

Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.

Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.

https://help.tableau.com/current/prep/en-us/prep_calculations.htm

To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:

Format Dashboards - Tableau

Tableau Certified Data Analyst Study Guide

The current view contains only one aggregated Discount mark for each Vendor, so Tableau does not have enough individual marks within each vendor partition to calculate a meaningful distribution. Adding Invoice Number to Detail increases the level of detail so that each invoice contributes an individual Discount mark while Vendor remains the grouping dimension. Tableau can then calculate quartiles, median, whiskers, and outliers from the underlying distribution. Tableau’s box-plot guidance lists a dimension on Detail as one of the fundamental building blocks of a box-and-whisker plot. Changing the whisker configuration would affect how an already valid distribution is displayed but would not create the missing observations. Count Distinct and converting Discount to discrete would alter the analytical meaning rather than establish the correct mark granularity. Therefore, B is correct.

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Refresh Data on a Schedule

Tableau Help: Manage Refresh Tasks

Tableau Prep ' s Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.