Free IBM A2090-421 Practice Test & Real Exam Questions
The given job processes large volumes of data using default partitioning, with sort/partition insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming that the business logic allows all of the following actions, which design change would improve the performance of this job?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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?
Which technique would improve scalability and performance?
Correct Answer: B,C
Vote an answer
Which three DataStage elements allow you to create Shared MetaData? (Select three)
Correct Answer: A,C,D
Vote an answer
Which three statements are true about stage variables? (Select three)
Correct Answer: A,B,C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Which two partitioning methods require keys? (Choose two.)
Correct Answer: B,C
Vote an answer
The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?
Correct Answer: A
Vote an answer
Which two data repositories can you use for user authentication within the Information Server Suite? (Choose two.)
Correct Answer: B,D
Vote an answer
In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)
Correct Answer: B,D
Vote an answer
The number of File Set data files created depends upon what three items? (Choose three.)
Correct Answer: B,C,E
Vote an answer
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.)
Correct Answer: A,B
Vote an answer
Click on the Exhibit button.
Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?
Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?
Correct Answer: C
Vote an answer
What two features enable a job with a Sequential File stage to read from sequential files with different numbers of columns and types? (Select two)
Correct Answer: A,C
Vote an answer
Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)
Correct Answer: B,D,E
Vote an answer
