IBM Cognos 10 BI Metadata Model Developer - C2020-632 Exam Practice Test

Question 1

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

A. Specifying the usage property for generated query items.

B. Generating relationships based on existing primary and foreign key relationships in the database.

C. Converting inner joins in the database to outer joins in the model.

D. Specifying the item names in various languages.

Correct Answer: B

Question 2

Which of the following is true regarding the operational data structure illustrated below?

A. It should be consolidated into one table.

B. It illustrates a parallel relationship.

C. It should be examined for a connection trap.

D. The cardinality between the tables should be reversed.

Correct Answer: C

Question 3

The database table below would typically be found in what data structure?

A. Cartesan

B. Star schema

C. Operational

D. Normalized

Correct Answer: B

Question 4

A recursive relationship exists between SALES_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 sales staff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?

A. Create a star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.

B. Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available to report authors.

C. 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.

D. Import a query subject that does not contain a recursive relationship.

Correct Answer: B

Question 5

What must a modeler consider when modeling for drill-through between multiple data sources?

A. Drill-through values must be consolidated.

B. Drill-through values must be identifiers.

C. Drill-through values must be cast.

D. Drill-through values must be conformed.

Correct Answer: D

Question 6

The generated Cognos SQL below contains which one of the following joins?

A. Left inner join on RETURN_REASON_KEY.

B. Inner join on RETURN_REASON_KEY.

C. Outer join on RETURN_REASON_KEY.

D. Left outer join on RETURN_REASON_KEY.

Correct Answer: B

IBM Cognos 10 BI Metadata Model Developer - C2020-632 Exam Practice Test

Latest Update

Useful Links

Contact Us