IBM Cognos ICM Essentials (C2020-004) Free Practice Test

Question 1

Which table property can be changed after it is saved?

A. primary key

B. description

C. type

D. name

Correct Answer: B

Question 2

Click the Exhibit button.

Referring to the exhibit, yourmodel has two calculations - "Revenue"and"Commission"partitioned byPayeeID, ProductGroup, Product, and Month.
What must you create to produce the summary report that shows revenue and commission by ProductGroup and Month?

A. Aggregate Transformations in Presenter partitioned by ProductGroup and Month

B. additional calculations to sum the results partitioned by ProductGroup and Month

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

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

Correct Answer: B

Question 3

Which two statements about Presenter Data Grids are true? (Choose two.)

A. A Data Grid can be created by dragging a source into the report layout.

B. A Data Grid can be exported to a Word document.

C. Duplicate values can be removed by clicking Show Section Headers checkbox.

D. A Data Grid can only have one Data Source associated with it.

Correct Answer: A,D

Question 4

What does naming Layout Tables in Presenter allow you to do?

A. Migrate each Layout Table independently through the Migration T001.

B. Set which Layout Tables are viewable and editable in a Workflow.

C. Easily identify the purpose and contents of each Layout Table.

D. Reuse Layout Tables in multiple Presenter Reports.

Correct Answer: B

Question 5

Which statement is correct regarding Layout Tables in Presenter?

A. Two tables can be swapped as long as one is not the parent of the other.

B. Once it is defined, the number of rows and columns cannot be changed.

C. Every cell in a Layout Table must contain a report object.

D. Cells and columns within a Layout Table can be merged.

Correct Answer: A

Question 6

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?

A. Include empty partitions

B. Rightouterjoin

C. Anchor source rows

D. Fullouterjoin

Correct Answer: C

Welcome to TestSimulate

IBM Cognos ICM Essentials (C2020-004) Free Practice Test