Free IBM C2020-632 Exam Dumps Questions & Answers

When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?

• A.  Generating relationships based on existing primary and foreign key relationships in the database.
• B.  Converting inner joins in the database to outer joins in the model.
• C.  Specifying the usage property for generated query items.
• D.  Specifying the item names in various languages.

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

The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

• A.  Query items.
• B.  Relationships.
• C.  Parameter maps.
• D.  Data sources.

Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table.

In Framework Manager, which technique will best prevent Sales Target values from being double-counted in Query Studio reports?

• A.  Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.
• B.  Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.
• C.  Define both Month and Day determinant levels in the Time Dimension and Group By Day.
• D.  Define both Month and Day determinant levels in the Time Dimension and Group By Month.

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

• A.  folder
• B.  namespace
• C.  model
• D.  query subject folder