IBM A2090-614 : Assessment: DB2 10.1 Advanced DBA for LUW
- Exam Code: A2090-614
- Exam Name: Assessment: DB2 10.1 Advanced DBA for LUW
- Updated: Oct 24, 2026 Q&As: 110 Questions and Answers
About IBM A2090-614 Exam
A study bundle only helps when it mirrors the real thing, and the IBM Assessment: DB2 10.1 Advanced DBA for LUW materials at DumpsTests recreate the A2090-614 exam's format and timing so your practice sessions feel like rehearsal, not guesswork.
IBM A2090-614 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 10.1 Advanced DBA for Linux UNIX and Windows |
| Exam Number: | C2090-614 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Exam Format: | Scenario-based questions, Multiple choice |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 54-60 |
| Related Certifications: | IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX and Windows |
| Passing Score: | 60% |
| Certificate Validity Period: | Valid until retired; exam retired December 31, 2021 |
| Available Languages: | Japanese, English |
| Recommended Training: | IBM Education: DB2 10.1 Advanced Administration |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: |  |
| Exam Way: | Proctored onsite at Pearson VUE test centers; online proctoring not available |
| Pre Condition: | No formal prerequisites; recommended: significant experience as senior DBA with DB2 10.1 |
| Official Syllabus URL: | https://www.ibm.com/certify/exam?id=C2090-614 |
IBM A2090-614 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Advanced Concepts | 15% | - Replication technologies - Federated database configuration - DB2 pureScale environment - Audit facility and security management |
| Database Design | 17% | - Use IBM Data Studio for database management - Design, create and manage buffer pools - Configure multi-temperature data storage - Design, create and manage table spaces - Design, create and manage storage groups and storage paths |
| Performance and Scalability | 24% | - Performance monitoring and troubleshooting - Index design and maintenance - Query optimizer and access plan analysis - Memory and I/O tuning for instance and database - Data and index compression techniques |
| High Availability and Diagnostics | 24% | - High Availability Disaster Recovery (HADR) configuration - Diagnostic tools and problem determination - Workload Manager (WLM) implementation - Advanced backup and restore operations - Log management and recovery architecture |
| Data Partitioning and Clustering | 20% | - Insert Time Clustering (ITC) tables - Implement multi-dimensional clustering (MDC) - Range partitioning and attached/detached partitions - Range Clustering Tables (RCT) - Design and manage Database Partitioning Feature (DPF) |
Your IBM Assessment: DB2 10.1 Advanced DBA for LUW Preparation Questions, Answered
- Advanced Concepts (15%)
- Performance and Scalability (24%)
- High Availability and Diagnostics (24%)
IBM Assessment: DB2 10.1 Advanced DBA for LUW Sample Questions:
The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)
- A. MAXAPPLS
- B. MAXLOCKS
- C. MAXAGENTS
- D. LOCKTIMEOUT
- E. LOCKLIST
Correct Answer: B,E 🗳️
Given the following output:
Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
- A. EXPLAIN_FROM_CATALOG
- B. EXPLAIN_FROM_DATA
- C. EXPLAIN_FROM_SECTION
- D. EXPLAIN_FROM_ACTIVITY
Correct Answer: D 🗳️
With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?
- A. The primary database only.
- B. The primary, auxiliary standby, and principal standby database.
- C. The auxiliary standby database only.
- D. The principal standby database only.
Correct Answer: D 🗳️
Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?
- A. FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
- B. FEDERATED set to YES
- C. FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
- D. FEDERATED set to YES FED_NOAUTH set to YES
Correct Answer: A 🗳️
Which statement about compression dictionaries is FALSE?
- A. Page-level dictionaries are stored in hidden rows within the table.
- B. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
- C. Table-level dictionaries are stored in hidden rows within the table.
- D. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
Correct Answer: B 🗳️
Explanation: Only visible for DumpsTests members. You can sign-up / login (it's free).
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 110 questions.
Related Exam
Related Certifications
Over 68733+ Satisfied Customers
What Clients Say About Us
Quality and Value
DumpsTests Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and Approved
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to Pass
If you prepare for the exams using our DumpsTests testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before Buy
DumpsTests offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
Use our training practice dumps with real exam questions & answers. Freely download the valid test study torrent, and start your preparation with no time wasted. 100% pass guaranteed is our promise. No help, full refund.