A2090-303試験無料問題集（134題）「IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment 認定」

出題：1

The Score is divided into which two sections? (Choose two.)

A. Stages

B. Schemas

C. File sets

D. Data sets

E. Operators

正解：D,E 解答を投票する

出題：2

Which statement is correct about the Data Rules stage?

A. When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).

B. If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.

C. The Data Rules stage works with rule definitions only; not executable rules.

D. As a best practice, you should create and publish new rules from the Data Rules stage.

正解：C 解答を投票する

出題：3

Which two statements are true about Data Sets? (Choose two.)

A. Data Sets require repartitioning.

B. Data sets contain ASCII data.

C. Data Sets preserve partitioning.

D. Data Sets represent persistent data.

E. Data Sets require import/export conversions.

正解：C,D 解答を投票する

出題：4

You are editing the configuration file. Which statement is true about file system efficiency?

A. Using multiple scratch spaces in a logical node improves performance.

B. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.

C. In a clustered environment where NAS is used for a common storage, you must specify the internal disk for scratch disk.

D. For the resource disk, it is best to use the partition where the engine is installed.

正解：B 解答を投票する

出題：5

Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?

A. VARCHAR, 32768 to SQL_VARCHAR

B. BIGINT to SQL_BIGINT (INT32)

C. XML to SQL_WVARCHAR

D. CHAR FOR BIT DATA to SQL_VARBINARY

正解：C 解答を投票する

出題：6

A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)

A. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.

B. Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.

C. Explicitly specify hash partitioning and sorting on each input to the Join stage.

D. Disable job monitoring.

E. Unset the Preserve Partitioning flag on the output of each parallel dataset.

正解：A,B 解答を投票する

出題：7

What stage allows for more than one reject link?

A. Lookup stage

B. Funnel stage

C. Merge stage

D. Join stage

正解：C 解答を投票する

A2090-303試験無料問題集「IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment 認定」