We're so confident of our products that we provide no hassle product exchange.
IBM C2090-303 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM InfoSphere DataStage v9.1 |
| Exam Number: | 000-303 |
| Available Languages: | English |
| Exam Format: | Multiple Choice, Multiple Select |
| Passing Score: | 66% |
| Exam Price: | USD 200 |
| Related Certifications: | IBM Certified Specialist - InfoSphere DataStage IBM Certified Solution Developer - InfoSphere Information Server |
| Certificate Validity Period: | 3 years |
| Real Exam Qty: | 134 |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM Knowledge Center IBM InfoSphere DataStage Essentials |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | IBM C2090-303 Sample Questions |
| Exam Way: | Proctored at Pearson VUE test centers or online proctored |
| Pre Condition: | Basic knowledge of ETL concepts, SQL, and data warehousing; familiarity with IBM InfoSphere Information Server environment |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/000-303 |
IBM C2090-303 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Job Execution and Administration | 20% | - Job configuration and execution
|
| Topic 2: Data Integration and Transformation | 30% | - Data connectivity
|
| Topic 3: Architecture and Components | 20% | - InfoSphere Information Server architecture
|
| Topic 4: Design and Development | 30% | - DataStage Designer interface
|
IBM InfoSphere DataStage v9.1 Sample Questions:
You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. What are two requirements on the input link data for the Change Capture stage? (Choose two.)
- A. sorted
- B. merged links
- C. sequential mode
- D. key partitioned
- E. parallel mode
Click the Exhibit button.
The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)
- A. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.
- B. Director job monitor tool.
- C. Designer "Show performance statistics" option.
- D. Designer Performance Analyzer tool.
- E. The view data button in the target Connector stage.
When optimizing a job, Balanced Optimization will NOT search the job for what pattern?
- A. Sequencers
- B. Stages
- C. Links
- D. Property Settings
Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)
- A. A single XML Stage, which can be used as a source, target, or transformation.
- B. Uses a unique custom GUI interface called the Assembly Editor.
- C. It includes the XML Input, XML Output, and XML Transformer stages.
- D. XML Stages are Plug-in stages.
- E. XML Stage can be found in the Database folder on the palette.
What is the result of running the following command: dsjob -report DSProject ProcData
- A. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.
- 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. Generates a report about the ProcData job, including information about its stages and links.
By Fanny
