Free IBM COG-625 Exam Dumps Questions & Answers

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

• A.  Create a package file (.pkg).
• B.  Create a SQL script to transfer the components.
• C.  Create a JobStream to transfer the components..
• D.  Create a catalog backup file (.ctg).

A developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?

• A.  Member determinant
• B.  Lookup
• C.  Dimensional determinant
• D.  Identifier

Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?

• A.  Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
• B.  Modify the SQL for the reference structure to exclude the missing product codes.
• C.  Accept unmatched member identifiers in the measure element properties.
• D.  Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.

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

• A.  A derivation has been added to the lookup.
• B.  The lookup attribute names are different from the source column names.
• C.  Data must be accessed from more than one table.
• D.  The build will perform automatic surrogate key substitution.

A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?

• A.  User-defined functions
• B.  Output filters
• C.  Level filters
• D.  Derivations