We're so confident of our products that we provide no hassle product exchange.
IBM C2090-303 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Assessment: IBM InfoSphere DataStage v9.1 Assessment |
| Exam Number: | A2090-303 |
| Exam Price: | N/A |
| Exam Duration: | 90 minutes |
| Available Languages: | English |
| Related Certifications: | IBM Certified Solution Developer - InfoSphere DataStage v9.1 |
| Exam Format: | Assessment questions, Multiple choice |
| Sample Questions: | IBM C2090-303 Sample Questions |
| Exam Way: | Online proctored or Pearson VUE testing center (if applicable) |
| Pre Condition: | Basic knowledge of ETL concepts and data integration recommended |
| Official Syllabus URL: | https://www.ibm.com/certification |
IBM C2090-303 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data Integration Basics | - Connecting to data sources - Flat file and database integration overview |
| Basic Troubleshooting and Monitoring | - Simple error identification concepts - Job run monitoring basics |
| DataStage Fundamentals | - Core concepts of InfoSphere DataStage - Basic ETL and data integration principles |
| DataStage Architecture Overview | - Parallel processing architecture basics - Components of DataStage environment |
| Job Design Concepts | - Introduction to job stages and links - Transformer and data flow basics |
IBM InfoSphere DataStage v9.1 Sample Questions:
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.
Correct Answer: B 🗳️
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".
Correct Answer: C 🗳️
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.
Correct Answer: A 🗳️
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
Correct Answer: B,C 🗳️
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.
Correct Answer: A,B 🗳️
Viewing page 1 out of 27 pages.
Viewing questions 1-5 out of 134 questions.
By Joanna
