PDF Version DemoIBM Informix System Administrator Exam Certification Details:
| Passing Score | 60% |
| Exam Price | $200 (USD) |
| Exam Name | IBM Certified System Administrator - Informix 11.70 |
| Exam Code | C2090-919 |
| Sample Questions | IBM Informix System Administrator Sample Questions |
| Number of Questions | 63 |
| Duration | 90 mins |
| Schedule Exam | Pearson VUE |
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% |
| 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% |
| 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% |
| 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% |
| 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% |
| Warehousing | -Knowledge of Multi-index Star Join, Snow Flake support -Knowledge of Fragmentation -Knowledge of merge and external tables | 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% |
In recent years, more and more people choose to take IBM A2090-919 certification exam. Because the exam can help you get the IBM certificate which is an important basis for measuring your IT skills. With the IBM certificate, you can get a better life.
At ITexamGuide, we will offer you the most accurate and latest A2090-919 exam materials. When you are prepared for A2090-919 exam, these exam questions and answers on ITexamGuide.com is absolutely your best assistant. With our IBM study materials, you will be able to pass IBM A2090-919 exam on your first attempt. Also you don't need to spend lots of time on studying other reference books, and you just need to take 20-30 hours to grasp our exam materials well.
ITexamGuide is a website that includes many IT exam materials. Our PDF version & Software version exam questions and answers that are written by experienced IT experts are good in quality and reasonable price, and many customers have been well received. The hit rate is up to 99.9%. Guarantee you pass your A2090-919 exam. And the test engine on ITexamGuide.com will give you simulate the real exam environment. Then, you can deal with the A2090-919 exam with ease.
In our sincerity, for each client with high-quality treatment services every transaction. After you purchase A2090-919 exam materials, we will provide you with one year free update. In order to make the candidates satisfied, our IT experts work hard to get the latest exam materials. We also will check the updates at any time every day. If the materials updated, we will automatically send the latest to your mailbox.
Before you buy, you can try our free demo and download free samples for A2090-919 exam. If you are satisfied, then you can go ahead and purchase the full A2090-919 exam questions and answers.
100% money back guarantee - if you fail your exam, we will give you full refund. You just need to send the scanning copy of your examination report card to us. After confirming, we will quickly refund your money.
And just two steps to complete your order. Then we will send your products to your valid mailbox. After receiving it, you can download the attachment and use the materials.
960 Customer Reviews
Quality and ValueITexamGuide 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 ITexamGuide 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 BuyITexamGuide 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.