Short on time before your C2090-614 exam date? The IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows question set from ActualCollection packs 110 practice questions into a format you can work through whenever a spare hour shows up. In 2026, plenty of busy professionals fit their prep into lunch breaks and commutes, and this material is built for exactly that.
IBM C2090-614 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Assessment: DB2 10.1 Advanced DBA for LUW |
| Exam Number: | A2090-614 |
| Exam Format: | Multiple response, Multiple choice |
| Available Languages: | English |
| Passing Score: | 60-70% |
| Related Certifications: | IBM DB2 for Linux, UNIX and Windows DBA certification IBM Certified Database Administrator - DB2 |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 55-65 |
| Exam Price: | $200 USD (approx.) |
| Certificate Validity Period: | 2 years |
| Recommended Training: | IBM DB2 for Linux, UNIX and Windows Training Courses |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: |  |
| Exam Way: | Online proctored or authorized test center |
| Pre Condition: | Recommended experience administering IBM DB2 for LUW databases; prior DBA knowledge strongly advised. |
IBM C2090-614 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Problem Determination and Troubleshooting | - Common DB2 issues and resolution techniques - Diagnostic tools and log analysis |
| Topic 2: Security Administration | - Authentication and authorization models - User roles, privileges, and auditing |
| Topic 3: Installation and Configuration | - Configuration parameters and environment tuning - DB2 installation planning and setup |
| Topic 4: Backup and Recovery | - Backup strategies and recovery planning - Restore operations and disaster recovery |
| Topic 5: Database Architecture and Administration | - Instance and database configuration management - DB2 LUW architecture components |
| Topic 6: Performance Monitoring and Tuning | - Performance monitoring tools and metrics - Query optimization and indexing strategies |
IBM C2090-614 Exam: Frequently Asked Questions
The IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam is the official IBM test registered under exam code C2090-614. Passing it earns you the IBM Certified Advanced Database Administrator - DB2 10.1 for LUW certification, a credential at the Professional level. It is also linked to the related certifications: IBM Certified Database Administrator - DB2, IBM DB2 for Linux, UNIX and Windows DBA certification. IBM exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam includes 55-65 questions to be completed within 90 minutes. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam you need 60-70%, and the official registration fee is $200 USD (approx.). A retake is not discounted: a failed attempt means paying the full $200 USD (approx.) again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
Recommended experience administering IBM DB2 for LUW databases; prior DBA knowledge strongly advised.
Eligibility rules do change from time to time, so confirm the current requirements before you register.
Registration for the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam goes through the official channels below.
As for the delivery format, the exam is taken Online proctored or authorized test center.
IBM points candidates toward the following training options for IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows.
Course work builds the foundation; question practice makes it stick. The 110 practice questions in the ActualCollection C2090-614 package let you rehearse each topic under exam-style pressure before the real thing.
Yes. ActualCollection offers a free PDF demo of the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and emailed to you within one minute of payment. If nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you may install the software on.
The official IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows syllabus is organized into 6 domains. Key areas include Backup and Recovery, Problem Determination and Troubleshooting, and Performance Monitoring and Tuning. The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
Question 1
Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?
A. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
B. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
Question 2
When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?
A. TIR (table/index data ratio); frequency of access; volatility of the data;
B. Frequency of access; redundancy of the data; acceptable access time;
C. Frequency of access; acceptable access time; volatility of the data.
D. Acceptable access time; redundancy of the data; volatility of the data.
Question 3
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
A. CREATE INDEX sales_idx ON sales (region, sales_person)
B. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
C. CREATE INDEX sales_idx ON sales (sales_person)
D. CREATE INDEX sales_idx ON sales (region)
Question 4
Which statement about data type mappings is true in a federated system?
A. Data types can be mapped in both directions between a remote and local data type.
B. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
C. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
D. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
Question 5
Given the following CREATE TABLE statement:
Which statement is correct?
A. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
C. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
Solutions:
| Question 1 Answer: A | Question 2 Answer: C | Question 3 Answer: A | Question 4 Answer: A | Question 5 Answer: A |
721 Customer Reviews
