ExamGecko
Question list
Search
Search

Question 208 - TDS-C01 discussion

Report
Export

Which of the following are FALSEabout Joins?

A.
Joins can be defined at the time of query dynamically
Answers
A.
Joins can be defined at the time of query dynamically
B.
May drop unmatched measure values
Answers
B.
May drop unmatched measure values
C.
They are displayed with Venn diagram icons between physical tables
Answers
C.
They are displayed with Venn diagram icons between physical tables
D.
Joined tables are never merged into a single table.
Answers
D.
Joined tables are never merged into a single table.
E.
They are a more dynamic way than relationships to combine data
Answers
E.
They are a more dynamic way than relationships to combine data
Suggested answer: A, D, E

Explanation:

According to the official documentation:

Joins are a morestaticway to combine data. Joins must be defined between physical tables up front, before analysis, and can't be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.

Joins -

1) Are displayed with Venn diagram icons between physical tables

2) Require you to select join types and join clauses

3)Joined physical tables are merged into a single logical table with a fixed combination of data

4) May drop unmatched measure values

5)May duplicate aggregate values when fields are at different levels of detail

6) Support scenarios that require a single table of data, such as extract filters and aggregation

asked 23/09/2024
Tillmon, Quinton
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first