IBM 000-418 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Job Design and Development | - Parallel Job Development
|
| Data Transformation and Processing | - Transformation Techniques
|
| DataStage Architecture and Fundamentals | - DataStage Components
|
| Job Execution and Administration | - Execution and Monitoring
|
| Data Integration and Connectivity | - Source and Target Connectivity
|
IBM Websphere Datastage V.8.0 Sample Questions:
1. Which three statements are true about File Sets? (Choose three.)
A) File sets are partitioned.
B) File sets are stored as header file and data files.
C) File sets are readable by external applications.
D) File sets are stored as a single file.
E) File sets are unpartitioned.
2. In a job using Sequential File stage to write a sequential file, the ContactName column is nullable, but the "Null field value" property is left unspecified. The ContactName column has a Char(50) data type. What will happen if NULL is written to the ContactName column?
A) The column will be padded with the character specified by the $APT_STRING_PADCHAR character.
B) The job will abort.
C) The row containing the NULL will be rejected.
D) The empty string ("") will be written to the ContactName column.
3. A Data Set was created earlier with one partition. A subsequent job using a 2-node configuration file reads from that Data Set passing data to a Transformer stage with "Same" partitioning. Which statement is true?
A) Setting the Preserve Partitioning flag to "Set" will run one instance of the Transformer stage.
B) DataStage will repartition the data and run one instance of the Transformer stage.
C) The DataStage job will abort.
D) Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage.
4. Which three statements are true about stage variables? (Choose three.)
A) Stage variables retain their value between rows in the stage.
B) Stage variables are executed before output link derivations.
C) Stage variables are executed in random order.
D) Stage variables cannot be referenced in output link derivations.
E) Stage variables can be used to control execution of constraints.
5. Your job reads from a file using a Sequential File stage running sequentially. You are using a Transformer stage following the Sequential File stage to format the data in some of the columns. What is the default (Auto) partitioning method?
A) Random
B) Hash
C) Round Robin
D) Same
Solutions:
| Question # 1 Answer: A,B,C | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: A,B,E | Question # 5 Answer: C |
0 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
