Free Salesforce Tableau Desktop Foundations Practice Test Questions

Explanation:
When connecting to data in Tableau Desktop, the start page displays commonly used connectors. To view the complete list of available server-based data connections, the associate must click "More" under the "To a Server" section. This expands the full list of supported server connectors, such as Microsoft SQL Server, Oracle, PostgreSQL, Snowflake, and others.

Correct Option:

Select More under To a Server:
This reveals the full list of server data sources Tableau Desktop can connect to. The start page only shows a few popular connectors by default, so clicking "More" expands the complete list of supported server connections.

Incorrect Option:

Select Connecting to Data:
This is a general category/heading on the start page, not an actionable link that expands server connection options.

Select File on the menu, and then select New:
This creates a new workbook, not a new data connection, and does not display the list of server connectors.

Select More under To a File:

This expands file-based connectors (Excel, CSV, JSON, PDF, etc.), not server connections.

Reference: Tableau Desktop Help — "Connect to Data" / Tableau Desktop and Web Authoring Help: Connect to a Server.

Explanation:
A Tableau relationship should be used when datasets contain similar data aggregated at different levels of detail. Unlike joins, which merge tables into a single flat structure and can duplicate aggregate values, relationships preserve each table's native level of detail . This makes relationships ideal for analyzing measures that exist at different granularities without requiring complex Level of Detail (LOD) calculations .

Correct Option:

Option D: The data sets include similar data aggregated at different levels of detail.
Relationships maintain the original granularity of each table and automatically handle aggregation context based on the fields used in the visualization . Tableau performs context-based joins behind the scenes, preventing duplication of aggregated values and preserving unmatched records .

Incorrect Options:

Option A: To use both data sets across multiple sheets in a visualization.
Both relationships and joins allow using data across multiple sheets. This is not a distinguishing factor for choosing relationships over joins .

Option B: The data sets are in two separate tables within a single spreadsheet.
The physical location of tables (same spreadsheet or different sources) does not determine whether to use relationships or joins. Both methods can combine tables from the same spreadsheet .

Option C: The data sets include similar data aggregated up to the highest level.
When data is already aggregated to the same level, a join may suffice. Relationships are specifically valuable when levels of detail differ between tables .

Reference:
Tableau Help – Relate Your Data (Relationships vs Joins) ; Tableau Help – How Relationships Differ from Joins