Everyone studies differently, so ActualCollection offers the IBM Assessment: DB2 9.7 Advanced DBA for LUW prep material in three formats: a printable PDF, a desktop test engine for Windows, and an online test engine that runs in any browser. All three carry the same 106 practice questions.
IBM A2090-544 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 9.7 Advanced Database Administrator for LUW |
| Exam Number: | C2090-544 |
| Certificate Validity Period: | 3 years (typical IBM certification validity) |
| Related Certifications: | IBM Certified Database Administrator - DB2 IBM Certified Database Associate - DB2 |
| Exam Format: | Multiple choice |
| Available Languages: | English |
| Recommended Training: | IBM Skills Gateway IBM DB2 9.7 Administration Training |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exams |
| Sample Questions: |  |
| Exam Way: | Delivered via Pearson VUE testing centers or online proctored exam (availability may vary by region) |
| Pre Condition: | Recommended prior experience with IBM DB2 administration; completion of IBM Certified Database Associate or Administrator certification is recommended but not strictly required. |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM A2090-544 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Backup and Recovery | - Recovery strategies
|
| High Availability and Utilities | - DB2 utilities and maintenance
|
| Storage Management | - Tablespaces and storage structures
|
| Security and Authorization | - Authentication and authorization mechanisms
|
| Database Installation and Configuration | - Installation planning and setup
|
| DB2 Architecture and Concepts | - DB2 instance and database structure
|
| Performance Tuning and Monitoring | - Query optimization and tuning
|
Common Questions About the IBM Assessment: DB2 9.7 Advanced DBA for LUW Exam
The IBM Assessment: DB2 9.7 Advanced DBA for LUW exam is the official IBM test registered under exam code A2090-544. Passing it earns you the IBM Certified Advanced Database Administrator - DB2 9.7 for Linux, UNIX, and Windows certification, a credential at the Professional level. It is also linked to the related certifications: IBM Certified Database Associate - DB2, IBM Certified Database Administrator - DB2. IBM exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
Recommended prior experience with IBM DB2 administration; completion of IBM Certified Database Associate or Administrator certification is recommended but not strictly required.
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Registration for the IBM Assessment: DB2 9.7 Advanced DBA for LUW exam goes through the official channels below.
As for the delivery format, the exam is taken Delivered via Pearson VUE testing centers or online proctored exam (availability may vary by region).
IBM points candidates toward the following training options for IBM Assessment: DB2 9.7 Advanced DBA for LUW.
Course work builds the foundation; question practice makes it stick. The 106 practice questions in the ActualCollection A2090-544 package let you rehearse each topic under exam-style pressure before the real thing.
Yes. ActualCollection offers a free PDF demo of the IBM Assessment: DB2 9.7 Advanced DBA for LUW 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 Assessment: DB2 9.7 Advanced DBA for LUW 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 Assessment: DB2 9.7 Advanced DBA for LUW syllabus is organized into 7 domains. Key areas include Storage Management, Security and Authorization, and Performance Tuning and Monitoring. 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 Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:
Question 1
Which action(s) will cause a compression dictionary to be removed from a table?
A. Set the table COMPRESS attribute to NO; run INSPECTESETDICTIONARY against the table.
B. Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
C. Set the table COMPRESS attribute to NO.
D. Set the table COMPRESS attribute to NO; run REORG against the table.
Question 2
What is required to successfully use the check backup utility (db2ckbkp)?
A. system maintenance authority
B. read permission on the database
C. system administrator authority
D. read permission on the backup image
Question 3
Which command will prevent prefetching during crash recovery?
A. db2set DB2_RECOVERY_PREFETCHING=NO
B. db2set DB2_RECOVERY_PREFETCHING=YES
C. db2set DB2_AVOID_PREFETCH=OFF
D. db2set DB2_AVOID_PREFETCH=ON
Question 4
A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?
A. UPDATE DBM CFG USING NUM_POOLAGENTS 200;
db2stop;
db2start;
B. UPDATE DBM CFG USING NUM_INITAGENTS 200;
db2stop;
db2start;
C. UPDATE DBM CFG USING NUM_POOLAGENTS 0;
db2stop;
db2start;
D. UPDATE DBM CFG USING NUM_INITAGENTS 0;
db2stop;
db2start;
Question 5
Given the following table definition in a multi-partitioned database:
Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?
A. NAME
B. SS_ID
C. EMP_ID
D. SS_ID, EMP_ID, and NAME
Solutions:
| Question 1 Answer: D | Question 2 Answer: D | Question 3 Answer: D | Question 4 Answer: A | Question 5 Answer: B |
1377 Customer Reviews
