Skip to main content

C2090-621 Real Exam Questions

IBM Cognos Analytics Author V11

104 questions available · Page 1 of 11

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

A report author wants to create an Active report with a Static Deck/ Each card should show a Chart with differently-filtered data.

What should the Chart for each card be based on?

  1. A

    An item that is a property of the page.

  2. B

    A query item that is a property of the Chart.

  3. C

    A unique query with a filter applied to the query.

  4. D

    Reuse the same query with a filter applied to the query.

Show answer and explanation

Correct answer: B

Question 2 Single choice

An author wants to add a visualization to a Dashboard that will allow users to explore correlations between different measures.

Which type of visualization should be used?

  1. A

    Pie

  2. B

    Heat

  3. C

    Radial

  4. D

    Scatter plot

Show answer and explanation

Correct answer: D

Explanation

References:
https://community.watsonanalytics.com/wp-content/uploads/2016/06/
HowtoaddextensiblevisualizationtoCognosActiveReports-AllVisualizations.pdf

Question 3 Single choice

A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price.
The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

What must the report author do for the report to look like the following?

  1. A

    Set the detail aggregation property to Automatic for each field.

  2. B

    Set the detail aggregation property to None for product line and order method. Total for Revenue.
    Average for Unit Sale Price.

  3. C

    Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.

  4. D

    Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.

Show answer and explanation

Correct answer: C

Question 4 Single choice

A report author would like to create multiple variable connections in a report that contains one control and two Lists in order to compare data.

Which statement is true?

  1. A

    It is not possible to create two connections unless there are two different controls and two Lists.

  2. B

    The report author should be able to create two connections only if the values have the same data type.

  3. C

    The report author should be able to create one or more connections but the variable's Behavior should be the same.

  4. D

    The report author should be able to create multiple connections on one control by creating new connections, both variables can also show different Behavior.

Show answer and explanation

Correct answer: D

Question 5 Single choice

A report author wants to use a calculation which is not a string function to manipulate text.

Which function can be used?

  1. A

    trim()

  2. B

    lower()

  3. C

    extract()

  4. D

    substring()

Show answer and explanation

Correct answer: B

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug.cogtr.doc/c_textfunctions_tr.html

Question 6 Single choice

A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

Which filter should be used?

  1. A

    A detail filter as [Revenue] >= 100000000 with application set to before auto aggregation.

  2. B

    A detail filter as [Revenue] >= 100000000 with application set to after auto aggregation.

  3. C

    A detail filter for Total([Revenue]) >= 100000000 with application set to before auto aggregation.

  4. D

    A detail filter for Total([Revenue]) >= 100000000 with application set to after auto aggregation.

Show answer and explanation

Correct answer: D

Question 7 Single choice

A report author needs to create filters in Cognos Analytics ?Reporting.

What arte the three different types of filtering?

  1. A

    Required, Optional and Disabled

  2. B

    Detailed, Summary and Parameterized

  3. C

    Custom based in data item, Combined and Advanced

  4. D

    Before Auto-Aggregation, After Auto-Aggregation and with Scope

Show answer and explanation

Correct answer: C

Question 8 Single choice

A report author is going to develop a report and wants to ensure that the layout if defined correctly.

What should be done first?

  1. A

    Modify the global class definitions for the specific objects.

  2. B

    Select the objects that require changes and modify the properties.

  3. C

    Add a table to control the position of each object on the report page layout.

  4. D

    Choose the proper template and theme before starting the report development.

Show answer and explanation

Correct answer: D

Question 9 Single choice

A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.

How can this be done?

  1. A

    Enable share result set on the list object.

  2. B

    Create a join in the Query explorer to merge the data.

  3. C

    Select the list and define a Master detail relationship.

  4. D

    Select the chart and define a Master detail relationship.

Show answer and explanation

Correct answer: D

Question 10 Single choice

A report author wants to generate an Active Report with a Chart, and allow the user to highlight a column within the Chart when a radio button is selected.

How should the report be created?

  1. A

    Using a Data deck.

  2. B

    Apply a client side filter.

  3. C

    Setting the Dynamic Chart property.

  4. D

    Setting the local processing property.

Show answer and explanation

Correct answer: A