Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test

Question 1

A job validates credit card numbers with a reference file using a Join stage, which is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

A. Alter the number of partitions in the $APT_CONFIG_FILE.

B. Use Round Robin partitioning on the stream and Entire partitioning on the reference.

C. Break the input file into multiple files.

D. Replace the Join with a Merge stage.

Correct Answer: A

Question 2

How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

A. The related elements are output as subrecords.

B. CFF does not support this clause.

C. The related elements are output as denormalized fields.

D. The related elements are output as arrays.

Correct Answer: D

Question 3

The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

A. Aggregates and most arithmetic operators in the SELECT statement are allowed.

B. Multiple-AMP requests are allowed.

C. Non-data access (e.g., pseudo-tables like DATE or USER) is allowed.

D. The use of the USING modifier is allowed.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Which two statements are accurate regarding usage of database stages? (Choose two.)

A. Plug-in stages match columns by name.

B. Database stages cannot create tables and must be done externally.

C. DataStage provides native Oracle database stages.

D. Native database stages match columns by name.

Correct Answer: C,D

Question 5

You are setting up user roles on Information Server Web console. Which two roles are required to allow a user to edit DataStage jobs? (Select two)

A. DataStage super operator

B. Information Analyzer Data Administrator

C. Suite User role

D. DataStage Developer

Correct Answer: A,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

In a Transformer, which two of the following mappings can be handled by default type conversions. (Select two)

A. Date input column mapped to a string output column.

B. Integer input column mapped to string output column.

C. String input column mapped to integer output column.

D. String input column mapped to a data output column.

E. Integer input column mapped to raw output column.

Correct Answer: B,D

Question 7

You have finished changes to many Jobs and Shared containers. You must export all of your changes and integrate them into a test project with other objects. What are two ways to select the objects you changed for the export? (Select two)

A. Use Multiple Job Compile to locate objects that need to be compiled.

B. Select a folder in your repository tree, right click and choose "Objects that I last modified".

C. Using the advanced find dialog, specify in the last modified panel. the date range of the jobs and appropriate user name.

D. Sort the jobs by timestamp.

Correct Answer: B,C

Question 8

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. provides a place to store the archive created by IS source code control integration

B. default directory for istool exports.

C. local transfer area for assets being submitted to the source control system

D. directory for deployment package files

Correct Answer: A,C

Question 9

Which two statements are true about DataStage Parallel Build stages? (Choose two.)

A. Build stages can only be used in a job that has Runtime Column Propagation (RCP) enabled.

B. The Build stage generates a C/C++ source file that is compiled and linked outside of DataStage.

C. On the Logic Post-Loop, you specify code that runs after all input records have been processed.

D. The Build stage can be programmed to read and write automatically or code can be written to manually read and write rows.

Correct Answer: C,D

Question 10

Your job runs slowly and does not scale beyond two nodes. It appears the data has been partitioned on the DoNotCall flag, which has accumulating totals based on this flag using a sort method.
Which technique would improve scalability and performance?

A. Change the preserve partitioning option on the stage ahead of the aggregator to clear partitioning.

B. Increase the number of physical nodes available for partitioning.

C. Change the partitioning method to Round Robin; add a second Aggregator stage with Execution mode 'Sequential' and

D. Add an additional column for partitioning to result in additional data partitions.

Correct Answer: B,D

Question 11

What are two ways to specify a stylesheet in an XML input stage? (Choose two.)

A. On the output link columns properties tab, type the stylesheet in the XLST box.

B. On the output link columns properties tab, identify an input column that contains the stylesheet URL.

C. On the output link advanced properties tab, type the stylesheet in the Stylesheet box.

D. On the output link advanced properties tab, load the content or path of a stylesheet that is stored on the engine tier host.

Correct Answer: C,D

Question 12

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

A. You can define multiple scratch disk spaces to distribute disk I/O.

B. The parallel framework uses the disk space specified in the scratch disk setting to buffer virtual data set records.

C. If "buffer" scratch disk pool is defined, the framework uses this disk pool and the default disk pool.

D. The Sort stage always uses the scratch disk.

Correct Answer: A,B

Question 13

Which two job design techniques can be used to provide unique names to sequential output files that are used in multi-instance jobs? (Select two)

A. Use the file name(s) from values contained in the data stream.

B. Prepend/append the Invocation ID to the file name.

C. Create the file name(s) from values contained in a value file.

D. Use parameters to identify file names.

Correct Answer: B,D

Question 14

Which two data repositories can you use for user authentication within the Information Server Suite? (Choose two.)

A. the IBM Information Server user directory

B. the local operating system directory

C. the IBM Suite User Configuration file specified within the dsenv file

D. the IBM Metadata repository

Correct Answer: A,B

IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test

Latest Update

Useful Links

Contact Us