IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 21:

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

  A. WebSphere Repository

  B. Source Code Repository

  C. Universe Project Repository

  D. Information Analyzer Repository

  E. Information Server metadata Repository

  Correct Answer: BE

• Question 22:

  Which two commands start a DataStage job named procRows in a project named DSProject. It also passes the value 200 to the numRows parameter. (Choose two.)

  A. dsjob -run -paramfile numRows=200 DSProject procRows

  B. dsjob -run -mode normal -param numRows=200 DSProject procRows

  C. dsjob -run -mode validate -param numRows=200 DSProject procRows

  D. dsjob -run -mode normal -paramfile numRows=200 DSProject procRows

  E. dsjob -run -queue HighPriority -param numRows=200 DSProject procRows

  Correct Answer: BE

• Question 23:

  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?

  A. stage level

  B. record level

  C. project level

  D. parameter level

  Correct Answer: C

• Question 24:

  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?

  A. 2

  B. 3

  C. 4

  D. 5

  Correct Answer: B

• Question 25:

  You would like to run a particular processing job within a job sequence for each weekday. What two methods could be used? (Choose two.)

  A. Set the frequency property in the job scheduler to weekdays only.

  B. Add the job scheduler stage to the job sequence and set to weekdays only.

  C. Call a routine in the job sequencer that starts the processing job for each day you would like to process.

  D. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.

  E. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.

  Correct Answer: CE

• Question 26:

  Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?

  A. Job parameters should be used in Job Names.

  B. Hard code the Invocation ID to improve development process.

  C. Create a standard directory structure inside of the DataStage project directory for source and target files.

  D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.

  Correct Answer: D

• Question 27:

  What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)

  A. EJB

  B. SQL

  C. HDFS

  D. SOAP

  E. STREAMS

  Correct Answer: AD

• Question 28:

  A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a ISD output stage. How can the parameter values can be passed to this job at run-time?

  A. Include the parameter values in the data.

  B. Change the properties of the information provider.

  C. Pass the parameter values at the time of the service request.

  D. Execute a DSSetParam with the values at job execution time.

  Correct Answer: C

• Question 29:

  In your parallel job design you have selected a parallel shared container to be included. Which area of your job design is required to be configured to use the parallel shared container?

  A. List the jobs that will be allowed to use the container.

  B. Configure your job properties General tab "Allow Container" option to be True.

  C. Configure the job name reference the parallel shared container originates from.

  D. Configure the number of input and/or output links to support the parallel shared container.

  Correct Answer: D

• Question 30:

  Which statement is true about improving job performance when using Balanced Optimization?

  A. Convert a job to use bulk staging tables for Big Data File stages.

  B. Balance optimization attempts to balance the work between the source server, target sever, and the job.

  C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.

  D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.

  Correct Answer: D