TDS-C01 Sample Questions & Answers

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.

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.

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.

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.

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.

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.

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).

The Show/Hide button is extremely useful for mobile design. It allows you to place objects like filters or legends inside a floating container and then create a button that toggles the container's visibility, saving valuable screen space until the user needs those controls.

Vertical containers are fundamental for mobile design. Because mobile screens are typically tall and narrow, arranging worksheets, filters, and legends vertically within a container ensures a logical, scrollable flow that fits the device's form factor.

A live connection is the appropriate choice in this scenario. It sends queries directly to the source database whenever a user interacts with the visualization. This ensures that the data is always up-to-date. While performance depends on the database, the scenario specifies a 'high-performance database', making a live connection the ideal method for real-time analysis on large datasets where extracts are impractical.

The quickest and most intuitive way to sort a chart by a measure is to use the one-click sort icons. Hovering over the axis for the measure (in this case, the Profit axis) will reveal a small sort icon. Clicking this icon will instantly sort the corresponding dimension (State) in descending order based on the measure's value. Clicking it again will sort in ascending order.