Free IBM C2020-632 Exam Dumps Questions & Answers

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.

The Cognos 10 report below contains two conformed dimensions, Time Dimension and Product Dimension, and one non-conformed dimension, Order Method.

Which of the following best describes the results?

• A.  Correlated list
• B.  Multi-fact split
• C.  Cross join
• D.  Contiguous result set

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

• A.  Create regular and measure dimensions and set scope.
• B.  Create star schema groupings for dimension and fact query subjects.
• C.  Create relationships between regular dimensions and measure dimensions.
• D.  Create shortcuts to regular dimensions and fact query subjects.

After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings?

• A.  Semi-Aggregate
• B.  Usage
• C.  Aggregate
• D.  Data Type

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

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