IBM C2090-421 Actual Tests : InfoSphere DataStage v8.5

IBM C2090-421 Exam Syllabus Topics:

IBM InfoSphere DataStage v8.5 Sample Questions:

1. Which two statements are true about the usage of scratch disk? (Choose two.)

A) The Sort stage always uses the scratch disk.
B) The parallel framework uses the disk space specified in the scratch disk setting to buffer virtual data set records.
C) You can define multiple scratch disk spaces to distribute disk I/O.
D) If "buffer" scratch disk pool is defined, the framework uses this disk pool and the default disk pool.

2. A 100MB input dataset has even distribution across 400 unique key values.
When run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Select two)

A) Set $APT_TSORT_STRESS_BLOCKSIZE to 50M
B) Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
C) Alter the Sort stage properties to perform a stable sort.
D) Convert all numeric fields to varchars.
E) Specify Round Robin partitioning on the input link to the Sort stage.

3. In which two operations can you create DataStage projects? (Choose two.)

A) During DataStage installation.
B) When exporting and importing a DataStage project from DataStage Director.
C) When creating a project in the IBM Information Server Console.
D) When adding new projects from DataStage Administrator.

4. You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)

A) Type
B) Where used
C) Dependent upon
D) Include Read only objects

5. You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?

A) Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.
B) Select the shared container, Right-click on the Where used command.
C) Select the shared container, Right-click on the Dependencies (deep) command.
D) Select the shared container, Right-click on the Where used (deep) command.

Solutions: