IBM InfoSphere DataStage v9.1 認定 C2090-303 試験問題:

1. A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?

A) 6
B) 8
C) 10
D) 12

2. Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

A) Sort the data on the reference link.
B) Change the lookup option in the stage properties to "Sparse".
C) Change the partitioning to hash.
D) Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

3. You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by a former developer of the project. How can you find these jobs?

A) Use Advanced Find feature in the Designer interface.
B) Sort the jobs by date in the Repository window.
C) Right-click on jobs folder in the Repository window and select Filter jobs.
D) Select the top project folder and choose Find Dependencies (deep).

4. Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)

A) $APT_STARTUP_STATUS
B) $APT_EXPORT_FLUSH_COUNT
C) $APT_IO_MAP
D) $OSH_EXPLAIN
E) $APT_PM_STARTUP_CONCURRENCY

5. A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?

A) 16
B) 8
C) 10
D) 12

質問と回答：