IBM DB2 DBA for Linux UNIX and Windows Exam Syllabus

DB2 DBA for Linux UNIX and Windows PDF, C2090-611 Dumps, C2090-611 PDF, DB2 DBA for Linux UNIX and Windows VCE, C2090-611 Questions PDF, IBM C2090-611 VCEUse this quick start guide to collect all the information about IBM DB2 DBA for Linux UNIX and Windows (C2090-611) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-611 IBM DB2 10.1 DBA for Linux UNIX and Windows exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM DB2 DBA for Linux UNIX and Windows certification exam.

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.

IBM DB2 DBA for Linux UNIX and Windows Exam Summary:

Exam Name IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows
Exam Code C2090-611
Exam Price $200 (USD)
Duration 90 mins
Number of Questions 59
Passing Score 61%
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
Schedule Exam Pearson VUE
Sample Questions IBM DB2 DBA for Linux UNIX and Windows Sample Questions
Practice Exam IBM C2090-611 Certification Practice Exam

IBM C2090-611 Exam Syllabus Topics:

Topic Details Weights
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
10%
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

26%
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%
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%
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%
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%
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%
Connectivity and Networking - Demonstrate the ability to configure database connectivity
- Demonstrate knowledge of DB2 Discovery
- Demonstrate knowledge of LDAP
6.5%

To ensure success in IBM DB2 DBA for Linux UNIX and Windows certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM DB2 10.1 DBA for Linux UNIX and Windows (C2090-611) exam.

Rating: 5 / 5 (18 votes)