IBM Cognos ICM Essentials Sample Questions:
1. Which two statements about Structural tables are true? (Choose two.)
A) Structural tables always have a single-column primary key.
B) They can only be generated when the model is created.
C) Pick lists can pick from Structural tables.
D) The primary key can be a date column.
2. Which two statements about IBM Cognos ICM tables are correct? (Choose two.)
A) Data tables are associated with a calendar.
B) Primarykeysareoptional.
C) Primary keys in a Structural table must be Text box column.
D) Other tables can Pick List to a Custom table.
3. The CEO of a company assigns a quota for the year. The quota is then distributed to regions and regional managers who then distribute the quotas to district level managers. An administrator is advised to start the approval process.
If a Portal Access tree is created, which assignment needs to take place?
A) Access
B) Inquiry
C) Swim lane
D) Sign off
4. When applying the Standard Build Framework, which two principles do you follow? (Choose two.)
A) Every custom table in the model should have a pick list to the CompPlan table.
B) When joining AttributeIDs, you should base restrictions and joins on the four attribute columns.
C) You must hard-code theAttributeIDwhen building static data stores and reports.
D) Outbound ports with the same partitions should be combined into one port with anAttributeIDpartition
5. 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) Anchor source rows
C) Rightouterjoin
D) Fullouterjoin
Solutions:
| Question # 1 Answer: A,C | Question # 2 Answer: A,C | Question # 3 Answer: D | Question # 4 Answer: B,D | Question # 5 Answer: B |
We're so confident of our products that we provide no hassle product exchange.


By Theodore

