We're so confident of our products that we provide no hassle product exchange.
IBM InfoSphere DataStage v9.1 Sample Questions:
1. Which statement is true about improving job performance when using Balanced Optimization?
A) Balance optimization attempts to balance the work between the source server, target sever, and the job.
B) 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.
C) Convert a job to use bulk staging tables for Big Data File stages.
D) If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.
2. 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?
A) Select the job, right-click, then click the Find where used (deep) command.
B) Select the job, right-click, then click the Find dependencies (deep) command.
C) Select the job, right-click, then click the Find dependencies command. Then right-click and select "Show the dependency path from the job".
D) Select the job, right-click, then click the Find where used command. Then right-click and select "Show the dependency path from the job".
3. Two new columns have been deleted from a sequential file that a number of DataStage jobs write to. You have imported a table definition for the changed file. How can you determine what jobs might be affected by this change?
A) Select the original table definition, right-click, then click on the Where used command.
B) Select the new table definition, right-click, click on the Compare against command, then select original table definition.
C) Select the new table definition, right-click, then click on the Where used command.
D) Select the original table definition, right-click, then click on the Find dependencies command.
4. 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) STREAMS
B) EJB
C) SOAP
D) HDFS
E) SQL
5. Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)
A) Uses a unique custom GUI interface called the Assembly Editor.
B) A single XML Stage, which can be used as a source, target, or transformation.
C) XML Stage can be found in the Database folder on the palette.
D) It includes the XML Input, XML Output, and XML Transformer stages.
E) XML Stages are Plug-in stages.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: A | Question # 4 Answer: B,C | Question # 5 Answer: A,B |
By Alberta
