BI0-132 by COGNOS Actual Free Exam Questions And Answers

Question 1

What does a star schema database structure typically consist of?

A. De-normalized hierarchy of dimension tables and fact tables.

B. De-normalized dimension tables and fact tables.

C. Normalized dimension tables and summarized fact tables.

D. Normalized dimension tables and detailed fact tables.

Discussion 0

Correct Answer: B Vote an answer

Question 2

In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

A. For a query item having an integer data type, set the Display Item Reference property to display an integer value.

B. Add performance indicators to functions.

C. Create stand-alone filters.

D. Configure data sources in a project pointing to the same database instance to use the same connection.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which of the following is correct regarding the Cognos 8 security environment?

A. To perform authentication of users, a connection to theCognos namespace must be defined.

B. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.

C. Cognos 8 must be configured to use only one authentication provider at a time.

D. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.

Discussion 0

Correct Answer: D Vote an answer

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.

Discussion 0

Correct Answer: B Vote an answer

Question 5

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

A. Unwanted query splits (full outer joins).

B. Multiple ambiguous joins between two query subjects.

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

D. One query subject with several relationships.

Discussion 0

Correct Answer: B Vote an answer

Question 6

Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

A. Combine facts and dimensions for intuitive ad hoc business views.

B. Resolve reporting traps and simplify snowflake tables through consolidation.

C. Resolve conflicting keys and indexes and generate minimized SQL.

D. Provide dimensional information through the use of determinants.

Discussion 0

Correct Answer: B Vote an answer

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

Contact Us

Useful Links

Latest Updated