COG-632 by IBM Valid Free Exam Practice Test

Question 1

In a transitive relationship scenario, what problems exist when reporting from the tables below?

A. The Order Detail table has conflicting cardinalities. B. The priority path must be defined. C. The Order table must be included in each query. D. There is more than one possible path between the tables.

Correct Answer: D

Question 2

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 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. 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 star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject. D. Import a query subject that does not contain a recursive relationship.

Correct Answer: B

Question 3

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

A. Create star schema groupings for dimension and fact query subjects. B. Create shortcuts to regular dimensions and fact query subjects. C. Create relationships between regular dimensions and measure dimensions. D. Create regular and measure dimensions and set scope.

Correct Answer: D

Question 4

Which of the following join types does the generated SQL below illustrate?

A. Cross join B. Disjointed join C. Outer join D. Inner join

Correct Answer: A

Question 5

In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?

A. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package. B. Import the stored procedure, add it as a model calculation, and then publish it as part of a package. C. Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package. D. Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package.

Correct Answer: A

Question 6

Which column is most likely a non-conformed or non-shared dimension from the SQL below?

A. D2.DAY_DATE B. D2.ORDER_METHOD C. D3.RETURN_QUANTITY D. D3.REASON_DESCRIPTION

Correct Answer: D

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