Free IBM COG-625 Exam Dumps Questions & Answers

A dimension table tracks employee data. If an employee's phone number changes, the old phone number does not need to be kept. What kind of change is this?

• A.  Type 2
• B.  Type 1
• C.  Type 2, non-standard
• D.  Type 3, non-standard

A developer wants to copy data from one table to a table in another database. What type of fact build would be the most appropriate for the developer to specify in the Fact Build wizard?

• A.  Data transfer
• B.  Relational datamart
• C.  Cognos BI Mart (Star)
• D.  Cognos BI Mart (Snowflake)

Incoming fact data includes an audit reference column for each row. This column has been identified as an attribute in the transformation model. When executed, the fact build should designate this element as a key in the resulting fact table. This fact table will be created (not updated) by the fact build. What should the developer do?

• A.  Convert the attribute element into a derived dimension element.
• B.  Specify the column as a key in the table delivery properties.
• C.  Convert the attribute element into a derivation element.
• D.  Specify the column as a key in the data source properties.

A JobStream has been created that, when executed, will write status messages to the log file that indicate whether nodes have completed or failed to run. What type of node should be added to the JobStream?

• A.  Alert
• B.  Email
• C.  Procedure
• D.  Condition

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

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