The IBM DB2 DBA for Linux UNIX and Windows certification is mainly targeted to those candidates who want to build their career in IBM Analytics - Platform Analytics domain. The IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM DB2 DBA for Linux UNIX and Windows.

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

1. Demonstrate the ability to schedule jobs

2. Demonstrate the ability to use visual explain

Physical Design

- Demonstrate the ability to create a database and manipulate various DB2 objects

1. How to convert existing db to automatic storage db

2. Admin_move_table feature

- Demonstrate knowledge of partitioning capabilities
- Demonstrate knowledge of XML data objects
- Demonstrate knowledge of compression
- Demonstrate knowledge of new table features
- Knowledge of Multi-temperature data feature

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

The perfect way to pass C2090-611 DB2 10.1 DBA for Linux UNIX and Windows exam is choosing valid and real C2090-611 exam questions.

Exam Name:IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows

Exam Code C2090-611

Exam Price $200 (USD)

Duration 60 mins

Number of Questions 30

Passing Score 80%