Test COG-132: IBM Cognos 8 BI Metadata Model Developer

Hi Friends,

I am going to start a series of posts listing sample IBM Cognos certification questions.

You can find all the info about this exam here.

1. Which of the following data structures typically contain normalized data?
A. Cube
B. Flat file
C. Operational
D. Star schema
Answer: C

2. What does a star schema database structure typically consist of?
A. De-normalized hierarchy of dimension tables and fact tables.
B. Normalized dimension tables and detailed fact tables.
C. Normalized dimension tables and summarized fact tables.
D. De-normalized dimension tables and fact tables.
Answer: D

3. Which of the following is true of an OLAP data structure?
A. Comprised of normalized dimension and fact tables.
B. Organizes dimension tables into hierarchies and levels.
C. Allows "real time" analysis against disparate data sources.
D. Cardinality between tables is typically configured as inner joins.
Answer: B

4. In Cognos 8, what are the two distinct model types authors can work with?
A. OLAP and DMR
B. Dimensional and DMR
C. Relational and SAP BW
D. Relational and Dimensional
Answer: D

5.Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
A. model
B. query item
C. namespace
D. query subject
Answer: C

6. What question should a data modeler answer before accepting this proposed operational data structure?
A. Should all three tables be consolidated into one?
B. Should the cardinalities between the tables be reversed?
C. Are Branch and Employee dimension tables or fact tables?
D. Is there a direct relationship between Branch and Employee?
Answer: D

7. Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
A. model
B. query item
C. namespace
D. query subject
Answer: C

8. Which of the following is true regarding the operational data structure illustrated below?
A. It illustrates a parallel relationship.
B. It should be consolidated into one table.
C. It should be examined for a connection trap.
D. The cardinality between the tables should be reversed.
Answer: C

9. In a transitive relationship scenario, what problems exist when reporting from the tables below?
A. The Order table must be included in each query.
B. The Order Detail table has conflicting cardinalities.
C. Outer joins are generated when querying from Customer.
D. There is more than one possible path between the tables.
Answer: D

10. A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them. How can the existing recursive
relationship in the model be modified to provide this ability to report authors?
A. Import a query subject that does not contain a recursive relationship.
B. Create a star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
C. Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available to report authors.
D. Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.
Answer: C

11. Which of the following are proven practices for organizing the objects in a project?
A. When importing metadata from more than one data source, include all imported objects in the root namespace.
B. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
C. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
D. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.
Answer: C

12. When a modeler imports metadata into Framework Manager, the Usage property for a nonindexed, numeric query item is set to which of the following?
A. Fact
B. Attribute
C. Identifier
D. Unknown
Answer: A

I will add more questions, as and when find them...