We're so confident of our products that we provide no hassle product exchange.
IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:
1. You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)
A) Input columns must form a numeric sequence.
B) Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
C) All columns are combined into a vector of the same length as the number of columns.
D) Columns must be in consecutive order.
E) Input columns must all be of the same data type.
2. There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?
A) Specify restartable mode on a transfer of the single file.
B) Create multiple readers to transfer file data and specify restartable mode on Input link tab.
C) Manually split the file into multiple files and specify restartable mode on a transfer.
D) Use a sequencer to check transfer status and restart the job from the beginning on failure.
3. A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?
A) In a single job, use five separate FTP Enterprise stages with output links to a single Sort Funnel stage. Next, process the records without landing to disk.
B) Create a sequence containing five separate DataStage jobs which each retrieve a single file and append it to a common Data Set. Next, process the resulting Data Set in an sixth DataStage job.
C) Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next, process the records without landing to disk.
D) In a single job, use three separate FTP Enterprise stages (one for each machine) with output links to a single Sort Funnel stage. Next, process the records without landing to disk.
4. Which two statements are true regarding access to a MQ queue? (Choose two.)
A) MQ stage and MQ connector stages support destructive reads.
B) MQ plugin stage can be used to read and write messages from a remote MQ message queue.
C) MQ stage connects to a queue manager in Client mode only.
D) MQ connector stage is capable of connecting to Queue manager in both Server and Client mode.
5. 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.)
A) IF IsNULL(input_column) THEN 'unknown' ELSE input_column.
B) IF input_column = '' THEN 'unknown' ELSE input_column.
C) NullToValue(input_column, 'unknown').
D) IF input_column = NULL THEN 'unknown' ELSE input_column.
Solutions:
| Question # 1 Answer: A,C,E | Question # 2 Answer: C | Question # 3 Answer: C | Question # 4 Answer: A,D | Question # 5 Answer: A,C |
By Lynn
