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 |
| Passing Score: | 800 (scaled) |
| Real Exam Qty: | 106 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Related Certifications: | IBM Certified Advanced Database Administrator – DB2 9.7 for LUW C2090-544 DB2 9.7 Advanced DBA for LUW |
| Exam Format: | Multiple-choice, Knowledge assessment |
| Sample Questions: | IBM A2090-544 Sample Questions |
| Exam Way: | Delivered through IBM authorized assessment platform (often online or through testing center). |
| Pre Condition: | Designed for experienced DB2 administrators or those upgrading skills; typically requires deep knowledge of DB2 LUW advanced DBA topics. |
IBM A2090-544 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Performance and Monitoring | - Monitoring tools and metrics - Performance tuning techniques |
| Database Configuration and Management | - Database maintenance activities - Instance setup and configuration parameters |
| Security and Authorization | - Authentication and privileges - Role and security administration |
| DB2 9.7 Advanced DBA Architecture and Features | - Advanced architectural components - DB2 9.7 enhancements overview |
| Backup, Recovery and High Availability | - Backup and restore strategies - High availability disaster recovery concepts |
IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:
1. Click the Exhibit button.
Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?
A) CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC); CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC); RUNSTATS ON TABLE myschema.tab3;
B) CREATE INDEX idx98 ON tab3 (c6 ASC); CREATE INDEX idx99 ON tab3 (c9 DESC); RUNSTATS ON TABLE myschema.tab3;
C) CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
D) CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
2. Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
A) DB2_ALLOCATION_SIZE
B) DB2_LIMIT_AS_CONTAINER_BLOCKS
C) DB2_SET_MAX_CONTAINER_SIZE
D) DB2_TRUNCATE_AS_STORAGE
3. 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) db2pd
C) db2apptrk
D) db2dart
4. In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?
A) Changes to the HADR_TIMEOUT value will take effect immediately.
B) If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.
C) The HADR_TIMEOUT value must be identical on both the primary and the standby server.
D) If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.
5. Which command CANNOT be used to create the compression dictionary for a table?
A) RUNSTATS
B) LOAD
C) INSPECT
D) IMPORT
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: C | Question # 5 Answer: A |
By Marsh
