PDF for the printer, a Windows engine for the desk, an online engine for everything else. In 2026, ExamTorrent's IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows material for the C2090-614 exam adapts to your preferences, not the reverse.
IBM C2090-614 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 10.1 Advanced DBA for Linux, UNIX and Windows |
| Exam Number: | 000-614 / C2090-614 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Passing Score: | 60% |
| Exam Duration: | 90 minutes |
| Available Languages: | English, Japanese |
| Certificate Validity Period: | No fixed expiration (retired when product reaches end of support) |
| Real Exam Qty: | 54-60 |
| Exam Format: | Multiple answers, Multiple choice, Single answer |
| Related Certifications: | IBM Certified Database Administrator – DB2 10.1 for Linux, UNIX and Windows IBM Certified Advanced Database Administrator – DB2 10.5 for Linux, UNIX and Windows |
| Recommended Training: | IBM DB2 10.1 Advanced Administration Training IBM Knowledge Center DB2 10.1 |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | ![]() |
| Exam Way: | In-person at Pearson VUE test centers / Online proctored exam |
| Pre Condition: | No mandatory prerequisites; recommended 2+ years of hands-on DB2 10.1 administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/certs/c2090-614 |
IBM C2090-614 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Data Partitioning and Clustering | 20% | - Multi-dimensional Clustered (MDC) tables - Insert Time Clustering (ITC) tables - Range Clustered Tables (RCT) - Database Partitioning Feature (DPF) - Range-partitioned tables |
| Advanced Concepts | 15% | - Federated database access - Advanced maintenance operations - Replication solutions - DB2 pureScale environment |
| High Availability and Diagnostics | 24% | - Advanced backup strategies - Diagnostic tools and log analysis - Advanced restore and recovery operations - Workload Manager (WLM) - High Availability Disaster Recovery (HADR) - Log management and recovery |
| Database Design | 17% | - Table spaces (SMS, DMS, automatic storage) - Storage paths and storage groups - Buffer pools configuration - Database management with Data Studio - Multi-temperature data design |
| Performance and Security | 24% | - Auditing and security controls - Index design and optimization - Query optimization and access plans - Authorization, privileges, and roles - Configuration and tuning parameters - Monitoring and performance analysis |
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows FAQ: The Useful Parts
First-line service, around the clock: free online consultation whenever a question stalls you, remote guidance for installation or usage issues, and clear answers to content questions by email. On privacy, the rules are rigid — transactions are secured by McAfee security services, purchase information is never disclosed to third parties, and no spam or telemarketing follows your order.
The figures in the overview table above turn into strategy once you treat them as a budget: total time divided by total questions is your per-item allowance, and anything costing double gets flagged for a final sweep instead of a mid-exam standoff. Build the habit under a live timer — ExamTorrent's engine sessions enforce one — so the real clock feels like a rehearsal, not a surprise.
The blueprint above spans 5 domains — treat its weightings as a budget. A domain worth 24% of the score earns a matching share of your week, while lighter areas like Data Partitioning and Clustering get maintained, not marathoned. Walk the full topic list domain by domain, and let the percentages decide where your practice hours land first.
Think of the C2090-614 exam as IBM asking for proof, not promises: pass it, and you hold the IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, UNIX and Windows certification, a credential at the Advanced level. The questions are built to measure applied skill across the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows objectives — the kind employers hire for. It also sits within a broader certification family covering IBM Certified Database Administrator – DB2 10.1 for Linux, UNIX and Windows, IBM Certified Advanced Database Administrator – DB2 10.5 for Linux, UNIX and Windows, so one exam's effort keeps paying into the next.
Yes. ExamTorrent's free IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows PDF demo contains genuine sample questions with verified answers, so you can judge the quality with your own eyes. Every purchase includes 365 days of free updates, and renewing after expiry costs 50% of the regular price from your member zone. Judge first — material this confident has nothing to hide.
Work in passes, not one grind. First pass: untimed, through all 110 questions, marking weak domains against the blueprint above. Second pass: timed engine sessions, reviewing every error the same day while the reasoning is fresh. Final pass: re-test only your flagged items until they stop being wrong. Book the exam when your timed scores hold steady — not when your calendar gets impatient.
The fee shown above is the price of one attempt — and of every retake, at full price. So the passing score is best treated as a floor you clear with margin: work through ExamTorrent practice questions until your timed results sit comfortably above it several sessions in a row, then register. Hours of over-preparation are cheaper than a second registration.
The same 110 expert-written questions ship in all three — you're choosing how you want to live with the material:
- PDF version — the most popular choice: printable, instantly downloadable, ready for handwritten notes anywhere.
- Desktop Test Engine — for Windows users: recreates the real exam atmosphere with two practice modes and full offline access.
- Online Test Engine — app-like access from any browser on Windows, Mac, Android, or iOS, with test history and performance review.
Each version has its own strengths; many candidates mix them — PDF for reading, an engine for timed rehearsal.
Delivery first: your IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows practice questions are downloadable immediately and emailed within one minute of payment — if 2 hours pass, check spam and contact support. Install on as many computers as you need. If the exam goes wrong, the 100% Money Back Guarantee applies under clear conditions: take the corresponding exam within 60 days of purchase, and if you don't pass, submit a scanned enrollment slip and your official Score Report PDF within 2 days after the exam — full refunds process within 7 days. Not eligible: attempts within 3 days of purchase, exams never actually taken, free items, and expired orders; candidate name must match payer name. Prefer to keep going? Exchange for two free products of equal value and keep your update service.
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
- A. Create a replicated summary table for the SALES table using the table space TS_REPL.
- B. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
- C. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
- D. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
Correct Answer: C 🗳️
What values can be assigned to the HADR_SYNCMODE configuration parameter?
- A. SYNC, ASYNC, SEMISYNC, and SUPERASYNC
- B. SYNC, NOSYNC, ASYNC, and SUPERASYNC
- C. SYNC, NEARSYNC, ASYNC, and NOSYNC
- D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC
Correct Answer: D 🗳️
To configure instance-level auditing with db2audit, which authority is required?
- A. SYSADM
- B. SECADM
- C. SYSMAINT
- D. SYSCTRL
Correct Answer: A 🗳️
On which two operating systems can DB2 pureScale run? (Choose two.)
- A. AIX
- B. Windows
- C. Solaris
- D. Linux
- E. HP-UX
Correct Answer: A,D 🗳️
Given the following CREATE TABLE statement:
Which statement is correct?
- A. A range-clustered table is created and only values from 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 values outside the range of 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.
Correct Answer: C 🗳️
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 110 questions.







1062 Customer Reviews

