IBM Cognos 10 BI Metadata Model Developer

1.

In Framework Manager, which of the following statements is correct when working with a multi- lingual project?

The design language can be changed at any point. A project language cannot be deleted once defined in Framework Manager. A language must be added to the project before it can be published with a package. When a new language is added to a project, all locales for that language are added as well.

2.

To create a report in Report Studio, a report author accesses which object?

A report specification. A development model from Framework Manager. The runtime version of a Framework Manager model. A file that contains query subjects externalized from Framework Manager.

3.

Which of the following are proven practices for organizing the objects in a project?

When importing metadata from more than one data source, include all imported objects in the root namespace. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.

4.

Which of the following is true for 0..n cardinality?

The cardinality is optional and a union will be performed. The cardinality is optional and an inner join will be performed. The cardinality is optional and an outer join will be performed. The cardinality is required and an outer join will be performed.

5.

In Cognos 10, what are the two distinct model types authors can publish from Framework Manager?

OLAP and DMR Dimensional and DMR Relational and SAP BW Relational and Dimensional

6.

Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

model folder namespace query subject folder

7.

After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings?

Usage Aggregate Data Type Semi-Aggregate

8.

In Framework Manager, if a modeler tests the Month from Time Dimension and SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler most likely to see?

An XMIN on Month. An XSUM on Month. An XMIN on SALE_TOTAL. An XSUM on SALE_TOTAL.

9.

Which of the following is true of the generated native SQL below?

The derived table is executed independently, using Pass-Through SQL, and then processed locally. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set. The parent select statement uses an inner join to directly match columns from physical tables in the database. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.

10.

Which of the following components does a basic Cognos 10 stitch query consist of?

SC() function, full outer join, multiple queries that each query exclusive information. SC() function, full outer join, multiple queries that query some of the same information. Coalesce function, full outer join, multiple queries that each query exclusive information. Coalesce function, full outer join, multiple queries that query some of the same information.

IBM Cognos 10 BI Metadata Model Developer

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Cognos 10 BI Metadata Model Developer

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner