Which of the following would you use to connect to multiple tables in a single data source at once?

Question

Options

• AA Blend
• BA Hierarchy
• CA Set
• DA Join

• A
  2% (1)
• B
  4% (2)
• C
  2% (1)
• D
  91% (41)

Explanation

Joins are the mechanism for combining multiple tables from the same data source into a unified dataset by matching rows on a common field (e.g., a shared ID column) - exactly what the question describes. Blends (A) are used when connecting tables across different data sources, not within a single one, making it a common but incorrect trap here. Hierarchies (B) organize dimensions into drill-down levels (e.g., Year → Quarter → Month) and have nothing to do with connecting tables. Sets (C) define custom subsets of members within a single dimension and are a filtering/grouping tool, not a table-connection method.

Memory tip: Think of the SQL you already know - JOIN literally joins tables. If you're in one source, you join; if you're bridging two sources, you blend.

No community discussion yet for this question.