We're so confident of our products that we provide no hassle product exchange.
IBM C2090-418 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM WebSphere DataStage V.8.0 |
| Exam Number: | C2090-418 (also known as 000-418) |
| Related Certifications: | IBM Certified Solution Developer - InfoSphere Information Analyzer V8.0 |
| Available Languages: | English |
| Passing Score: | 70% |
| Exam Format: | Multiple Response, Multiple Choice |
| Certificate Validity Period: | No expiration / Lifetime valid |
| Real Exam Qty: | 60-70 |
| Exam Duration: | 90 minutes |
| Exam Price: | Approx. $200 USD (varies by region) |
| Recommended Training: | IBM InfoSphere DataStage Essentials IBM InfoSphere DataStage Advanced Development |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | IBM C2090-418 Sample Questions |
| Exam Way: | Proctored at Pearson VUE authorized test centers |
| Pre Condition: | No formal prerequisites; recommended hands-on experience with DataStage v8.0 |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM C2090-418 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Troubleshooting and Best Practices | 10% | - Error handling and debugging - Job optimization and standards - Migration and maintenance |
| Job Design and Development | 35% | - Stage usage: sources, transformations, targets - Lookups, references and constraints - Partitioning, collecting and sorting - Parallel and Server job design - Data types and metadata handling |
| Architecture and Environment | 20% | - DataStage/Information Server architecture - Project setup and management - Installation and configuration - Environment variables and configuration files |
| Job Execution and Monitoring | 20% | - Director client and job logs - Performance monitoring and tuning - Resource management and parallelism - Running and scheduling jobs |
| Administration and Security | 15% | - Backup and recovery procedures - User roles and security configuration - Repository management |
IBM Websphere Datastage V.8.0 Sample Questions:
Question 1
You have developed a parallel job using best practices to include Copy stages as debugging placeholders. In the parallel job score for this job, you notice that some of the Copy stages are not being optimized out as you had expected. What are three reasons for this behavior? (Choose three.)
A. One Copy stage has multiple outputs.
B. The "Force" property was set to "true" for one of the Copy stages.
C. The environment variable $APT_DISABLE_COPY_OPTIMIZATION has been set.
D. Runtime Column Propagation has been enabled on one or more of the Copy output links.
E. A non-default node pool was assigned to one of the Copy stages.
Question 2
Which three statements are true about stage variables? (Choose three.)
A. Stage variables can be used to control execution of constraints.
B. Stage variables retain their value between rows in the stage.
C. Stage variables are executed before output link derivations.
D. Stage variables are executed in random order.
E. Stage variables cannot be referenced in output link derivations.
Question 3
Which two statements are correct about XML stages and their usage? (Choose two.)
A. XML Output stage can invoke an XSLT style sheet for XML to tabular transformations.
B. XML Transformer stage converts XSLT data to tabular format.
C. XML Output stage converts tabular data to XML hierarchical structure.
D. XML Input stage converts XML data to tabular format.
Question 4
Which two statements are correct when using the Oracle Enterprise stage? (Choose two.)
A. Define variable $TNS_ADMIN to point to the tnsnames.ora file location.
B. DataStage Designer requires connectivity to the Oracle database during job development.
C. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH, or $SHLIB_PATH.
D. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH.
Question 5
You need to accumulate totals for all input records from a sequential file based on month, without regard to day or year. The output is to a sequential file. The columns appear as CUSTID Varchar(12), Sale_date Date, and sale_amount Decimal (5,2). Which series of stages would accomplish this task in the shortest time?
A. Sequential File -> Transformer -> Aggregator -> Sequential File
B. Sequential File -> Sort -> Aggregator -> Sequential File
C. Sequential File -> Transformer -> Remove Duplicates -> Sequential File
D. Sequential File -> Aggregator -> Sequential File
Solutions:
| Question 1 Answer: A,B,E | Question 2 Answer: A,B,C | Question 3 Answer: C,D | Question 4 Answer: C,D | Question 5 Answer: A |
By Julius
