最新的IBM A2090-303免費考試真題

問題1

You would like to run a particular processing job within a job sequence for each weekday. What two methods could be used? (Choose two.)

A. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.

B. Add the job scheduler stage to the job sequence and set to weekdays only.

C. Call a routine in the job sequencer that starts the processing job for each day you would like to process.

D. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.

E. Set the frequency property in the job scheduler to weekdays only.

正確答案: A,C

問題2

Which Oracle data type conversion is correct?

A. Oracle data type NUMBER converts to DECIMAL(38,0) in Oracle Connector stage.

B. Oracle data type NUMBER(6,0) converts to INT32 in Oracle Connector stage.

C. Oracle data type RAW converts to RAW in Oracle Connector stage.

D. Oracle data type NUMBER(15,0) converts to INT32 in Oracle Connector stage.

正確答案: B

問題3

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. Explicitly specify hash partitioning and sorting on each input to the Join stage.

B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.

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

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

E. Disable job monitoring.

正確答案: B,C

問題4

Which stage classifies data rows from a single input into groups and computes totals?

A. Transformer stage

B. Aggregator stage

C. Compare stage

D. Modify stage

正確答案: B

問題5

Identify two items that are created as a result of running a Balanced Optimization on a job that accesses a Hadoop distributed file system as a source? (Choose two.)

A. A Balanced Optimization Shared Container is found in the project.

B. A JAQL stage is found in the optimized job result.

C. A Big Data File stage is found in the optimized job results.

D. A MapReduce Transformer stage is found in the optimized job result.

E. A Balanced Optimization parameter set is found in the project

正確答案: B,E

問題6

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 partitioning to hash.

C. Change the lookup option in the stage properties to "Sparse".

D. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

正確答案: C

問題7

Which two statements are true about stage variables in a Transformer Stage? (Choose two.)

A. A stage variable in one Transformer can refer to a stage variable in another Transformer, as long as the second Transformer was processed earlier in the job flow.

B. Varchar stage variables can be initialized with spaces.

C. Stage variables are refreshed with default values before each new input row is processed.

D. Stage variables cannot be set to NULL.

E. Stage variables can be set to NULL.

正確答案: B,E

問題8

What stage allows for more than one reject link?

A. Funnel stage

B. Lookup stage

C. Join stage

D. Merge stage

正確答案: D

最新的IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment - A2090-303免費考試真題

聯系我們

站內鏈接

最新更新