Test 000-544: DB2 9.7 Advanced DBA for LUW

The test contains six sections totaling approximately 53 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Database Design (11%)

1. Ability to design, create and manage database storage paths
2. Ability to design, create and manage table spaces
3. Ability to design, create and manage buffer pools
4. Ability to design and configure federated database access

Section 2 - Data Partitioning and Clustering (15%)

1. Ability to design, create, and manage database partitioning
2. Ability to design, create, and manage multi-dimensional clustered tables
3. Ability to design, create, and manage table partitioning
4. Knowledge of IBM Smart Analytics System

Section 3 - High Availability and Diagnostics (21%)

1. Ability to manage database logs for recovery
2. Ability to use advanced backup features
3. Ability to use advanced recovery features
4. Ability to enhance database availability
5. Ability to use diagnostic tools
6. Ability to use High Availability Disaster Recovery (HADR)

Section 4 - Performance and Scalability (34%)

1. Identify and use DB2 registry variables that affect database system performance
2. Identify and use configuration parameters that affect database system performance
3. Knowledge of query optimizer concepts
4. Ability to manage and tune database, instance and application memory and I/O
5. Ability to use Compression
6. Ability to identify and resolve performance problems
7. Ability to manage a large number of users and connections
8. Ability to determine the appropriate index to create
9. Ability to exploit parallelism

Section 5 - Security (11%)

1. Knowledge of external authentication mechanisms
2. Ability to implement Label Based Access Control (LBAC)
3. Ability to use DB2 Audit
4. Knowledge of authorities, priviledges, and roles

Section 6 - Connectivity and Networking (8%)

1. Ability to manage connections to host systems
2. Ability to manage connections from clients
3. Ability to identify and resolve connection problems