Skip to main content

C2090-620 Online Practice Questions

IBM Cognos 10 BI Author

50 questions available · Page 1 of 5

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

An author wants to apply formatng to a list report. In Report Studio, the author clicks a column in the list, clicks Select Ancestor, and then clicks List Columns.
In this situaton, which of the following is true?

  1. A

    Formatng all columns will also format aggregate rows in the list.

  2. B

    Formatng all columns overrides formatng for an existng formated column in the list.

  3. C

    Formatng all columns afects all subsequent objects added to the report page.

  4. D

    Formatng all columns ensures any new columns added to the list will have the same formatng.

Show answer and explanation

Correct answer: D

Question 2 Single choice

In Report Studio, when would the author need to unlock cells on a report?

  1. A

    To merge two report types into a single report.

  2. B

    To merge query items into a single column.

  3. C

    To merge a query item into a text item.

  4. D

    To merge report objects in table.

Show answer and explanation

Correct answer: B

Question 3 Single choice

An author creates a report in Report Studio. The report contains a parameter for the Product line query item. The author wants to let users drill through to this report from a variety of reports created using the GO Data Warehouse (query) package. To ensure that this target report contains data for the appropriate products, the author wants to limit the report cells that users can drill through from in source reports.

What must the author do when creatng the drill-through defniton?

  1. A

    Set the Product line query item as the target of the drill-through defniton.

  2. B

    Set the Product line query item as the scope of the drill-through defniton.

  3. C

    Add a parameter for the Product line query to the drill-through defniton.

  4. D

    Delete all data items except for the Product line query item from the drill-through defniton.

Show answer and explanation

Correct answer: B

Question 4 Single choice

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

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

  1. A

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

  2. B

    Only cites that generated total revenue greater than 500,000.

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: A

Question 5 Single choice

In Report Studio, which variable requires the author to create values?

  1. A

    Style

  2. B

    String

  3. C

    Boolean

  4. D

    Language

Show answer and explanation

Correct answer: B

Question 6 Single choice

In Report Studio, a query contains the data item Product Line, which is grouped.

Which of the following will add a page break for each Product Line?

  1. A

    Create a secton on Product Line.

  2. B

    Add a new page for each Product Line.

  3. C

    Set the rows per page property to Product Line.

  4. D

    Create a page set that is associated with the query.

Show answer and explanation

Correct answer: D

Question 7 Single choice

In Report Studio, what is a baseline?

  1. A

    A value in a list report that other values are compared against.

  2. B

    A constant value that represents the x-axis in a chart.

  3. C

    A constant value drawn on a chart to indicate major divisions in the data.

  4. D

    A break point that keeps part of a report statonary while the user scrolls.

Show answer and explanation

Correct answer: C

Question 8 Single choice

In Report Studio, when creatng a list report, what is the diference between creatng a secton and creatng a header?

  1. A

    Headers appear outside the list.

  2. B

    Sectons appear outside the list.

  3. C

    Headers appear once at the top of the list.

  4. D

    Sectons appear once at the top of the list.

Show answer and explanation

Correct answer: B

Question 9 Single choice

In Report Studio, which chart lets the report author plot a third measure?

  1. A

    Area

  2. B

    Bubble

  3. C

    Scater

  4. D

    Progressive Column

Show answer and explanation

Correct answer: B

Question 10 Single choice

In the image below,

the last column calculates the percentage that each Product type contributed to the overall revenue.

What is the calculaton in the last column?

  1. A

    percentage ([Revenue])

  2. B

    percentage ([Revenue] for Product type)

  3. C

    percentage ([Product type] for [Revenue])

  4. D

    percentage ([Product type])

Show answer and explanation

Correct answer: A