IBM DB2 9.7 Advanced DBA for LUW : C2090-544

  • Exam Code: C2090-544
  • Exam Name: DB2 9.7 Advanced DBA for LUW
  • Updated: Oct 08, 2026
  • Q & A: 106 Questions and Answers

PDF Version

PC Test Engine

Online Test Engine

Total Price: $59.99

About IBM C2090-544 Exam

In 2026, efficiency means starting fast and studying smart. The VCETorrent delivery flow gets 106 C2090-544 practice questions into your hands within minutes of payment.

IBM C2090-544 Exam Overview:

Certification Vendor:IBM
Exam Name:IBM DB2 9.7 Advanced Database Administrator for Linux, UNIX, and Windows
Exam Number:A2090-544
Exam Format:Multiple choice, Multiple response
Related Certifications:IBM Certified Database Administrator - DB2 9.7 for LUW
Exam Price:USD 200 (may vary by region)
Exam Duration:90 minutes
Real Exam Qty:64
Passing Score:60%
Certificate Validity Period:3 years
Available Languages:English
Recommended Training:IBM Learning for Data & AI
IBM DB2 9.7 for LUW Administration Training
Exam Registration:IBM Certification Portal
Pearson VUE IBM Exams
Sample Questions:Free Download C2090-544 Exam PDF Torrent
Exam Way:Test center or online proctored exam via authorized IBM testing provider (typically Pearson VUE)
Pre Condition:Recommended: IBM Certified Database Administrator - DB2 9.7 for LUW or equivalent hands-on experience with DB2 LUW administration.
Official Syllabus URL:https://www.ibm.com/training/certification

IBM C2090-544 Exam Syllabus Topics:

SectionObjectives
Topic 1: Utilities and Data Movement- Data reorganization and rebalancing
- LOAD, IMPORT, EXPORT utilities
Topic 2: Database Architecture and Concepts- Storage management concepts
- Memory structures and processes
- DB2 instance and database architecture
Topic 3: Security and Authorization- Roles, privileges, and authorities
- Authentication and authorization models
Topic 4: Database Administration and Configuration- Client connectivity and cataloging
- Database creation and maintenance
- Instance and database configuration parameters
Topic 5: Backup, Recovery, and High Availability- Backup and restore operations
- Rollforward recovery
- High Availability Disaster Recovery (HADR)
Topic 6: Performance Monitoring and Tuning- Query optimization and explain plans
- Indexing and statistics maintenance
- Monitoring tools and snapshot monitoring

Answers for C2090-544 Candidates

We keep our pricing preferential for candidates and run sales promotions on unfixed dates, often around major festivals. Regular customers across many countries already watch the site for these offers, and keeping an eye on the VCETorrent homepage is the easiest way to buy IBM DB2 9.7 Advanced DBA for LUW at a friendlier price.

C2090-544 requires 60% to pass, and the official exam fee is USD 200 (may vary by region). Knowing both numbers early helps you plan your exam date and budget together.

Everything runs online. As soon as you pay, our system records your information, encrypts it to protect your personal details from leaking, and sends the IBM DB2 9.7 Advanced DBA for LUW files to your registered email. The whole process takes only a few minutes, so you can begin studying almost immediately after payment.

The C2090-544 exam contains 64 questions within 90 minutes minutes. Rehearsing under the same time limit on the VCETorrent engine builds the pacing habits you will need.

  • Database Administration and Configuration ()
  • Utilities and Data Movement ()
  • Database Architecture and Concepts ()

Allocate your study hours in proportion to each topic's weight.

The package includes 106 practice questions for the C2090-544 exam, all with verified answers and available in three formats.

Recommended: IBM Certified Database Administrator - DB2 9.7 for LUW or equivalent hands-on experience with DB2 LUW administration.

IBM DB2 9.7 for LUW Administration Training: Visit official page

IBM Learning for Data & AI: Visit official page

IBM Certification Portal: register for C2090-544

Pearson VUE IBM Exams: register for C2090-544

IBM DB2 9.7 Advanced DBA for LUW Sample Questions:

Question #1

Which conditions must be met to implement HADR?

  • A. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  • B. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  • C. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).
  • D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
Reveal Solution  Discussion  0

Correct Answer: D  🗳️

Question #2

What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

  • A. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
    issue a SET TABLESPACE CONTAINERS command;
    issue a RESTORE DATABASE command with the CONTINUE option;
  • B. Issue a RESTORE DATABASE command with the REDIRECT option;
    issue a SET TABLESPACE CONTAINERS command;
    issue a RESTORE DATABASE command with the CONTINUE option;
  • C. Issue a RESTORE DATABASE command with the REDIRECT option;
    issue a RESTORE DATABASE command with the CONTINUE option;
  • D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
    issue a RESTORE DATABASE command with the CONTINUE option;
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Question #3

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? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
  • 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?
  • D. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Question #4

A primary and standby database are enabled for HADR and are in peer state. The HADR_SYNCMODE configuration parameter is set to SYNC. An application connects to the primary database, issues a COMMIT and receives a successful return code in response. How were the log buffers for this unit of work processed?

  • A. The log buffers were written to the DB2 log files on the primary server and sent to TCP/IP send buffer to be shipped to the standby server. The return code was then sent to the application.
  • B. The log buffers were written to the DB2 log files on the primary server and received in the log buffers on the standby database. The return code was then sent to the application.
  • C. The log buffers were written to the DB2 log files on the primary server, sent to the standby, and written to log files on the standby server. The return code was then sent to the application.
  • D. The log buffers were written to the DB2 log files on the standby server and held in memory on the primary server. The return code was then sent to the application.
Reveal Solution  Discussion  0

Correct Answer: C  🗳️

Question #5

Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

  • A. LIST LOGFILES
  • B. GET DATABASE CONFIGURATION
  • C. GET CURRENT ACTIVE LOGFILE
  • D. LIST INDOUBT TRANSACTIONS
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 106 questions.

5%

What Clients Say About Us

Searching for real exam dump is itself a painstaking work due to lots of site claiming they are the best in the business. But I found a reliable and most authenticate resource for all real exam dumps in the form of VCETorrent. Because I have already passed many exams using their dumps and this time I used C2090-544 study guide to become a certified specialist in my field again.

Odelette Odelette       4.5 star  

Passed the C2090-544 exam with the C2090-544 exam file though there are 2 same questions with different answers, i chose the latter one as they told me. More than enough to pass!

Joyce Joyce       5 star  

I passed my previous exam with just passing marks, which was not satisfactory. My friend told me to use VCETorrent real exam questions to practice for my next C2090-544 exam.

Nathan Nathan       4 star  

I have used the C2090-544 exam guide and can say for sure that it was my luck that got me to this website. Luckly, I passed last week.

Ella Ella       4 star  

Passed C2090-544 exam today! All the questions are valid and i suggest you should follow the answers.

Todd Todd       5 star  

C2090-544 training dump is very outstanding and I bought the APP online version. I passed the C2090-544 exam easily.

Rod Rod       4 star  

The C2090-544 exam dumps in VCETorrent are quite well and i passed my exam on 12/8/2018. Wonderful!

Noel Noel       4.5 star  

VCETorrent pdf dumps for C2090-544 are highly recommended to all who are appearing for the exam. Exam practise software really helps a lot in clearing the actual exam. I scored 94% marks.

Linda Linda       4 star  

I appreciate the quality of C2090-544 learning materials, and they are high quality.

Walter Walter       4 star  

To pass C2090-544 exam, I applied the easiest formula of VCETorrent. I learnt the content and basic information from VCETorrent guide

Marsh Marsh       5 star  

I purchased the study materials, but I always suspect the rightness of the exam questions. But you confirm that they were all the most valid questions. And I began to study hard then I truly got a successful pass. Thank you!

Peter Peter       4 star  

C2090-544 training questions are so easy to read there. I read them easily and I am very happy with the quality.

Noah Noah       5 star  

The questions in this C2090-544 exam dump are important for passing the exam. They are valid! You can buy and prapare with them.

Dawn Dawn       5 star  

I recommend you buy the C2090-544 exam dump for your exam preparation. I passed last week. It is really helpful!

John John       5 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Try Before You Buy

Download a free sample of any of our exam questions and answers
  • 24/7 customer support, Secure shopping site
  • Free One year updates to match real exam scenarios
  • If you failed your exam after buying our products we will refund the full amount back to you.

Quality and Value

VCETorrent 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 VCETorrent 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

VCETorrent 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.