PDF Version DemoIBM C2090-619 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Security | -Knowledge of Non OS users -Knowledge of auditing -Knowledge of trusted context and trusted connections -Knowledge of authentication and authorizatio -Knowledge of privileges and roles -Demonstrate knowledge of session, replication and ondisk encryption | 9% |
| 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 an H/A cluster -Demonstrate knowledge of Connection Manager -Demonstrate the ability to manage and use ifxclone -Knowledge of new replication and H/A cluster features -Performing rolling application and database software upgrades | 16% |
| Space Management | -Configure and manage dbspaces and sbspaces -Knowledge of Online Table Management -Knowledge of dynamic storage -Knowledge of pro-active/reactive space allocation -Knowledge of fragmentation and database design -Knowledge of compression | 11% |
| Performance Tuning | -Configure shared memory parameters -Best practices for logical and physical design of dbspaces -Utilize Parallel Database Query (PDQ) to optimize query performance -Use UPDATE STATISTICS to achieve optimal performance -Manage network parameters for optimal communication performance -Knowledge of DSS vs OLTP tuning differences -Manage temporary tables and files -Knowledge of autonomic features of the engine | 16% |
| Warehousing | -Knowledge of general warehousing functionality in the engine -Knowledge of Informix Warehouse Accellerator (IWA) | 4% |
| 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 -Set up Operating System files and parameters -Knowledge of migration and upgrading -Knowledge of installation options -Knowledge of activation of built-in technologies -Knowledge of Dynamic and automatic configuration parameters -Understanding different operating modes -Knowledge of data movement utilities -Knowledge of Mobile database | 17% |
| Backup and Restore | -Understand the different backup and restore tools, functionality, and levels -Configure Onbar parameters for optimal backup and restore performance -Configure ontape parameters for optimal backup and restore performance -Knowledge of archecker functionality -Understanding various restore options -Understanding and using Informix Primary Storage Manager (PSM) | 10% |
| 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 -SQL concurrency and locking | 13% |
| OAT and Database Scheduler | -Knowledge of general OAT functionality -Understanding, using and administering tasks and sensors | 4% |
Reference: https://www.ibm.com/certify/exam?id=C2090-619
IBM C2090-619 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Informix 12.10 System Administrator |
| Exam Number: | 000-619 |
| Available Languages: | English |
| Certificate Validity Period: | 2 years |
| Related Certifications: | IBM Certified Database Administrator - Informix |
| Exam Price: | USD 200 (varies by region) |
| Passing Score: | 63% |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 55 |
| Exam Format: | Multiple choice |
| Recommended Training: | IBM Training - Informix Courses IBM SkillsBuild |
| Exam Registration: | Pearson VUE IBM Exams IBM Certification Portal |
| Sample Questions: | IBM C2090-619 Sample Questions |
| Exam Way: | Computer-based exam delivered via Pearson VUE testing centers or online proctored exam (where available) |
| Pre Condition: | Recommended experience with IBM Informix database administration; no strict formal prerequisite. Some versions of the certification are retired or replaced by newer Informix certifications. |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM Informix System Administrator Exam Certification Details:
| Exam Name | IBM Certified System Administrator - Informix 12.10 |
| Exam Code | C2090-619 |
| Passing Score | 68% |
| Sample Questions | IBM Informix System Administrator Sample Questions |
| Duration | 90 mins |
| Number of Questions | 70 |
| Schedule Exam | Pearson VUE |
| Books / Training | IBM Informix 12.10 Information Center |
| Exam Price | $200 (USD) |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
983 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.