Free TDS-C01 sample questions

Correct answer: True

This statement is true. When Tableau attempts to convert a data type, it follows specific rules. If a string value cannot be parsed into the target numeric format (e.g., 'N/A' cannot become a whole number), Tableau will assign a Null value to it. This is a key data preparation behavior to understand.

Correct answer: A left join with 'Orders' on the left

A left join with the 'Orders' table on the left is the correct method. This ensures that all records from the 'Orders' table are kept, and matching return information from the 'Returns' table is appended where an `Order ID` match exists. For orders that were not returned, the fields from the 'Returns' table will be Null. An inner join would only show orders that were returned. A relationship would also work, but the question asks for a specific approach to combine tables to ensure all orders are included, and a left join explicitly achieves this at the physical layer.

Correct answers: A parameter; A calculated field

A parameter is needed to store the user's selection (e.g., 5%, 10%, 15%). It acts as a dynamic variable that is not tied to the data source.

A calculated field is required to use the value from the parameter in a calculation (e.g., `SUM([Sales]) * (1 + [Sales Increase Parameter])`). The calculation's result changes dynamically as the user changes the parameter value.

Correct answer: It ensures consistent analysis by sharing the data model's metadata and customizations.

The primary benefit of a .tds file is that it stores the connection information and all the metadata layer customizations (renamed fields, hierarchies, default formats, calculated fields, etc.). By sharing the .tds file, the organization ensures that every analyst starts with the same clean, standardized, and enriched data model, leading to consistent and reliable analysis. A .tds file does not contain the actual data; a .tdsx (packaged data source) does. While it can be part of a security strategy, its primary purpose is metadata management, not security enforcement.

Correct answer: Use the map worksheet as a filter.

The most direct method is to select the map worksheet on the dashboard, click the 'Use as Filter' icon (funnel shape) from its context menu. This automatically creates a filter action where the map (source sheet) filters the other worksheets (target sheets) on the dashboard when a mark (a state) is selected.

Correct answer: Create an alias for the member 'east'.

Creating an alias is the correct method for changing the display name of a specific member (a data value) within a dimension. By right-clicking the 'east' member in the Data pane or in a view and selecting 'Edit Alias', the analyst can change its display value to 'East'. Tableau will then aggregate both 'East' and 'east' together under the alias. Renaming the field changes the field name, not its values. Grouping would create a new dimension. A calculated field could also solve this but is more complex than using a simple alias for this specific problem.

Correct answer: Discrete Month (e.g., May)

To aggregate data for a specific time period across all years, you must use a discrete date part. Selecting the discrete Month (blue pill, shows 'May') will treat 'May' as a categorical label and aggregate all data for May, regardless of the year. Using a continuous Month (green pill, shows 'May 2023') would create a timeline where each month/year combination is a distinct point on a continuous axis, which would not achieve the desired aggregation.

Correct answer: Context filters create a temporary, smaller dataset that all other filters query against, improving performance.

The key difference lies in Tableau's order of operations. A context filter is applied before most other filters (like standard dimension or measure filters). It effectively creates a temporary table or 'context' from the data source. All subsequent filters and calculations then run only on the data that passes through the context filter. This can significantly improve performance on large datasets and is necessary when you want a dimension filter to apply before a FIXED LOD calculation. Dimension filters are applied after context filters and FIXED LODs.

Correct answer: Tableau generates a query that performs a context-aware join, fetching only the necessary fields from both tables to compute the result.

Relationships (the logical layer) are a key feature in modern Tableau. Unlike traditional joins that create a fixed, flattened table, relationships maintain the separate nature of the tables. When a user builds a viz, Tableau analyzes the fields being used and generates an optimized, context-aware query. In this case, it will perform the equivalent of a left join from Products to Shipments on `ProductID` to get the counts for each category, but only for the specific fields required, preserving the correct level of detail and improving performance.

Correct answer: A Quick Table Calculation.

A Quick Table Calculation is the most direct way to achieve this. By right-clicking the `SUM(Sales)` pill in the view, selecting 'Quick Table Calculation', and then 'Percent of Total', you can add this calculation. You would then adjust the 'Compute Using' setting to 'Pane (Down)' or 'Sub-Category' to ensure the percentage is calculated within each pane (Region).