Test 000-719: InfoSphere Warehouse V9.5

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to perform the intermediate and advanced skills required to design, develop, and support InfoSphere Warehouse V9.5 applications.

Section 1 - Architecting Warehouse Solutions (15%%)

1. Demonstrate knowledge of InfoSphere Warehouse architecture and components
   1. Editions
   2. Software Components (why/when to use)
2. Describe the InfoSphere Warehouse building life-cycle
   1. Steps to build and deploy the application(s)

Section 2 - Implementation (Table Ready) (5%%)

1. Describe hardware topologies
2. Given a scenario, demonstrate how to implement security considerations

Section 3 - Physical Data Modeling (15%%)

1. Given a scenario, demonstrate knowledge of the modeling process and the Design Studio features used
   1. Identify physical design methods
   2. Compare and synchronize
   3. Impact analysis
   4. Components
   5. Enhancing the model
2. Given a scenario, describe range/data partitioning considerations
   1. When is it appropriate to use
   2. Cost

Section 4 - Cubing Services (CS) (20%%)

1. Demonstrate knowledge of Cubing Services components
   1. Cube server
   2. Design Studio
   3. MQT administration
2. Given a scenario, describe CS tooling and access methods
   1. Demonstrate knowledge of CS optimization advisor
3. Identify the steps in creating a CS OLAP cube
   1. Metadata
   2. Creation of cube model and cube
4. Demonstrate knowledge of CS administration
   1. Deploying cubes to cube server
   2. Deploying cubes across multiple servers
   3. Caching

Section 5 - Data Mining/Unstructured Text Analytics (12%%)

1. Given a scenario, demonstrate knowledge of data mining and unstructured text analytics in InfoSphere Warehouse V9.5
2. Given scenario, describe the InfoSphere Intelligent Miner methods and how to use them
   1. The mining process
   2. Modeling
   3. Scoring
   4. Visualization
3. Demonstrate how to use Design Studio to implement mining methods
   1. Mining unstructured text data - what do you do with it after it is extracted
4. Describe the unstructured text analytic information extraction process
   1. Using JAVA regular expressions
   2. Dictionary

Section 6 - SQL Warehousing Tool (SQW) (20%%)

1. Demonstrate knowledge of SQW components
   1. Data flows
   2. Control flows
   3. Mining flows
   4. Variables
   5. Versioning
2. Describe SQW anatomy
   1. Operators
   2. Ports
   3. Connectors
3. Given a scenario, describe the SQW debugging functions

Section 7 - Run-time Administration and Monitoring of the Warehouse (13%%)

1. Identify the application preparation steps for deployment
2. Describe the InfoSphere Warehouse components managed by Admin console
3. Demonstrate knowledge of managing, monitoring, and scheduling processes in Admin console
4. Given a scenario, demonstrate knowledge of workload management and monitoring
   1. Difference between workload and classes
   2. Controlling types of queries
   3. Performance Expert