IBM C2090-614 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Installation, Upgrade, and Migration | - DB2 installation and fix pack management - Database migration strategies |
| Performance Tuning and Monitoring | - Monitoring tools and performance metrics - Query optimization and access plans |
| Backup and Recovery | - Backup strategies and tools - Crash recovery and rollforward recovery |
| Utilities and Maintenance | - Reorg and runstats operations - Load utilities and import/export tools |
| Database Architecture and Design | - Instance and database configuration concepts - DB2 architecture components |
| Security and Authorization | - Authentication and authorization models - Role-based access control and privileges |
| High Availability and Disaster Recovery | - Clustering and failover concepts - HADR configuration and administration |
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
Question #1
Which item is NOT eligible for adaptive compression?
A. Base tables
B. Indexes
C. Inline LOB values
D. Temporary tables
Question #2
A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?
A. db2dart
B. db2fmcu
C. db2diag
D. db2caem
Question #3
Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
A. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
B. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
C. Create a replicated summary table for the SALES table using the table space TS_REPL.
D. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
Question #4
In which situation would you NOT use a redirected restore?
A. To redefine the paths of a defined storage group.
B. To move table space containers onto different physical devices.
C. To restore a backup image to a target machine that is different from the source machine.
D. To restore a backup image from one operating system to another.
Question #5
Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
B. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
C. It can be used to merge offline backups to build full offline table space backups.
D. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
Solutions:
| Question #1 Correct Answer: D | Question #2 Correct Answer: C | Question #3 Correct Answer: A | Question #4 Correct Answer: D | Question #5 Correct Answer: A |
1190 Customer Reviews
Quality and ValueITCertKing 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 ApprovedWe 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 PassIf you prepare for the exams using our ITCertKing 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 BuyITCertKing 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.
