IBM DB2 C2090-614

Why wait for shipping? The moment your order is confirmed, Getcertkey emails the C2090-614 practice questions to your inbox, usually within a minute. You could be working through the 110 questions for the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam tonight.

IBM C2090-614 Exam Overview:

Certification Vendor:	IBM
Exam Name:	DB2 10.1 Advanced DBA for Linux UNIX and Windows
Exam Number:	C2090-614
Available Languages:	English
Exam Format:	Multiple choice
Related Certifications:	IBM Certified Database Associate - DB2 10.1 Fundamentals IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows
Real Exam Qty:	108
Sample Questions:
Exam Way:	Onsite testing via Pearson VUE or IBM authorized test centres
Pre Condition:	Recommended to have DB2 10.1 DBA experience and have passed foundational DB2 exams (C2090-610, C2090-611)
Official Syllabus URL:	https://www.ibm.com/training/certification/ibm-certified-database-administrator-db2-101-for-linux-unix-and-windows-08002107

IBM C2090-614 Exam Syllabus Topics:

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam FAQ: What Candidates Ask Most

What is the IBM C2090-614 exam?

The C2090-614 exam is the official IBM exam behind the DB2 certification, validating the skills measured by the IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows credential. It sits at the Advanced level of the IBM certification program. It also connects to IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows, IBM Certified Database Associate - DB2 10.1 Fundamentals, so the knowledge you build here carries over to those tracks as well.

Are there any prerequisites for the C2090-614 exam?

Recommended to have DB2 10.1 DBA experience and have passed foundational DB2 exams (C2090-610, C2090-611) Requirements can change when IBM revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the C2090-614 practice questions before I buy?

Yes. Getcertkey provides a free C2090-614 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if IBM revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the C2090-614 exam, and how is my order delivered?

Every IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the C2090-614 exam?

The IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows exam blueprint is organized into 4 domains. The first three are:

• Advanced Concepts
• Database Design and Object Management
• Performance and Scalability

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:

Question #1
Consider the following statement:

Which indexes should be created for optimal query performance?

A. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname);

Question #2
Which is NOT a valid method for prefetching data?

A. Sequential detection prefetching
B. Smart data prefetching
C. Read-ahead prefetching
D. Consecutive prefetching

Question #3
Which Range-Clustered Tables (RCT) statement is correct?

A. The IMPORT utility can be used with the REPLACE option to populate RCTs.
B. Reverse scans on RCTs are not supported.
C. The Design Advisor can recommend the use of RCTs.
D. Clustering indexes are compatible with RCTs.

Question #4
A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:

IBM 000-614 : Practice Test
The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?

A. Reduce the size of the BP_AUDITING buffer pool.
B. Increase the size of the BP_AUDITING buffer pool.
C. Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.
D. Replace the BP_AUDITING buffer pool with a block-based buffer pool.

Question #5
What is a benefit of multi-temperature data storage?

A. It helps improve data compression ratios.
B. It helps reduce redundant I/O.
C. It helps identify data access patterns to aid in storage planning.
D. It helps reduce storage costs for infrequently accessed data.

Solutions: