Need an invoice for the company books? Email us your company name and we make a custom invoice to your demand. ExamTorrent's IBM DB2 9.7 Advanced DBA for LUW set — 106 practice questions for the C2090-544 exam — is business-friendly too.
IBM C2090-544 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9.7 Advanced DBA for LUW |
| Exam Number: | 000-544 / C2090-544 |
| Real Exam Qty: | 70 |
| Exam Format: | Multiple Response, Multiple Choice, Scenario-based |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Available Languages: | Japanese, English |
| Related Certifications: | IBM Certified Advanced Database Administrator – DB2 10.1/11.1 for LUW IBM Certified Database Administrator – DB2 9.7 for LUW |
| Passing Score: | 65% |
| Exam Price: | Approx. $200 USD / €180 EUR |
| Recommended Training: | IBM DB2 9.7 Knowledge Center IBM Education: DB2 9.7 Advanced Administration |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: |  |
| Exam Way: | Online proctored or Onsite at Pearson VUE authorized test centers |
| Pre Condition: | Recommended: IBM Certified Database Administrator – DB2 9.7 for LUW (000-541) or equivalent experience; no formal prerequisites |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/exam00544.shtml |
IBM C2090-544 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performance and Optimization | 25% | - Monitoring and analysis
|
| Topic 2: Backup, Recovery, and Maintenance | 18% | - Utilities and maintenance
|
| Topic 3: Database Design and Implementation | 20% | - Database creation and configuration
|
| Topic 4: Security and Compliance | 12% | - Authentication and authorization
|
| Topic 5: High Availability and Scalability | 20% | - Partitioned database environments
|
| Topic 6: Problem Determination and Support | 5% | - Diagnostic tools
|
IBM DB2 9.7 Advanced DBA for LUW Exam FAQ — Reliable Answers
Yes — download the free IBM DB2 9.7 Advanced DBA for LUW demo and inspect the material before buying. Purchases include the right of free updating for 365 days, with latest versions emailed promptly upon release; renew afterward at 50% off.
Approx. $200 USD / €180 EUR per attempt, 65% to pass. For busy professionals, one prepared attempt beats two rushed ones — work through the 106 practice questions for the C2090-544 exam at ExamTorrent first.
The IBM DB2 9.7 Advanced DBA for LUW blueprint covers 6 domains — including High Availability and Scalability (20%), Backup, Recovery, and Maintenance (18%), Problem Determination and Support (5%). Budget your limited hours by weighting; the complete outline above lists every subtopic.
Through the vendor's official registration channels:
The IBM DB2 9.7 Advanced DBA for LUW is delivered Online proctored or Onsite at Pearson VUE authorized test centers — pick the arrangement that fits your calendar when booking.
The IBM DB2 9.7 Advanced DBA for LUW is IBM's certification exam for IBM Certified Advanced Database Administrator – DB2 9.7 for Linux, UNIX and Windows, at the Advanced level. It's among the most authoritative credentials in the field — for those aiming at IBM careers, it's the first step. Related credentials include IBM Certified Database Administrator – DB2 9.7 for LUW, IBM Certified Advanced Database Administrator – DB2 10.1/11.1 for LUW.
Files arrive by automatic email within a minute of payment — unlimited devices, and 24/7 customer assisting if nothing shows up within 2 hours (check spam). Need an invoice? Email us your company name for a custom invoice made to your demand. If you fail the corresponding C2090-544 exam within 60 days of purchase, we process a full refund within 7 days — send a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products. Alternatively, exchange for two equal-value products free.
Recommended: IBM Certified Database Administrator – DB2 9.7 for LUW (000-541) or equivalent experience; no formal prerequisites Vendors update eligibility rules over time, so verify the current requirements on the official page (official C2090-544 exam page) before registering.
Yes:
Official training teaches; practice proves. After any course, review with the 106 practice questions for the IBM DB2 9.7 Advanced DBA for LUW — answers expert-verified.
90 minutes for 70 questions. Time-pressed candidates should rehearse the clock: short timed sets on busy days, full simulations on free ones.
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
Which command CANNOT be used to explicitly build a compression dictionary for a table?
- A. LOAD
- B. REORG
- C. IMPORT
- D. INSPECT
Correct Answer: C 🗳️
The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?
- A. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day)) - B. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year)) - C. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (day)) - D. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
Correct Answer: B 🗳️
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
- A. SECADM authority
- B. EXECUTE privilege on audit routines with DATA
- C. EXECUTE privilege on audit routines with NO DATA
- D. DBADM authority
- E. SYSADM authority
Correct Answer: A,B 🗳️
A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?
- A. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
- B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
- C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
- D. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
Correct Answer: B 🗳️
What is a method for enabling non-buffered I/O at the table space level in a DB2 database?
- A. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.
- B. Set the DB2_DIRECT_IO configuration parameter to YES.
- C. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
- D. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
Correct Answer: C 🗳️
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 106 questions.
Vic 
Charlotte 
Sidney 
Tabitha 
Jack 
Troy 
Mandel 
Ryan 
Maxine 
Adair 
Adolph 
Todd 
Haley 
