IBM InfoSphere DataStage v8.5 - 000-421 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a single existing table on a remote database. You are using Run-Time Column Propagation (RCP) on all of the links.
Which two job design configuration actions would you consider to effectively use RCP? (Select two)

A. In the DB2 Enterprise stage set the option named "Silently Drop Columns Not in Table" to "True". B. In the DB2 Enterprise stage use Connection properties to manage column mappings. C. Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in the table. D. Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions.

Discussion 0

Correct Answer: A,D Vote an answer

Question 2

A customer is complaining of poor performance from the job shown in the exhibit, which aggregates and joins on ZIP code. Currently all partitioning is set to "Auto" and sort/partition insertion is allowed.

What would give the best performance improvement for the job?

A. Hash partition and sort on ZIP code prior to the Copy stage and use entire partitioning on the output of the Aggregator stage. B. Hash partition and sort on ZIP code on the input links to the Aggregator and Join stages. C. Hash partition and sort on ZIP code prior to the Copy stage, and use same partitioning on the Aggregator and Join stages. D. Use same partitioning on all input links in the job; create the input data set by hash-partitioning its input on ZIP code.

Discussion 0

Correct Answer: C Vote an answer

Question 3

When you configure a domain for source code integration a source control workspace is created. What are two reasons for the source control workspace? (Choose two.)

A. directory for deployment package files B. default directory for istool exports. C. local transfer area for assets being submitted to the source control system D. provides a place to store the archive created by IS source code control integration

Discussion 0

Correct Answer: C,D Vote an answer

Question 4

How must the input data set be organized for input into the join stage? (Choose two.)

A. Key partitioned B. Hash partitioned C. Sorted in ascending order D. Unsorted E. Entire partitioned

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

Records in a source file must be copied to multiple output streams for further processing. Which two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose two.)

A. Directing selected output records down one output link rather than another. B. Renaming one or more output columns. C. Converting some input columns from integers to strings. D. Concatenating data from multiple input columns.

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

Which three statements are true about File Sets? (Choose three.)

A. File sets have a proprietary data format which may change in future DataStage versions. B. File sets are readable by external applications. C. File sets always execute in parallel. D. File sets are partitioned. E. File sets are stored as header file and data files.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 7

A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)

A. Set $APT_READ_MULTI_NODES to TRUE. B. Set partitioning method to Same. C. Specify Multiple readers per node. D. Ensure data has unique identifiers for data rows.

Discussion 0

Correct Answer: C,D Vote an answer

Question 8

You are setting up the parallel engine configuration file. Which two statements are true about file system efficiency? (Select two)

A. In a clustered environment where NAS is used for a common storage, specify the internal disk for scratch disk. B. Specify a directory for the resource disk in the partition where the engine is installed. C. Creating scratch disk space on an internal disk improves sort performance than NFS drive. D. Using multiple scratch spaces in a logical node improves performance.

Discussion 0

Correct Answer: A,B Vote an answer