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

A. The model can be verified from Cognos Connection or through the Publish Packages wizard.

B. The model can only be verified through the Publish Packages wizard.

C. It is possible to select to automatically repair certain issues that have been detected.

D. The entire model must be verified, individual objects cannot be verified.

A. Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.

B. Segment a project at the level of an individual query subject.

C. Copy all segmented model files into one common folder before using Framework Manger's model merge feature.

D. Define the repository type and path to the repository in Cognos Connection.

A. For a query item having an integer data type, set the Display Item Reference property to display an integer value.

B. Add performance indicators to functions.

C. Create stand-alone filters.

D. Configure data sources in a project pointing to the same database instance to use the same connection.

A. The runtime version of a Framework Manager model.

B. A development model from Framework Manager.

C. A file that contains query subjects externalized from Framework Manager.

D. A report specification.

A. To provide authors with access to all columns in a databasetable which reduces requests to the modeler?

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

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

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

A. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.

B. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.

C. The derived table is executed independently, using Pass-Through SQL, and then processed locally.

D. The parent select statement uses an inner join to directly match columns from physical tables in the database.