Analytics-DA-201 Exam Dumps - Salesforce Tableau Data Analyst Questions and Answers

A standard dimension filter is evaluated after a FIXED Level of Detail expression in Tableau’s order of operations. FIXED LOD calculations establish their result using the dimensions specified in the expression without reference to the dimensions currently in the view, and they are computed before ordinary dimension filters. Consequently, applying a normal dimension filter changes which marks or records are displayed in the worksheet, but it does not recalculate the FIXED result based on that filter. If the analyst needs the filter to affect the FIXED LOD, the filter can be promoted to a context filter because context filters are evaluated earlier. The question specifies only a dimension filter, so the correct behavior is that the displayed data changes while the FIXED LOD calculation remains unaffected.

The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to in clude a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position.  References:  The information is inferred from general Tableau knowledge as well as the following sources:

Tableau Functions (Alphabetical)

LOOKUP

Tableau Certified Data Analyst Exam Guide

Tableau Desktop supports custom mark shapes by loading image files from the Shapes folder inside My Tableau Repository. The analyst should copy the new shape files into a folder under My Tableau Repository\Shapes. Tableau uses that folder as a custom shape palette, and the analyst can then select the shapes from the Marks card by choosing Shape and editing the shape assignment. Once custom shapes are used, they are stored with the workbook, which supports sharing the visualization with other users. Dragging image files directly into a workbook does not register them as reusable mark shapes, and a URL cannot be used as the workbook’s shape repository. My Tableau Prep Repository is also incorrect because Tableau Prep is not where Tableau Desktop mark-shape palettes are stored.

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year’s sales, and then divides this by the previous year’s sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter. References:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

Tableau relationships provide a logical-layer approach to combining tables without requiring a fixed join type when the data source is created. The related tables remain separate, preserving their native level of detail. When a visualization is queried, Tableau evaluates the fields currently being used and automatically determines the appropriate joins required for that analytical context. This makes relationships dynamic and context-aware. Option A is incorrect because the matching fields that define the relationship are established when the relationship is configured; they do not change simply because of user interactions. Option B is incorrect because relationships do not store the entire data source in a pre-aggregated format. Option D describes physical joining more closely because relationships specifically avoid merging all related tables into one physical table. Therefore, C accurately describes the principal advantage.

The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.

Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.

You can learn more about navigation objects and how to use them in this article: https://help.tableau.com/current/pro/desktop/en-us/dashboards_navigation.htm