We're so confident of our products that we provide no hassle product exchange.
IBM C2090-544 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | DB2 9.7 Advanced DBA for LUW |
| Exam Number: | 000-544 / C2090-544 |
| Passing Score: | 65% |
| Exam Duration: | 90 minutes |
| Available Languages: | English, Japanese |
| Certificate Validity Period: | 3 years |
| Exam Format: | Multiple Choice, Multiple Response, Scenario-based |
| Related Certifications: | IBM Certified Database Administrator – DB2 9.7 for LUW IBM Certified Advanced Database Administrator – DB2 10.1/11.1 for LUW |
| Real Exam Qty: | 70 |
| Exam Price: | Approx. $200 USD / €180 EUR |
| Recommended Training: | IBM Education: DB2 9.7 Advanced Administration IBM DB2 9.7 Knowledge Center |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | IBM C2090-544 Sample Questions |
| Exam Way: | Online proctored or Onsite at Pearson VUE authorized test centers |
| Pre Condition: | Recommended: IBM Certified Database Administrator – DB2 9.7 for LUW (000-541) or equivalent experience; no formal prerequisites |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/exam00544.shtml |
IBM C2090-544 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Database Design and Implementation | 20% | - Database creation and configuration
|
| High Availability and Scalability | 20% | - Partitioned database environments
|
| Security and Compliance | 12% | - Auditing and encryption
|
| Backup, Recovery, and Maintenance | 18% | - Utilities and maintenance
|
| Problem Determination and Support | 5% | - Diagnostic tools
|
| Performance and Optimization | 25% | - Tuning and optimization
|
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
1. Which command CANNOT be used to explicitly build a compression dictionary for a table?
A) IMPORT
B) INSPECT
C) LOAD
D) REORG
2. What is the minimum authority required to execute the LOAD command?
A) DATAACCESS
B) SQLADM
C) ACCESSCTRL
D) SYSCTRL
3. In which two environments would intra-partition parallelism be used? (Choose two.)
A) Multiple database partitions, multiple processor cores
B) Single database partition, multiple processor cores
C) Multiple database partitions, single processor core
D) Single database partition, single processor core
4. Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option?
A) Attempt to create the buffer pool and immediately request additional instance level memory. If the instance level memory is not available, then creation of the buffer pool is deferred until the database is stopped and restarted.
B) Attempt to create the buffer pool and immediately allocate the memory requested from available database shared memory. If the memory available is not sufficient, then allocation of the buffer pool will be deferred until the database is stopped and restarted.
C) Attempt to create the buffer pool and immediately allocate the memory requested, resizing the existing buffer pools and heaps as required. If there is insufficient memory in the global memory allocation for DB2, the buffer pool will not be created.
D) Attempt to create the buffer pool and immediately request additional memory from the operating system to allocate. If the operating system memory is not available, the buffer pool will not be created.
5. Given the following table definition in a multi-partitioned database:
Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?
A) SS_ID
B) EMP_ID
C) SS_ID, EMP_ID, and NAME
D) NAME
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A | Question # 3 Answer: A,B | Question # 4 Answer: B | Question # 5 Answer: A |
By Merlin
