Free IBM C2090-625 Exam Dumps Questions & Answers

Which of the following can a developer do with SQLTXT Designer?

• A.  Specify sort order for the flat file.
• B.  Select data from multiple text files using joins.
• C.  Select data from multiple tables using joins.
• D.  Specify row and column delimiters.

How can a developer nest a JobStream within another JobStream?

• A.  Add a JobStream node to the JobStream.
• B.  Execute the first JobStream using the Data Movement Service, and include the second JobStream in the resulting task.
• C.  Execute the first JobStream from the command line, and reference the second JobStream in the command.
• D.  Add a procedure node to the JobStream.

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 JobStream to transfer the components..
• B.  Create a SQL script to transfer the components.
• C.  Create a package file (.pkg).
• D.  Create a catalog backup file (.ctg).

A developer has created a date hierarchy using the Date Hierarchy wizard. Which of the following is true of all the members in this hierarchy?

• A.  All are static and are physically stored in the catalog.
• B.  All are retrieved from a flat file using SQL.
• C.  All are retrieved from a database table using SQL.
• D.  All are dynamic and are physically stored in the catalog.

A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). What should be done?

• A.  Create a measure dimension which references the conversion rate.
• B.  Reference the lookup in the properties of the affected dimension build(s).
• C.  Create a derivation which uses the reference atttributes of the lookup.
• D.  Move the lookup to a fact build conversion map.