We're so confident of our products that we provide no hassle product exchange.
IBM A2090-541 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM DB2 9.7 DBA for Linux, UNIX and Windows |
| Exam Number: | C2090-541 |
| Certificate Validity Period: | 2 years |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 60 |
| Related Certifications: | IBM Certified Database Associate - DB2 IBM Certified Advanced Database Administrator - DB2 |
| Exam Price: | USD 200 (varies by region) |
| Exam Format: | Multiple choice, Multiple response |
| Available Languages: | English |
| Passing Score: | 60% |
| Recommended Training: | IBM DB2 9.7 Database Administration Training |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | IBM A2090-541 Sample Questions |
| Exam Way: | Computer-based exam delivered at authorized testing centers or online proctored exam (availability varies by region) |
| Pre Condition: | Basic knowledge of relational database concepts and DB2 fundamentals is recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM A2090-541 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Security and Authorization | - Authentication and authorization
|
| Monitoring and Performance Tuning | - Performance monitoring
|
| Installation and Configuration | - DB2 installation
|
| DB2 Architecture and Concepts | - Data organization
|
| Database Operations and Utilities | - Backup and recovery
|
IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
1. Which set of procedures will be required to perform a rolling upgrade in a HADR environment?
A) 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
B) 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the standby database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
C) 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
D) 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the new primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
2. What are three system and database level authorizations available with DB2? (Choose three.)
A) SYSMON
B) DBADM
C) SYS ADM
D) SYSMNT
E) DBCTRL
3. The event monitor for transactions has been replaced in DB2 9.7 with which tool?
A) db2evmonfmt
B) MON_GET_ACTIVITY_DETAILS table function
C) db2top
D) MON_GET_WORKLOAD table function
4. Click the Exhibit button
Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?
A) UPDATE DBM CFG USING NOTIFYLEVEL4
B) UPDATE DBM CFG USING DI AG LEVEL 4
C) UPDATE DBM CFG USING NOTIFYLEVEL 4; STOP DATABASE MANAGER; START DATABASE MANAGER;
D) UPDATE DBM CFG USING DIAGLEVEL 3; UPDATE DBM CFG USING NOTIFYLEVEL 4;
5. Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format.
Which command(s) can be used to do this?
A) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;
B) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b
C) EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b
D) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: A,B,C | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: D |
By Gilbert
