We're so confident of our products that we provide no hassle product exchange.
IBM A2090-544 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | Assessment: DB2 9.7 Advanced DBA for LUW |
| Exam Number: | A2090-544 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for LUW IBM Certified Advanced Database Administrator - DB2 10.x/11.x for LUW |
| Real Exam Qty: | 60 - 106 |
| Certificate Validity Period: | Indefinite |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 60% - 70% |
| Exam Price: | USD 200 (may vary by region) |
| Available Languages: | English, Japanese |
| Recommended Training: | IBM DB2 9.7 Advanced Administration Training IBM DB2 9.7 Knowledge Center |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Registration |
| Sample Questions: | IBM A2090-544 Sample Questions |
| Exam Way: | In-person at Pearson VUE test centers / Online proctored |
| Pre Condition: | No mandatory prerequisites; recommended: 2+ years hands-on DB2 administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/A2090-544 |
IBM A2090-544 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Backup, Recovery & High Availability | 25% | - Log management and archiving - HADR and high availability solutions - Backup strategies and utilities - Restore and rollforward recovery |
| Topic 2: Security & Compliance | 15% | - Privilege management - Auditing and encryption - Authentication and authorization |
| Topic 3: Performance Tuning & Optimization | 25% | - Query optimization and access plans - Index design and maintenance - Sorting and memory tuning - Monitoring tools and advisors |
| Topic 4: Migration, Maintenance & Troubleshooting | 15% | - Upgrading to DB2 9.7 - Data movement and repartitioning - Problem determination and error resolution |
| Topic 5: Database Architecture & Configuration | 20% | - Storage management and table spaces - Memory management and STMM - Partitioned database environment - Instance and database configuration |
IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:
1. When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?
A) It is placed in the agent pool if the connection is terminated.
B) It remains active as long as the MAXAGENTS setting is not exceeded.
C) It automatically releases the database connection and returns to the pool.
D) It terminates immediately.
2. 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:16
B) DB2_PARALLEL_IO=7:64
C) DB2_PARALLEL_IO=7:7
D) DB2_PARALLEL_IO=7:32
3. Which command CANNOT be used to create the compression dictionary for a table?
A) IMPORT
B) INSPECT
C) RUNSTATS
D) LOAD
4. If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?
A) db2acsutil
B) db2apptrk
C) db2dart
D) db2pd
5. When the DBA chooses the dimensions for a multi-dimensional clustering (MDC) table, which two characteristics should be considered? (Choose two.)
A) prefetch size
B) numeric data versus character data
C) the combined cardinality of the candidate columns
D) extent size
E) the query transaction rate
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: C | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: C,D |
By Murray
