We're so confident of our products that we provide no hassle product exchange.
IBM A2090-919 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | Informix 11.70 System Administrator |
| Exam Number: | C2090-919 |
| Certificate Validity Period: | Not specified |
| Exam Format: | Multiple-choice, Multiple-response |
| Real Exam Qty: | 63 |
| Exam Price: | USD 200 (may vary by region) |
| Exam Duration: | 90 minutes |
| Available Languages: | English |
| Passing Score: | 60% |
| Recommended Training: | IBM Informix 11.70 Administration Training |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | IBM A2090-919 Sample Questions |
| Exam Way: | In-person at Pearson VUE centers or online proctored |
| Pre Condition: | No formal prerequisites; recommended 2+ years of Informix administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/C2090-919 |
IBM C2090-919 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Space Management | -Configure and manage dbspaces and sbspaces -Knowledge of OLTR -Knowledge of storage pool mgmt -Knowledge of extendable chunks -Knowledge of pro-active/reactive space allocation -Knowledge of fragmentation and database design (online attach/detach) -Knowledge of compression | 19% |
| System Activity Monitoring and Troubleshooting | -Monitor and isolate problems using system databases -Monitor the message log file for abnormal activity -Use the Informix utilities to view information about the database server -Use the admin API to view information about the database server -Use of concurrency and locking | 14% |
| Warehousing | -Knowledge of Multi-index Star Join, Snow Flake support -Knowledge of Fragmentation -Knowledge of merge and external tables | 8% |
| Security | -Knowledge of Non OS users -Knowledge of SRL auditing / auditing -Knowledge of trusted context -Knowledge of authentication, authorization, and encryption -Knowledge of privileges -Demonstrate ability to configure a secure DBMS - Role separation | 12.5% |
| Installation and Configuration | -Determine appropriate connection types and communication protocols -Plan for Distributed System capabilities -Determine the number and size and placement of logical and physical logs to accommodate transaction activity -Determine when an instance can/should use AIO or KAIO -Set up Operating System files and parameters -Deployment assistant/ Deployment utility -Knowledge of migration and upgrading -Knowledge of installation order for multiple products -Prepare and use of user defined types | 12.5% |
| Performance Tuning | -Configure online shared memory parameters -Determine optimal disk layout and configuration -Utilize Parallel Database Query (PDQ) to optimize query performance -Use UPDATE STATISTICS to achieve optimal performance -Configure system for optimal checkpoint duration, recovery logs, auto checkpoints -Monitor the number of Virtual Processors (VPs) needed for the resources available -Manage network parameters for optimal communication performance -Knowledge of DSS vs OLTP tuning differences -Manage temporary tables and files | 16% |
| Backup and Restore | -Select the appropriate backup and restore strategy and restore utilities for a particular situation -Configure Onbar parameters for optimal backup and restore performance -Configure ontape parameters for optimal backup and restore performance -Use of operation modes | 8% |
| Replication and High Availability | -Demonstrate the ability to manage and configure ER -Demonstrate the ability to manage and configure GRID -Demonstrate the ability to manage and configure Mach 11 and HDR -Demonstrate knowledge of Connection Manager | 10% |
IBM Informix System Administrator Exam Certification Details:
| Exam Name | IBM Certified System Administrator - Informix 11.70 |
| Exam Price | $200 (USD) |
| Number of Questions | 63 |
| Exam Code | C2090-919 |
| Sample Questions | IBM Informix System Administrator Sample Questions |
| Schedule Exam | Pearson VUE |
| Duration | 90 mins |
| Passing Score | 60% |
By Althea
