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

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.

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.

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.