Exam Code: C2090-919
Exam Name: Informix 11.70 System Administrator
Questions: 123 Q&As
Updated: 2019-01-27
Price: $ 79 / $ 109

  • Latest IBM C2090-919 exam dumps PDF.

  • Instant download after purchase!

  • Questions & Answers are based on real exam questions and formatted questions.

  • Best price of the whole network.

  • PDF format can be viewed on any device supports printing.

C2090-919 DEMO (Free)


The latest actual C2090-919 questions and answers from ISLEVER. Everything you need to prepare and get best score at C2090-919 exam easily and quickly. "Informix 11.70 System Administrator" exam engine covers all the knowledge points of the real IBM exam.

Quality test content is extremely important to us so that you will be prepared on exam day. We ensure that all objectives of the exam are covered in depth so you'll be ready for any question on the exam. Our practice tests are written by industry experts in the subject matter. They work closely with certification providers to understand the exam objectives, participate in beta testing and take the exam themselves before creating new practice tests.

What do you offer?

We provide C2090-919 examination of learning materials, it can help you quickly master the test points.

The product contains C2090-919 examination common exam questions and answers, covering the real exam content more than 90%.

Product contains labs content?

Yes, Product contains C2090-919 exam Q&As and preparation labs questions.

Do you provide free updates?

We provide the updated version of the C2090-919 exam free, you can download on the website of the member center.

After the purchase, how long can you get?

7/24, after a successful purchase, you will be able to immediately download the product.

Login to the site, in the member center click download product.

What is the product format, I can use in what equipment?

Products using the PDF format, you can browse and learning in PC, IOS, Android and so on any device that supports PDF.

After the purchase, you do not have any restrictions, even, you can print out for learning.

Test information:

  • Number of questions: 63
  • Time allowed in minutes: 90
  • Passing score: 60%
  • Language: English
  • Test Fee: 30 USD
  • Sponsor Area: IBM Information Management Assessment Tests
  • Test Title: AT0919: 919 System Administrator for Informix Server 11.70 Assessment

Section 1 - Installation and Configuration (12.5%)

  1. Determine appropriate connection types and communication protocols

  2. Plan for Distributed System capabilities

  3. Determine the number and size and placement of logical and physical logs to accommodate transaction activity

  4. Determine when an instance can/should use AIO or KAIO

  5. Set up Operating System files and parameters

  6. Deployment assistant/ Deployment utility

  7. Knowledge of migration and upgrading

  8. Knowledge of installation order for multiple products

  9. Prepare and use of user defined types

Section 2 - Space Management (19%)

  1. Configure and manage dbspaces and sbspaces

  2. Knowledge of OLTR

  3. Knowledge of storage pool mgmt

  4. Knowledge of extendable chunks

  5. Knowledge of pro-active/reactive space allocation

  6. Knowledge of fragmentation and database design (online attach/detach)

  7. Knowledge of compression

Section 3 - System Activity Monitoring and Troubleshooting (14%)

  1. Monitor and isolate problems using system databases

  2. Monitor the message log file for abnormal activity

  3. Use the Informix utilities to view information about the database server

  4. Use the admin API to view information about the database server

  5. Use of concurrency and locking

Section 4 - Performance Tuning (16%)

  1. Configure online shared memory parameters

  2. Determine optimal disk layout and configuration

  3. Utilize Parallel Database Query (PDQ) to optimize query performance

  4. Use UPDATE STATISTICS to achieve optimal performance

  5. Configure system for optimal checkpoint duration, recovery logs, auto checkpoints

  6. Monitor the number of Virtual Processors (VPs) needed for the resources available

  7. Manage network parameters for optimal communication performance

  8. Knowledge of DSS vs OLTP tuning differences

  9. Manage temporary tables and files

Section 5 - Backup and Restore (8%)

  1. Select the appropriate backup and restore strategy and restore utilities for a particular situation

  2. Configure Onbar parameters for optimal backup and restore performance

  3. Configure ontape parameters for optimal backup and restore performance

  4. Use of operation modes

Section 6 - Replication and High Availability (10%)

  1. Demonstrate the ability to manage and configure ER

  2. Demonstrate the ability to manage and configure GRID

  3. Demonstrate the ability to manage and configure Mach 11 and HDR

  4. Demonstrate knowledge of Connection Manager

Section 7 - Warehousing (8%)

  1. Knowledge of Multi-index Star Join, Snow Flake support

  2. Knowledge of Fragmentation

  3. Knowledge of merge and external tables

Section 8 - Security (12.5%)

  1. Knowledge of Non OS users

  2. Knowledge of SRL auditing / auditing

  3. Knowledge of trusted context

  4. Knowledge of authentication, authorization, and encryption

  5. Knowledge of privileges

  6. Demonstrate ability to configure a secure DBMS - Role separation

I just want to thank you for the information you have in the C2090-919(Informix 11.70 System Administrator) study guide. It is just great. It is the best study material I have ever used.

ISLEVER C2090-919 course allows professional to gain an in depth knowledge about networking. It is truly a blessing that I used your products as my exam preparation material.

When you will achieve more than 90% marks in your C2090-919 exam then you will become wanted candidate of all companies and your future will become automatically intense.