Skip to main content

C2020-004 Real Exam Questions

IBM Cognos ICM Essentials

60 questions available · Page 1 of 6

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which two elements would be used as a data source in a Presenter report across all levels of Composer? (Choose two.)

  1. A

    Calculations

  2. B

    Data tables

  3. C

    Data Stores

  4. D

    Global tables

Show answer and explanation

Correct answers: C, D

Question 2 Multiple choice

In creating a Portal Access group, enabling ¡°Maintain this group in Task Manager¡± is an option.
If this option is checked, which two statements are true? (Choose two.)

  1. A

    Group members will be maintained in Task Manager based on defined group restrictions.

  2. B

    Web access can be granted to the group members in Task Manager.

  3. C

    Members need to be added to the group manually.

  4. D

    Enable group members for Web and notify them of their passwords in Portal Access.

Show answer and explanation

Correct answers: A, B

Question 3 Single choice

Your client assigns monthly quotas for each individual payee separately.
In addition to the PayeeID column, which column should be part of the primary key of a quota table?

  1. A

    Start Date

  2. B

    Quota

  3. C

    End Date

  4. D

    Reports To

Show answer and explanation

Correct answer: A

Question 4 Single choice

When joining two data sources in a Data Store, what should you select to ensure that all records of the first data source will return, even if the join does not find matching records in the second data source?

  1. A

    Anchor source rows

  2. B

    Rightouterjoin

  3. C

    Fullouterjoin

  4. D

    Include empty partitions

Show answer and explanation

Correct answer: A

Question 5 Single choice

A company has three levels of disputes. The sales representative identifies the incorrect commission amount and submits an inquiry. The inquiry is then reviewed by a manager who then escalates it to the administrators to make changes based on the manager's reviewed notes.
For this scenario, which group should be at the top of the inquiry tree?

  1. A

    Administrator

  2. B

    Manager

  3. C

    Sales Representative

  4. D

    VP

Show answer and explanation

Correct answer: C

Question 6 Single choice

You are setting up LDAP integration for Admin client.
In addition to configuring the LDAP settings of the IBM Cognos ICM Windows Service, what must you do before users log into Admin client using LDAP credentials?

  1. A

    LDAP users can log in as soon as the LDAP settings of the IBM CognosICMWindows Service configuration file have been set up properly.

  2. B

    LDAP users need to be added to the Payee table.

  3. C

    LDAP users need to be added to the LDAP tab in the Admin client.

  4. D

    LDAP users can log into the Admin client as long as they can access the Web client using LDAP credentials.

Show answer and explanation

Correct answer: C

Question 7 Multiple choice

Which two scenarios will produce a conflict during the migration of a single component? (Choose two.)

  1. A

    The component has a calculation in the source model which resides in a different component in the target model.

  2. B

    The component has a calculation that exists only in the source model.

  3. C

    The component has a table that exists in the target model but has been deleted in the source model.

  4. D

    The component has a table with the same name in both models but different number of key columns.

Show answer and explanation

Correct answers: A, D

Question 8 Single choice

Click the Exhibit button.

Referring to the exhibit, you are creating a calculation with the "Payment" calculation as the source and "Period" as the only accumulating partition.

What will be the value of the record with a PayeeID = "0002" and Period = "2012, February"?

  1. A

    $2500

  2. B

    $3500

  3. C

    $6000

  4. D

    $7000

Show answer and explanation

Correct answer: C

Question 9 Multiple choice

When using an effective dated table as a source for a calculation, which two statements are true? (Choose two.)

  1. A

    Join start and end date of the effective dated table to a single date.

  2. B

    Join the calendar table to the effective dated table.

  3. C

    Join on both effective dates.

  4. D

    Join an effective dated table to another effective dated table (not Time).

Show answer and explanation

Correct answers: A, C

Question 10 Single choice

Click the Exhibit button.

Referring to the exhibit, your model has two calculations "Revenue" and "Commission" - partitioned by PayeeID, ProductGroup, Product, and Month.

What must you create to produce the summary report that shows revenue and commission by ProductGroup and Month?

  1. A

    a Data Store that joins both calculations and select ProductGroup and Month as detail columns

  2. B

    Aggregate Transformations in Presenter partitioned by ProductGroup and Month

  3. C

    additional calculations to sum the results partitioned by ProductGroup and Month

  4. D

    Calculated Rows in Presenter that sum both values by ProductGroup and Month

Show answer and explanation

Correct answer: C