Salesforce Updated Analytics-DA-201 Exam Questions and Answers by lilly-mae

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.

The Item hierarchy separates the top-level floating objects from the objects nested under the Tiled section. In the exhibit, Show/Hide, Filters Container, and Legend appear at the top level before the Tiled branch. Total Sales and Horizontal Container are nested inside vertical containers under Tiled, so they belong to the tiled layout structure. Tableau distinguishes tiled items, which participate in a non-overlapping layout grid, from floating items, which can be positioned and layered independently. In Tableau Desktop, floating objects appear at the top level of the Item hierarchy and can be reordered to control their layering. Reading the hierarchy therefore identifies B, D, and E as floating, while A and C are contained within the tiled hierarchy and are not floating objects.

You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for “Central” as “Midwest”.

In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.

There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:

SUM([Sales])

LOOKUP(SUM([Sales]), -1)

PREVIOUS_VALUE(0)

 To calculate the sales growth over each year, you need to compare the current year’s sales with the previous year’s sales and divide the difference by the previous year’s sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:

(SUM([Sales]) - LOOKUP(SUM([Sales] ), -1)) / PREVIOUS_VALUE(0)

This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales] )) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.