Free IBM C2020-632 Exam Dumps Questions & Answers

What is true of a Framework Manager model of an operational database lacking a time dimension?

• A.Report authors cannot create multi-fact, time-based queries unless using a union.
• B.Virtual star schema models require a time dimension for multi-fact queries.
• C.Report authors cannot create multi-fact, time-based queries.
• D.Time-based rollups for multi-fact queries may be difficult to handle.

To create a report in Report Studio, a report author accesses which object?

• A.A development model from Framework Manager.
• B.The runtime version of a Framework Manager model.
• C.A file that contains query subjects externalized from Framework Manager.
• D.A report specification.

Which of the following components does a basic Cognos 10 stitch query consist of?

• A.Coalesce function, full outer join, multiple queries that each query exclusive information.
• B.SC() function, full outer join, multiple queries that query some of the same information.
• C.Coalesce function, full outer join, multiple queries that query some of the same information.
• D.SC() function, full outer join, multiple queries that each query exclusive information.

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

• A.Identify a time dimension table source, import into the model and create relationships to fact query subjects.
• B.Create relationships from date fields in one dimension to date fields in another dimension.
• C.Use parameter maps to map date values in one query subject to date values in another query subject.
• D.Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.

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.Define both Month and Day determinant levels in the Time Dimension and Group By Month.
• C.Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.
• D.Define both Month and Day determinant levels in the Time Dimension and Group By Day.