IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 121:

  Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Before you create the package you will have to ensure the project is up to date with version 1. What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Choose two.)

  A. Right-click the asset and click the Deploy command.

  B. Right-click the asset and click the Team Import command.

  C. Right-click the asset and click Update From Source Control Workspace.

  D. Right-click the asset and click Replace From Source Control Workspace.

  E. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

  Correct Answer: DE

• Question 122:

  You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by a former developer of the project. How can you find these jobs?

  A. Sort the jobs by date in the Repository window.

  B. Use Advanced Find feature in the Designer interface.

  C. Select the top project folder and choose Find Dependencies (deep).

  D. Right-click on jobs folder in the Repository window and select Filter jobs.

  Correct Answer: B

• Question 123:

  On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?

  A. Compare Against

  B. diffapicmdline.exe

  C. DSMakeJobReport

  D. Cross Project Compare

  Correct Answer: D

• Question 124:

  You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are two valid ways to do this? (Choose two.)

  A. Use local parameters.

  B. Place a parameter set stage on the job sequence.

  C. Add a Transformer stage variable to the job sequence canvas.

  D. Check the "Propagate Parameters" checkbox in the Sequence Job properties.

  E. Use the UserVariablesActivity stage to populate the local parameters from an outside source such as a file.

  Correct Answer: AE

• Question 125:

  What is the result of running the following command: dsjob -report DSProject ProcData

  A. Generates a report about the ProcData job, including information about its stages and links.

  B. Returns a report of the last run of the ProcData job in a DataStage project named DSProject.

  C. Runs the DataStage job named ProcData and returns performance information, including the number of rows processed.

  D. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.

  Correct Answer: B

• Question 126:

  Which two actions are available when editing a message handler? (Choose two.)

  A. Abort job

  B. Demote to warning

  C. Suppress from job log

  D. Demote to informational

  E. Suppress from the project

  Correct Answer: CD

• Question 127:

  Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)

  A. Set the Job1 Activity stage to "Do not checkpoint run".

  B. Set trigger on the Job1 Activity stage to "Unconditional".

  C. In the Job1 Activity stage set the Execution action to "Run".

  D. In the Job1 Activity stage set the Execution action to "Reset if required, then run".

  E. Use the Nested Condition Activity with a trigger leading to Job1; set the trigger expression type to "Unconditional".

  Correct Answer: AD

• Question 128:

  In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File stage with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. In the Funnel stage, the funnel type is set to "Sequence".

  

  The parallel configuration file contains 4 nodes. How many instances of the Funnel stage run in parallel?

  A. 1

  B. 2

  C. 4

  D. 6

  Correct Answer: C

• Question 129:

  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?

  A. Select an in-stage sort in the final Sequential File stage.

  B. Select the Ordered collector method for the final Sequential File stage.

  C. Select the Sort Merge collector method for the final Sequential File stage.

  D. Insert a Funnel stage before the final Sequential File stage and select Sequence as Funnel Type.

  Correct Answer: B

• Question 130:

  Which partitioning method requires a key?

  A. Same

  B. Modulus

  C. Sort Merge

  D. Round Robin

  Correct Answer: B