IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which statement is true about the Web Services Pack?

A. Web Services Pack generates a WSDL. B. Web Services Pack communicates by Enterprise Java Beans. C. Web Services Pack is configured from within the Information Services Director application. D. Web Services Pack makes a service request using SOAP.

Discussion 0

Correct Answer: D Vote an answer

Question 2

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. Using the advanced find dialog, specify in the last modified panel. the date range of the jobs and appropriate user name. B. Select a folder in your repository tree, right click and choose "Objects that I last modified". C. Use Multiple Job Compile to locate objects that need to be compiled. D. Sort the jobs by timestamp.

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

Where are project level message handlers defined?

A. Director Client B. Designer Client C. DSENV D. Administrator Client

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which three environment variables are used for reporting on DataStage jobs? (Select three)

A. $APT_DISABLE_ROOT_FORKJOIN B. $APT_PM_STARTUP_CONCURRENCY C. $APT_PM_PLAYER_MEMORY D. $APT_DUMP_SCORE E. $OSH_PRINT_SCHEMAS

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 5

You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?

A. Use Join stage, hash-partition and sort both link on OrderID. B. Use Lookup stage, select auto partitioning for the stream link and hash-partition the reference link on CustI C. Use Lookup stage, select auto partitioning for both link. D. Use Lookup stage, select auto partitioning for the stream link and entire partitioning for the reference link.

Discussion 0

Correct Answer: D Vote an answer

Question 6

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

A. String input column mapped to integer output column. B. Date input column mapped to a string output column. C. Integer input column mapped to raw output column. D. Integer input column mapped to string output column. E. String input column mapped to a data output column.

Discussion 0

Correct Answer: D,E Vote an answer

Question 7

Click the Exhibit button.

These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning strategy for each link?

A. For LinkA Hash Partition on CustID;
For LinkB Hash Partition on CustID;
For LinkC Same Partition;
For LinkD Hash Partition on CustID. B. For LinkA Hash Partition on CustID and OrderID; For LinkB Hash Partition on CustID and OrderID; For LinkC Hash Partition on CustID and LocationID; For LinkD Hash Partition on CustID and LocationID. C. For LinkA Hash Partition on CustID, OrderID and LocationID; For LinkB Hash Partition on CustID, OrderID and LocationID; For LinkC Hash Partition on CustID, OrderID and LocationID; For LinkD Hash Partition on CustID, OrderID and LocationI D. For LinkA Hash Partition on OrderID and CustID; For LinkB Hash Partition on OrderID and CustID; For LinkC Hash Partition on LocationID and CustID; For LinkD Hash Partition on LocationID and CustID.

Discussion 0

Correct Answer: A Vote an answer

Question 8

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 9

Which Oracle Enterprise stage read property can be set using -dboptions to tune job performance?

A. transactsize B. arraysize C. partitionsize D. memsize

Discussion 0

Correct Answer: B Vote an answer

Question 10

Which two statements are true about the use of named node pools? (Choose two.)

A. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools. B. Clustered environments must have named node pools for data processing. C. Using appropriately named node pools forces DataStage to use named pipes between stages. D. Named node pools can allow separation of buffering from sorting disks.

Discussion 0

Correct Answer: A,D Vote an answer

Question 11

You are describing to your customer how to work with packages. There are two steps that must be carried out in order to move the package to a target project. Which two steps must be carried out to move the DataStage objects to the Production system? (Choose two.)

A. Deploy B. Compile C. Package D. Export E. Build

Discussion 0

Correct Answer: A,E Vote an answer

Question 12

You are asked by management to document all jobs written to make future maintenance easier. Which two statements are true about annotations? (Choose two.)

A. The Description Annotation stage contains both the short and full descriptions for the job. B. The background for the Description Annotation stage can be changed for each unique stage. C. The Description Annotation stage can be added several times at different locations to identify business logic. D. The full job description can be identified within the Description Annotation stage.

Discussion 0

Correct Answer: A,D Vote an answer

Question 13

In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output column. What two techniques can be used to handle NULL values? (Choose two.)

A. IF IsNULL(input_column) THEN 'unknown' ELSE input_column. B. IF input_column = NULL THEN 'unknown' ELSE input_column. C. NullToValue(input_column, 'unknown'). D. IF input_column = '' THEN 'unknown' ELSE input_column.

Discussion 0

Correct Answer: A,C Vote an answer