IBM Cognos 10 BI Metadata Model Developer - COG-632 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

In a transitive relationship scenario, what problems exist when reporting from the tables below?

A. There is more than one possible path between the tables. B. The priority path must be defined. C. The Order table must be included in each query. D. The Order Detail table has conflicting cardinalities.

Discussion 0

Correct Answer: A 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

When a modeler imports metadata into Framework Manager, the Usage property for a non-indexed, numeric query item is set to which of the following?

A. Fact B. Measure Dimension C. Attribute D. Identifier

Discussion 0

Correct Answer: A Vote an answer

Question 4

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. Resolve reporting traps and simplify snowflake tables through consolidation. B. Provide dimensional information through the use of determinants. C. Combine facts and dimensions for intuitive ad hoc business views. D. Resolve conflicting keys and indexes and generate minimized SQL.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which of the following is true of an OLAP data structure?

A. Comprised of normalized dimension and fact structures. B. Allows "real time" analysis against disparate data sources. C. Cardinality must be defined. D. Organizes dimension tables into hierarchies and levels.

Discussion 0

Correct Answer: D Vote an answer

Question 6

What does a star schema database structure typically consist of?

A. De-normalized dimension tables and fact tables. B. Normalized dimension tables and detailed fact tables. C. Normalized dimension tables and summarized fact tables. D. De-normalized hierarchy of dimension tables and fact tables.

Discussion 0

Correct Answer: A Vote an answer