We're so confident of our products that we provide no hassle product exchange.
IBM DB2 DBA for Linux UNIX and Windows Exam Certification Details:
| Exam Price | $200 (USD) |
| Schedule Exam | Pearson VUE |
| Number of Questions | 59 |
| Duration | 90 mins |
| Sample Questions | IBM DB2 DBA for Linux UNIX and Windows Sample Questions |
| Books / Training | DB2 10.5 for LUW New Features and Database Upgrade Considerations DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs |
| Passing Score | 61% |
| Exam Name | IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows |
| Exam Code | C2090-611 |
IBM C2090-611 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| High Availability | -Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery) -Demonstrate the ability to perform database-level and table space level backup and recovery operations -Demonstrate the ability to configure and manage HADR (read from standby) -Demonstrate knowledge of DB2 pureScale (HA features only) | 10% |
| Connectivity and Networking | -Demonstrate the ability to configure database connectivity -Demonstrate knowledge of DB2 Discovery -Demonstrate knowledge of LDAP | 6.5% |
| Security | -Describe DB2 authorizations and privileges -Knowledge of the security administrator role -Demonstrate general knowledge of the Audit facility -Demonstrate knowledge of the trusted context -Demonstrate knowledge of row column access control (RCAC) -Demonstrate knowledge of LBAC | 15% |
| Utilities | -Demonstrate the ability to use traditional data movement utilities -Demonstrate the ability to use the Ingest utility -Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities -Demonstrate the ability to use the DB2 Design Advisor utility | 14% |
| Monitoring DB2 Activity | -Demonstrate the ability to use Admin views and SQL functions for monitoring -Knowledge of Work Load Manager monitoring features -Demonstrate the ability to use additional auto-monitoring tools -Demonstrate the ability to identify the functions of Problem Determination Tools -Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information | 10% |
| Physical Design | -Demonstrate the ability to create a database and manipulate various DB2 objects
-Demonstrate knowledge of partitioning capabilities | 26% |
| DB2 Server Management | -Demonstrate the ability to configure/manage DB2 servers, instances, and databases -Demonstrate the ability to use autonomic features -Demonstrate the ability to use Data Studio
| 10% |
| Business Rules Implementation | -Demonstrate the ability to create constraints on tables -Demonstrate the ability to create views WITH CHECK OPTION -Demonstrate the ability to create and using triggers -Demonstrate the ability to use the set integrity command | 8.5% |
By Vicky
