Use this quick start guide to collect all the information about IBM Db2 Database Administrator Professional (C1000-198) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C1000-198 IBM Db2 v12.1 Database Administrator - Professional 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 Database Administrator Professional certification exam.
The IBM Db2 Database Administrator Professional certification is mainly targeted to those candidates who want to build their career in Data, Analytics, and AI domain. The IBM Certified Db2 v12.1 Database Administrator - Professional exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM Db2 Database Administrator Professional.
IBM Db2 Database Administrator Professional Exam Summary:
| Exam Name | IBM Certified Db2 v12.1 Database Administrator - Professional |
| Exam Code | C1000-198 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 66 |
| Passing Score | 71% |
| Books / Training |
IBM Db2 12.1: Essentials for Relational DBAs (2LA90G) IBM Db2 12.1: Data Management and Recovery for Relational DBAs (2LA91G) |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM Db2 Database Administrator Professional Sample Questions |
| Practice Exam | IBM C1000-198 Certification Practice Exam |
IBM C1000-198 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Design and Architect |
- Demonstrate knowledge of logical design and relational databases - Demonstrate knowledge of physical design practices - Understand Db2 objects |
9% |
| Db2 Server and Client Installation and Management |
- Understand the Db2 server and client installation options - Install and Configure Db2 Server and Client - Perform fixpack and upgrade maintenance activities for Db2 server and clients |
11% |
| Monitoring |
- Describe the Db2 Monitoring Framework - Select the Proper Db2 Monitoring Tools - Review and adjust configuration parameters - Monitor performance using Table Functions |
18% |
| Operating |
- Operate Database - Track Storage Capacity - Perform maintenance activities for the Db2 server - Perform troubleshooting - Analyze database performance - Optimize Db2 performance - Review historical usage patterns - Define storage options - Describe Job Scheduling and Automation - Manage User, Groups, and Roles - Configure and manage Workload Manager components - Understand data movement techniques |
33% |
| Security and Compliance |
- Understand the Db2 security model - Understand Db2 authentication methods - Configure Row and Column Access Control (RCAC) - Configure Label-Based Access Control (LBAC) - Encrypt database at rest and in-transit Leverage the Db2 audit facility |
15% |
| Business continuity |
- Explain topics to consider in determining a continuity strategy - Describe how to maintain necessary objects to provide continuity - Explain how to archive and configure database logs to provide resiliency - Demonstrate the configuration and uses of different resiliency methods |
14% |
To ensure success in IBM Db2 Database Administrator Professional certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM Db2 v12.1 Database Administrator - Professional (C1000-198) exam.
