IBM C2090-620 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-620
Exam Name/Title: IBM Cognos 10 BI Author
Certification Provider: IBM
Corresponding Certification: IBM Cognos

Exam Questions: 50
Updated On: May 26, 2026

Question #6

The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country.

What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter AFTER auto aggregation?

A. Only reps who generated total revenue greater than 500,000.

B. Only reps who had individual sales transactions of greater than 500,000.

C. Only countries that generated total revenue greater than 500,000.

D. Only cities that generated total revenue greater than 500,000.

Discussion 0

Correct Answer: A Vote an answer

Question #7

In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. After editing the SQL, the author wants to add a new data item to the query. How can the author add the data item?

A. The author must add the data item to the query from the package displayed on the Source tab.

B. The author must convert the edited SQL back to a query object and then add the data item.

C. The author must edit the SQL statement so that the query retrieves an additional data item.

D. The author must add a query reference to the existing query and then add the data item to the referenced query.

Discussion 0

Correct Answer: C Vote an answer

Question #8

In Report Studio, an author creates a weekly sales report and modifies the global class settings in the report. Which reports will this modification affect?

A. All reports.

B. Reports created within the log on session.

C. Reports created using the same package.

D. Only the current report.

Discussion 0

Correct Answer: D Vote an answer

Question #9

In Report Studio, an author creates the following report: The author wants each row of this report to contain a column chart displaying quantity sold for a particular product line. How can the author ensure that the chart in each row displays data for only the product line that appears in the same row?

A. Add a column chart to the list, add data to the chart and then create a master-detail relationship between the queries for the list and the chart.

B. Add a column chart to the list, add data to the chart and then create a union relationship between the queries for the list and the chart.

C. Add a column chart to the list, add data to the chart and then create an intersect relationship between the queries for the list and the chart.

D. Add a column chart to the list, link the column chart to the same query used for the list and then add data to the chart.

Discussion 0

Correct Answer: A Vote an answer

Question #10

In Report Studio, what is true about a crosstab node?

A. It contains at least one nested crosstab node.

B. It can contain an empty crosstab node member.

C. It contains at least one crosstab node member.

D. It contains more than one nested crosstab node.

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM C2090-620 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-620 exam.