We're so confident of our products that we provide no hassle product exchange.
IBM C2090-544 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | Assessment: DB2 9.7 Advanced DBA for LUW |
| Exam Number: | A2090-544 |
| Related Certifications: | IBM Certified Advanced Database Administrator – DB2 9.7 for LUW C2090-544 DB2 9.7 Advanced DBA for LUW |
| Real Exam Qty: | 106 |
| Passing Score: | 800 (scaled) |
| Exam Format: | Multiple-choice, Knowledge assessment |
| Exam Duration: | 120 minutes |
| Available Languages: | English |
| Sample Questions: | IBM C2090-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 C2090-544 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Security and Authorization | - Authentication and privileges - Role and security administration |
| Topic 2: Database Configuration and Management | - Database maintenance activities - Instance setup and configuration parameters |
| Topic 3: Performance and Monitoring | - Performance tuning techniques - Monitoring tools and metrics |
| Topic 4: Backup, Recovery and High Availability | - High availability disaster recovery concepts - Backup and restore strategies |
| Topic 5: DB2 9.7 Advanced DBA Architecture and Features | - DB2 9.7 enhancements overview - Advanced architectural components |
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
1. Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
A) RELEASE FREE BLOCKS ONLY
B) RELEASE FREE EXTENTS ONLY
C) RECLAIM EXTENTS ONLY
D) RECLAIM FREE BLOCKS
2. Which tool or command will display only the automatic storage paths in an existing backup image?
A) db2ckbkp
B) INSPECT
C) db2dart
D) db2pd
3. Given the following output from the GET DATABASE CONFIGURATION command:
Which of the following DB configurations listed below will enable circular logging?
A) LOGSECOND=-1
B) LOGRETAIN=CIRCULAR
C) LOGARCHMETH1=OFF and LOGARCHMETH2=OFF
D) LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF
4. An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)
A) The DB2COMM environment variable at the server is not set to TCPIP.
B) The client's authentication type is not compatible with the server.
C) The server node and/or database are not cataloged correctly on the client.
D) The port number is not assigned in the server's services file.
E) The DB2 Administration Server is not started.
5. Which statement is correct about statistical views?
A) A statistical view provides the optimizer with additional correlation statistics.
B) A statistical view holds information about the system catalog statistical tables.
C) A statistical view is created by executing runstats on a regular view.
D) A statistical view provides the optimizer with more accurate cardinality estimates.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: A,C | Question # 5 Answer: D |
By Magee
