IBM Cognos 10 BI Metadata Model Developer

Here you have the best IBM C2090-632 practice exam questions

You have 53 total questions to study from
Each page has 5 questions, making a total of 11 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on January 5, 2026
This site is not affiliated with or endorsed by IBM.

Question 1 of 53

In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?

To generate the most efficient SQL at run time and simplify model maintenance.

To prevent the exclusion of columns from a table that may be required in future reports.

To prevent improperly constructed SQL and reduce issues with model documentation and readability.

To provide authors with access to all columns in a database table which reduces requests to the modeler.

Correct Answer: A

Question 2 of 53

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

Open the Relationship Definition Dialog, and then edit the join expression as required.

Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".

Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.

Right-click a relationship in the Object diagram or Context Explorer and then select "Create Compound Join".

Correct Answer: A

Question 3 of 53

In Cognos 10, which of the following is true of multi-fact results sets?

Only correlated result sets can have repeating fact values.

Only contiguous result can have repeating fact values.

Both contiguous and correlated lists can have repeating fact values.

Both contiguous and correlated lists cannot have repeating fact values.

Correct Answer: C

Question 4 of 53

Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

Resolve conflicting keys and indexes and generate minimized SQL.

Combine facts and dimensions for intuitive ad hoc business views.

Resolve reporting traps and simplify snowflake tables through consolidation.

Provide dimensional information through the use of determinants.

Correct Answer: C

Question 5 of 53

Which of the following join types does the generated SQL below illustrate? select
✑ Manager.Manager as Manager,
✑ Product.Product as Product
from
✑ datasource_name.database_name.schema.Manager Manager
✑ datasource_name.database_name.schema.Product Product

Inner join

Disjointed join

Outer join

Cross join

Correct Answer: D