Salesforce Updated Analytics-DA-201 Exam Questions and Answers by ameera

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either ‘Sciences’ or ‘Humanities’. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign ‘Humanities’ to any subject that contains ‘Science’ in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with ‘Computer Science’ and ignore the other subjects. References:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

A Top N filter is applied to categorical members, so the field being filtered should be a discrete dimension. When a discrete dimension is placed on the Filters shelf in Tableau Desktop, the Filter dialog provides General, Wildcard, Condition, and Top tabs. The Top tab can then retain the top or bottom N members based on an aggregate measure, such as the top 10 customers by SUM(Sales). A continuous measure uses quantitative range filtering rather than the dimension-member Top interface. A table calculation is evaluated later in Tableau’s order of operations and is not the field type used to configure a standard Top N dimension filter. A set can itself be defined using a Top rule, but it is a separate object rather than the required field type for this filter. Therefore, C is correct.

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting “Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.

To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:

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

Tableau Help: Publish a Workbook