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

The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:

B. IIF(SUM([Sales]) > 50000, TRUE, FALSE) D. [Sales] > 50000

The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false.

The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise.

The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales] , 50000, which is not valid syntax. The function will return an error. References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX

Bins divide a continuous numeric measure into a series of equal-sized ranges, making them the correct Tableau feature for analysing a salary distribution. For example, salary values could be divided into intervals of £10,000, with each employee assigned to the corresponding salary bin. The resulting binned dimension can then be used to create a histogram showing the frequency of salaries in each interval. Tableau documentation describes each bin as an equal-sized container representing a defined numeric range. A Group combines selected dimension members manually or logically, but it does not inherently create equal numeric intervals. A hierarchy establishes drill-down relationships between dimensions, while a Set defines a subset of dimension members according to selection or rules. Therefore, Bins directly satisfy the requirement to divide a continuous salary range into equal intervals.

To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets

In Tableau, sets can be combined if they are created from the same dimension. From the options provided, " Customers of 2020 " and " Top N Customers " are likely created from the same dimension (Customers). Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like " Top N Products " with " Customers of 2020 " would not be feasible unless they are from the same dimension, which is typically not the case.

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.