Free IBM COG-625 Exam Dumps Questions & Answers

A developer has created a fact build to process the incoming data shown in the table: The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?

• A.500
• B.700
• C.1200
• D.200

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.Specify the column as a key in the data source properties.
• B.Convert the attribute element into a derivation element.
• C.Convert the attribute element into a derived dimension element.
• D.Specify the column as a key in the table delivery properties.

When this JobStream is executed,

what is the maximum number of nodes that will run in parallel at any one time?

• A.3
• B.4
• C.7
• D.8

When delivering fact data to a text file, what can be specified?

• A.Line and field delimiters
• B.Maximum number of rows to be stored in the file
• C.Default text editor to use with the file
• D.Whether the file is in ASCII or EBCDIC format

A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

• A.Derived dimension
• B.Derivation
• C.User-defined function
• D.Measure
• E.Attribute