IBM Cognos TM1 Developer V10.2 — Question 32

A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?

Answer options

• A. The performance on the join could be improved.
• B. The result set from the join would return less rows.
• C. The result set from the join would return more rows.
• D. The join relationship would work on multiple fields in each table.

Correct answer: A

Explanation

Setting a filter join can enhance performance by reducing the amount of data processed during the join operation. Options B and C refer to the quantity of rows returned, which is not the primary benefit of a filter join. Option D discusses the scope of the join across multiple fields, which is unrelated to the performance improvement aspect.