We're so confident of our products that we provide no hassle product exchange.
IBM P2090-010 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM InfoSphere Information Server Technical Mastery Test v2 |
| Exam Number: | P2090-010 |
| Certificate Validity Period: | No expiration (as long as product is supported) |
| Related Certifications: | IBM Certified Specialist - InfoSphere IBM Certified Solution Developer - InfoSphere |
| Exam Format: | Multiple Response, Multiple Choice |
| Exam Duration: | 75 minutes |
| Exam Price: | Approx. $200 USD (varies by region) |
| Available Languages: | English, Japanese |
| Real Exam Qty: | 40 - 60 |
| Passing Score: | 70% - 75% |
| Recommended Training: | IBM Education - Data Integration & Governance IBM InfoSphere Information Server Essentials |
| Exam Registration: | Pearson VUE Scheduling IBM Certification & Registration |
| Sample Questions: | IBM P2090-010 Sample Questions |
| Exam Way: | Proctored online or at authorized Pearson VUE test centers |
| Pre Condition: | No formal prerequisites; recommended 6+ months hands-on experience with InfoSphere Information Server |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM P2090-010 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Data Integration - DataStage | 30% | - FastTrack and DataStage integration - Job development, testing and deployment - Partitioning and pipeline parallelism - Parallel engine and job design |
| Administration and Solution Design | 20% | - Installation and configuration - Solution architecture best practices - Security and access control - Performance tuning and troubleshooting |
| Data Quality and Governance | 25% | - Metadata Workbench and data lineage - Business Glossary and governance - InfoSphere Information Analyzer - InfoSphere QualityStage |
| Architecture and Components | 25% | - InfoSphere Information Server architecture overview - Metadata Repository and shared services - Client/server components and deployment models |
IBM InfoSphere Information Server Technical Mastery Test v2 Sample Questions:
Question #1
Which statement about FastTrack mapping editor is TRUE?
- A. Each transformation rule description field must be filled before a job can be generated.
- B. Each transformation rule expression must contain valid SQL syntax.
- C. The transformation rule expression field does not need to be filled for each pair of mapped columns before a job can be generated.
- D. The annotation field contains information about errors encountered during validation of a mapping specification.
Correct Answer: C 🗳️
Question #2
In which situation will you be using the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?
- A. To bring runtime information about DataStage jobs into the Metadata Repository
- B. To bring a blueprint from Blueprint Director into the Metadata Repository
- C. In none of these situations.
- D. To bring Cognos BI reports and queries into the Metadata Repository
- E. To bring FastTrack mapping specifications into the Metadata Repository
- F. To bring Business Glossary terms definitions and related assets into the Metadata Repository
Correct Answer: D 🗳️
Question #3
Which kind of interaction are supported between infoSphere Discovery and the other infoSphere foundation tools?
- A. In infoSphere Discovery, you can associate target columns in the mapping specification with business terms from the Business glossary.
- B. infoSphere Discovery mapping specifications can be saved in a csv format and be imported into FastTrack.
- C. In infoSphere Discovery, you can generate a Datastage job from a mapping specification.
- D. The result from a column analysis in infoSphere Discovery can be exported to the ladb database of information Analyzer for future analysis.
Correct Answer: B 🗳️
Question #4
Which tool would you recommend to obtain a clear roadmap of the tasks required to deal with quality issues of data stored in your source databases?
- A. Use the native DBMS catalog tables, and retrieve the detailed statistics
- B. InfoSphere Blueprint Director
- C. InfoSphere Information Analyzer
- D. InfoSphere Metadata Workbench
- E. InfoSphere QualityStage
- F. InfoSphere Discovery
Correct Answer: B 🗳️
Question #5
Which scenario would NOT benefit much from using InfoSphere Foundation Tools?
- A. Removing duplicate records
- B. Delivering trusted master data
- C. Delivering information as a service
- D. Developing business driven Business Intelligence
- E. Addressing data quality
Correct Answer: A 🗳️
By Elsie
