Analytics-101 Exam Preparation Material | Salesforce Certified Tableau Desktop Foundations

Explanation:
By default, both field names are present in the Union, but contain several null values!
When field names in the union do not match, fields in the union contain null values. You can merge
the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.
You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."



A union of these tables creates the following single table that contains all rows from all tables.



Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."






Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm

Explanation:
In Tableau, the two elements that can have their values changed by using a dashboard action are Sets and Parameters. Dashboard actions can be configured to modify the values within a set or a parameter, allowing for interactive and dynamic changes in the visualization based on user interactions. For example, selecting a specific data point in a dashboard can trigger an action that updates a set or changes the value of a parameter, which in turn can alter the displayed data or the appearance of visualizations within the dashboard.

Explanation:
The following are the official definitions from the Tableau documentation for the various file types:
1) .tds (Tableau Data Source) - To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)
2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data.
3) Extract (.hyper or .tde) C To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
3) (.twb) Workbooks C To hold one or more worksheets, plus zero or more dashboards and stories.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

Explanation:



Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them.
If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.
Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

Explanation:
When we create a reference line, we get the following 3 options for the scope:



Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm