COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:

1. In Framework Manager, which of the following is a correct technique for model segmentation?

A) Copy all segmented model files into one common folder before using Framework Manger's model merge feature.
B) Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
C) Define the repository type and path to the repository inCognos Connection.
D) Segment a project at the level of an individual query subject.

2. In Framework Manager, which of the following is true about verifying your model?

A) The model can be verified fromCognos Connection or through the Publish Packages wizard.
B) The model can only be verified through the Publish Packages wizard.
C) It is possible to select to automatically repair certain issues that have been detected.
D) The entire model must be verified, individual objects cannot be verified.

3. In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?

A) Level MUN
B) Level identifier
C) Member MUNs
D) Member aliases

4. In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?

A) Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package.
B) Import the stored procedure, add it as a model calculation, and then publish it as part of a package.
C) Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
D) Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.

5. What question should a data modeler answer before accepting this proposed operational data structure?

A) Is there a direct relationship between Branch and Employee?
B) Are Branch and Employee dimension tables or fact tables?
C) Should the cardinalities between the tables be reversed?
D) Should all three tables be consolidated into one?

Solutions: