IBM C2020-632 - IBM Cognos 10 BI Metadata Model Developer Exam
Page: 2 / 10
Total 50 questions
Question #6 (Topic: )
What must a modeler consider when modeling for drill-through between multiple
datasources?
datasources?
A. Drill-through values must be cast.
B. Drill-through values must be conformed.
C. Drill-through values must be consolidated.
D. Drill-through values must be identifiers.
Answer: B
Question #7 (Topic: )
A recursive relationship exists betweenSALES_STAFF_CODE and MANAGER_CODE in
the SALES_STAFF data source query subject. This query subject is provided in a model to
report authors. Using this query subject alone, report authors cannot create a report that
includes management staff and the salesstaff that report to them. How can the existing
recursive relationship in the model be modified to provide this ability to report authors?
the SALES_STAFF data source query subject. This query subject is provided in a model to
report authors. Using this query subject alone, report authors cannot create a report that
includes management staff and the salesstaff that report to them. How can the existing
recursive relationship in the model be modified to provide this ability to report authors?
A. Import a query subject that does not contain a recursive relationship.
B. Create a star schema grouping thatcontains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
C. Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both availableto report authors.
D. Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.
Answer: C
Question #8 (Topic: )
A user-defined function imported into Framework Manager can be viewed and used in the
following locations?
following locations?
A. Viewed in the Explorer and used in the expression editor.
B. Viewed in the Project Viewer and used in the expression editor.
C. Viewed in the Explorer and used in the SQL of a model query subject.
D. Viewed in the Diagram and used in the SQL of a data source query subject.
Answer: A
Question #9 (Topic: )
In Framework Manager, if a modeler changes the business key for a level in a regular
dimension, which of the following may change?
dimension, which of the following may change?
A. Level MUN
B. Level identifier
C. Member MUNs
D. Member aliases
Answer: C
Question #10 (Topic: )
What is true of a Framework Manager model of an operational database lacking a time
dimension?
dimension?
A. Virtual star schema models require a time dimensionfor multi-fact queries.
B. Report authors cannot create multi-fact, time-based queries.
C. Time-based rollups for multi-fact queries may be difficult to handle.
D. Report authors cannot create multi-fact, time-based queries unless using a union.
Answer: C
