IBM C2090-544 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Database Architecture & Configuration | 20% | - Instance and database configuration - Storage management and table spaces - Partitioned database environment - Memory management and STMM |
| Topic 2: Migration, Maintenance & Troubleshooting | 15% | - Data movement and repartitioning - Upgrading to DB2 9.7 - Problem determination and error resolution |
| Topic 3: Backup, Recovery & High Availability | 25% | - Log management and archiving - Restore and rollforward recovery - Backup strategies and utilities - HADR and high availability solutions |
| Topic 4: Performance Tuning & Optimization | 25% | - Index design and maintenance - Query optimization and access plans - Monitoring tools and advisors - Sorting and memory tuning |
| Topic 5: Security & Compliance | 15% | - Privilege management - Authentication and authorization - Auditing and encryption |
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
1. Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY
A) Any time after 11:02:03 am
B) Any time before 11:07:03 am
C) Any time after 11:07:04 am
D) Any time after 11:07:03 am
2. Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?
A) Non-fenced routines can be invoked, however automatic database maintenance will be disabled.
B) In a partitioned environment, infinite communications will be enabled between partitions.
C) User-defined function calls will be disabled.
D) In a partitioned environment, communications will not be buffered.
3. At which two levels can events be audited? (Choose two.)
A) Operating System level
B) Node level
C) Server level
D) Database level
E) Instance level
4. A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?
A) The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE command must be issued.
B) A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified.
C) A RECOVER DATABASE command must be issued with the RESTART option specified.
D) A RECOVER DATABASE command must be re-issued with the REPLACE option specified.
5. Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information: DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?
A) DB2_PARALLEL_IO=7:7
B) DB2_PARALLEL_IO=7:64
C) DB2_PARALLEL_IO=7:16
D) DB2_PARALLEL_IO=7:32
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: A | Question # 3 Answer: D,E | Question # 4 Answer: C | Question # 5 Answer: A |
1431 Customer Reviews
Quality and ValueITCertKing 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 ITCertKing 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 BuyITCertKing 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.
