COG-625 by IBM Actual Free Exam Questions And Answers

Question 1

Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choosetwo)

A. To add an attribute to a hierarchy level.

B. To add a measure element to the hierarchy.

C. To add a level to the hierarchy.

D. To specify a fact build for the hierarchy.

E. To specify a metadata dimension for the hierarchy.

F. To add a derived dimension element to the hierarchy.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

A developer has created a fact build to process the incoming data shown in the table:

The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?

A. 1500

B. 500

C. 1200

D. 1100

Discussion 0

Correct Answer: C Vote an answer

Question 3

Where can a developer define variables in Data Manager?

A. Connections

B. JobStreams

C. Metadata dimensions

D. Metadata collections

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which element does Data Manager use to identify duplicate rows?

A. Measure

B. Attribute

C. Index

D. Dimension

Discussion 0

Correct Answer: D Vote an answer

Question 5

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?

A. Add an LDAP or NTLM namespace in Cognos Configuration.

B. Log on to Cognos Connection as a user in the Data Manager Authors role.

C. Create a data source connection to the Cognos 8 data store.

D. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.

Discussion 0

Correct Answer: D Vote an answer

Question 6

A dimension table tracks employee data. If an employee's work location changes, the previous work location needs to be kept and a new record needs to be created. What kind of change is this?

A. Type 1

B. Type 2

C. Type 3

D. Type 0

Discussion 0

Correct Answer: B Vote an answer

Question 7

What is depicted below?

A. How the columns of the data source map to the elements of the transformation model.

B. How the elements of the transformation model will be output to the columns of a dimension table.

C. How the items in the DataStream will be output to the columns of a fact table.

D. How the elements of the transformation model will be output to the columns of a fact table.

E. How the items in the DataStream will be output to the columns of a dimension table.

Discussion 0

Correct Answer: A Vote an answer

Question 8

A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?

A. The build will perform automatic surrogate key substitution.

B. Data must be accessed from more than one table.

C. The lookup attribute names are different from the source column names.

D. A derivation has been added to the lookup.

Discussion 0

Correct Answer: A Vote an answer

Question 9

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?

A. Dimension build

B. Fact build

C. Metadata dimension

D. JobStream

Discussion 0

Correct Answer: A Vote an answer

IBM Cognos 10 BI Data Warehouse Developer - COG-625 Exam Practice Test

Contact Us

Useful Links

Latest Updated