We're so confident of our products that we provide no hassle product exchange.
IBM A2090-421 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM InfoSphere DataStage v8.5 Solution Developer |
| Exam Number: | 000-421 |
| Exam Price: | Approximately 200 USD (varies by region) |
| Available Languages: | English |
| Real Exam Qty: | 55-70 |
| Certificate Validity Period: | 3 years |
| Related Certifications: | IBM Certified Solution Developer - InfoSphere DataStage |
| Passing Score: | Approximately 61% |
| Exam Format: | Multiple choice, Scenario-based questions |
| Exam Duration: | 75-90 |
| Sample Questions: | IBM A2090-421 Sample Questions |
| Exam Way: | Online proctored or authorized test center (IBM testing provider dependent) |
| Pre Condition: | Basic knowledge of ETL concepts and data warehousing is recommended |
| Official Syllabus URL: | https://www.ibm.com/certification/ |
IBM A2090-421 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: DataStage Architecture and Concepts | - Server vs parallel jobs overview - Parallel processing architecture - InfoSphere DataStage components |
| Topic 2: Connectivity and Data Sources | - Database connectors and stages - File handling (sequential and complex files) |
| Topic 3: Performance Tuning and Optimization | - Parallel job optimization techniques - Partitioning and parallelism strategies |
| Topic 4: Debugging and Administration | - Job monitoring and troubleshooting - Logging and error handling |
| Topic 5: Job Design and Development | - Designing DataStage jobs - Transformations and stages usage - Data flow and job sequencing |
IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:
You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?
- A. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.
- B. Select a Table Definition, then right click and choose Find where column is used. Select the column to search for from the list.
- C. Open the Table Definition properties, Select the ADDRESS column, then right click and select Find where used.
- D. From Designer Tools, open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.
Correct Answer: A 🗳️
In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.
Which two choices will eliminate sort operators from being inserted at run-time? (Select two)
- A. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
- B. Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True".
- C. Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages.
- D. Add Sort stages in front of the Join stage and specify the Same partitioner for the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".
Correct Answer: A,D 🗳️
Which two statements are correct when referring to an Aggregator Stage? (Choose two.)
- A. Use Hash method with a large number of distinct key-column values
- B. Use Sort method for a limited number of distinct key values
- C. Use Sort method with a large number of distinct key-column values
- D. Use Hash method for a limited number of distinct key values
Correct Answer: C,D 🗳️
What conditions are necessary for a master record and an update record to merge?
- A. all of the columns in the input record match the columns in the update record
- B. some of the columns in the input record match the columns in the update record
- C. both records have the same values for the merge key column(s) that you specify
- D. none of the columns in the input record match the columns in the update record
Correct Answer: C 🗳️
When you configure a domain for source code integration a source control workspace is created. What are two reasons for the source control workspace? (Choose two.)
- A. local transfer area for assets being submitted to the source control system
- B. directory for deployment package files
- C. default directory for istool exports.
- D. provides a place to store the archive created by IS source code control integration
Correct Answer: A,D 🗳️
Viewing page 1 out of 39 pages.
Viewing questions 1-5 out of 194 questions.
By Todd
