IBM Cognos 10 BI Data Warehouse Developer

1.

In the Dimension Build wizard, the developer has specified the schema type as Star schema. What will be the result of this selection?

The dimension will be represented in a single table. Each level of the delivered hierarchy will be represented by one or more columns of this table. The dimension will be represented in a table that contains only the keys of all the levels of the deliveredhierarchy. The descriptions of the higher levels will reside in other tables. The dimension will be represented by one table for each hierarchy level. Each table will have a foreignkey to the level above. The dimension will be represented in a single table. Each row of this table will contain the ID of themember, together with the ID of its parent.

2.

What is depicted below?

How the elements of the transformation model will be output to the columns of a dimension table. How the columns of the data source map to the elements of the transformation model. How the items in the DataStream will be output to the columns of a fact table. How the elements of the transformation model will be output to the columns of a fact table. How the items in the DataStream will be output to the columns of a dimension table.

3.

A developer just wants to deliver dimension data to a table in a data mart. The dimensional framework has already been built. What should the developer create?

Dimension build JobStream Metadata dimension Fact build

4.

What is a difference between a measure element and an attribute element?

Attribute values can be aggregated by Data Manager, while measure values cannot. Measure values can be merged by Data Manager, while attribute values cannot. Attribute values can be merged by Data Manager, while measure values cannot. Measure values can be aggregated by Data Manager, while attribute values cannot.

5.

Which of the following is a use for a fact build?

To deliver fact data into a dimensional framework. To acquire and transform transactional data. To automate tasks related to the build process. To deliver fact data into a metadata star.

6.

Which of the following tasks can be completed with the Dimension Build wizard?

Adding a custom schema to use for the dimension tables. Specifying the folder in which the dimension build will be stored. Specifying surrogates and change tracking behaviors. Creating a connection to hold the dimension tables.

7.

Which of the following is true of packages in Data Manager?

User-defined folders cannot be exported. During importing, duplicate components are automatically renamed. User-defined folders cannot be imported. During importing, dependent components are automatically selected.

8.

End users must be able to create Cognos 8 reports using data from the data warehouse. To facilitate this, what can the developer do from within Data Manager?

Run the Create Framework Manager Model wizard to create a project. Create a Cognos 8 package in the Library area of the catalog. Export the Data Manager metadata to XML for use in Framework Manager. Publish a Cognos 8 package in the Metadata area of the catalog.

9.

A developer wants to create a connection to a published Framework Manager package in a Data Manager catalog. Before this connection can be created successfully, what must the developer do?

Add an LDAP or NTLM namespace in Cognos Configuration. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs. Log on to Cognos Connection as a user in the Data Manager Authors role. Create a data source connection to the Cognos 8 data store.

10.

A developer wants to move a selection of components from a development environment to a production environment. What should the developer do?

Create a catalog backup file (.ctg). Create a JobStream to transfer the components.. Create a package file (.pkg). Create a SQL script to transfer the components.

IBM Cognos 10 BI Data Warehouse 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 Data Warehouse 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