IBM Cognos TM1 Developer V10.2 — Question 21

A report author is considering which SQL syntax to use for accessing various Data sources.
What is the advantage of using one type of SQL syntax above another?

Answer options

• A. Cognos SQL can use non-standard SQL.
• B. Cognos SQL works on any supported database.
• C. The performance is optimized across all related query subjects with Pass Through SQL.
• D. With Pass Through SQL and Native SQL, the SQL may not work on a different database.

Correct answer: C

Explanation

The correct answer, C, highlights that Pass Through SQL optimizes performance by directly interacting with the database, making it efficient for related query subjects. Options A and B are true but do not directly address the performance aspect, while option D points out a limitation of SQL types but does not emphasize the performance optimization offered by Pass Through SQL.