Cognos 8 BI Metadata Model Developer - BI0-132 Exam Practice Test

Question 1

Which of the following are proven practices for organizing the objects in a project?

A. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.

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, include all imported objects in the root namespace.

D. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.

Correct Answer: D

Question 2

Which of the following is true for 0..n cardinality?

A. The cardinality is optional and a union will be performed.

B. The cardinality is optional and an outer join will be performed.

C. The cardinality is unknown and an inner join will be performed.

D. The cardinality is optional and an inner join will be performed.

Correct Answer: B

Question 3

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. 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.

B. 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.

C. 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.

D. Import a query subject that does not contain a recursive relationship.

Correct Answer: B

Question 4

Which of the following is true when applying object security in Framework Manager?

A. Child objects only inherit security from their parent if the Inherit property is set to Yes.

B. If beginning to apply security by specifying object security on an object with no children, all other objects will not be accessible to all users.

C. Allow overrides Deny if specified in the properties of the object.

D. If beginning to apply security by specifying object security on an object with no children, all other objects remain accessible to all users.

Correct Answer: B

Question 5

Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

A. query item

B. namespace

C. query subject

D. model

Correct Answer: B

Question 6

In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap?

A. Multiple ambiguous joins between two query subjects.

B. Queries that reference two facts with no conformed dimension.

C. Unwanted query splits (full outer joins).

D. One query subject with several relationships.

Correct Answer: A

COGNOS Cognos 8 BI Metadata Model Developer - BI0-132 Exam Practice Test

Latest Update

Useful Links

Contact Us