We're so confident of our products that we provide no hassle product exchange.
IBM A2090-544 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Assessment: DB2 9.7 Advanced DBA for LUW |
| Exam Number: | A2090-544 |
| Real Exam Qty: | 60 - 106 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for LUW IBM Certified Advanced Database Administrator - DB2 10.x/11.x for LUW |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | Indefinite |
| Exam Price: | USD 200 (may vary by region) |
| Passing Score: | 60% - 70% |
| Exam Format: | Multiple Choice, Multiple Response |
| Available Languages: | English, Japanese |
| Recommended Training: | IBM DB2 9.7 Knowledge Center IBM DB2 9.7 Advanced Administration Training |
| Exam Registration: | Pearson VUE IBM Registration IBM Certification Portal |
| Sample Questions: | IBM A2090-544 Sample Questions |
| Exam Way: | In-person at Pearson VUE test centers / Online proctored |
| Pre Condition: | No mandatory prerequisites; recommended: 2+ years hands-on DB2 administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/A2090-544 |
IBM A2090-544 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Performance Tuning & Optimization | 25% | - Query optimization and access plans - Sorting and memory tuning - Monitoring tools and advisors - Index design and maintenance |
| Database Architecture & Configuration | 20% | - Instance and database configuration - Partitioned database environment - Memory management and STMM - Storage management and table spaces |
| Migration, Maintenance & Troubleshooting | 15% | - Problem determination and error resolution - Data movement and repartitioning - Upgrading to DB2 9.7 |
| Security & Compliance | 15% | - Auditing and encryption - Authentication and authorization - Privilege management |
| Backup, Recovery & High Availability | 25% | - Restore and rollforward recovery - Log management and archiving - Backup strategies and utilities - HADR and high availability solutions |
IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:
Question #1
If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?
- A. The shared sort memory allocation will be controlled by DB2.
- B. No shared memory is allocated for sorting.
- C. All sorts will be done in shared memory.
- D. All sorts will be done in a temporary table space.
Answer: A
Question #2
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 (day)) - B. 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)) - C. 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)) - D. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))
Answer: D
Question #3
Which action can be performed by the ALTER TABLESPACE statement?
- A. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
- B. Change an SMS table space to a DMS table space on any database partition.
- C. Change the size of a container in an SMS table space.
- D. Add a container to an SMS table space on a database partition that currently has no containers.
Answer: D
Question #4
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 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 ROLLFORWARD option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option; - D. Issue a RESTORE DATABASE command with the REDIRECT option;
issue a RESTORE DATABASE command with the CONTINUE option;
Answer: B
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
Answer: B
By Rupert
