IBM A2090-303 Actual Free Exam Questions & Community Discussion

You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?

When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What message handler level is available?

What role must a user have to delete shared metadata assets from the repository?

When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?

What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

The data going into the target Sequential Files stage is range-partitioned and sorted. Which technique method would be the most efficient to create a globally sorted target sequential file?

Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)

You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.

Which change will reduce the cost of partitioning that occurs in this job?