IBM DB2 DBA for LUW Exam Syllabus

DB2 DBA for LUW PDF, C2090-600 Dumps, C2090-600 PDF, DB2 DBA for LUW VCE, C2090-600 Questions PDF, IBM C2090-600 VCEUse this quick start guide to collect all the information about IBM DB2 DBA for LUW (C2090-600) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-600 IBM DB2 11.1 DBA for LUW 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 LUW certification exam.

The IBM DB2 DBA for LUW certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Platform Analytics domain. The IBM Certified Database Administrator - DB2 11.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 LUW.

IBM DB2 DBA for LUW Exam Summary:

Exam Name IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows
Exam Code C2090-600
Exam Price $200 (USD)
Duration 90 mins
Number of Questions 60
Passing Score 63%
Schedule Exam Pearson VUE
Sample Questions IBM DB2 DBA for LUW Sample Questions
Practice Exam IBM C2090-600 Certification Practice Exam

IBM C2090-600 Exam Syllabus Topics:

Topic Details Weights
DB2 Server Management - Configure and manage DB2 servers, instances, and databases
- Create and manage database storage paths
- Exploit autonomic features
- Explain the functionality of WLM
- Describe the capabilities of Data Server Manager
15%
Physical Design - Implement BLU Acceleration
- Describe DB2 pureScale enhancements
- Create, manage, and alter DB2 objects
- Demonstrate the proper use of compression
- Describe the SQL compatibility available
- Describe the partitioning capabilities available
22%
Business Rules Implementation - Create and modify table constraints
- Enforce constraint checking with the SET INTEGRITY command
- Create and use triggers
10%
Monitoring DB2 Activity - Demonstrate the proper use of monitoring tools
- Use the DB2 Problem Determination tool (db2pd)
- Describe the capabilities of dsmtop
- Capture and analyze EXPLAIN information
12%
Utilities - Demonstrate the proper use of DB2's data movement utilities
- Demonstrate the proper use of REORG, REORGCHK, REBIND, RUNSTATS, FLUSH PACKAGE CACHE, and ADMIN_CMD
- Perform an INPLACE table REORG
- Demonstrate the proper use of db2look and db2move
13%
High Availability - Perform database-level and table space level backup and recovery operations
- Configure and manage HADR
- Implement a DB2 pureScale environment
13%
Security - Explain the use of LDAP authentication
- Create and use trusted contexts
- Restrict access to sensitive data
- Explain how to encrypt data in transit and data at rest
- Configure and use the Audit facility
15%

To ensure success in IBM DB2 DBA for LUW certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM DB2 11.1 DBA for LUW (C2090-600) exam.

Rating: 5 / 5 (45 votes)