Test information:
Number of questions: 59
Time allowed in minutes: 90
Required passing score: 61%
Languages: English, Japanese
If you are knowledgeable with DB2 10.1 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
Section 1 – DB2 Server Management (10%)
Demonstrate the ability to configure/manage DB2 servers, instances, and databases
Demonstrate the ability to use autonomic features
Demonstrate the ability to use Data Studio
Demonstrate the ability to schedule jobs
Demonstrate the ability to use visual explain
Section 2 – Physical Design (26%)
Demonstrate the ability to create a database and manipulate various DB2 objects
How to convert existing db to automatic storage db
Admin_move_table feature
Demonstrate knowledge of partitioning capabilities
Demonstrate knowledge of XML data objects
Demonstrate knowledge of compression
Demonstrate knowledge of new table features
Knowledge of Multi-temperature data feature
Section 3 – Business Rules Implementation (8.5%)
Demonstrate the ability to create constraints on tables
Demonstrate the ability to create views WITH CHECK OPTION
Demonstrate the ability to create and using triggers
Demonstrate the ability to use the set integrity command
Section 4 – Monitoring DB2 Activity (10%)
Demonstrate the ability to use Admin views and SQL functions for monitoring
Knowledge of Work Load Manager monitoring features
Demonstrate the ability to use additional auto-monitoring tools
Demonstrate the ability to identify the functions of Problem Determination Tools
Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 – Utilities (14%)
Demonstrate the ability to use traditional data movement utilities
Demonstrate the ability to use the Ingest utility
Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities
Demonstrate the ability to use the DB2 Design Advisor utility
Section 6 – High Availability (10%)
Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery)
Demonstrate the ability to perform database-level and table space level backup and recovery operations
Demonstrate the ability to configure and manage HADR (read from standby)
Demonstrate knowledge of DB2 pureScale (HA features only)
Section 7 – Security (15%)
Describe DB2 authorizations and privileges
Knowledge of the security administrator role
Demonstrate general knowledge of the Audit facility
Demonstrate knowledge of the trusted context
Demonstrate knowledge of row column access control (RCAC)
Demonstrate knowledge of LBAC
Section 8 – Connectivity and Networking (6.5%)
Demonstrate the ability to configure database connectivity
Demonstrate knowledge of DB2 Discovery
Demonstrate knowledge of LDAP
QUESTION 1
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2
is reporting a “bad page”. DB2DART is performed for the entire database and it appears that
several bad pages were detected in table space TBSP_1. What command can be used to recover
the database and repair the corruption in table space TBSP_1?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
Explanation:
QUESTION 2
If a single node database is actively being used by applications when a power failure occurs, what
method is used to bring the database back to a consistent state once power has been restored?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
Explanation:
QUESTION 3
You have an High Availability and Disaster Recovery (HADR) environment set up and you want to
read from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the
new primary database.
Answer: A
Explanation:
QUESTION 4
Which command can be used to restore a corrupted database using only the recovery history file?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE DATABASE
D. ROLLFORWARD DATABASE
Answer: B
Explanation:
Click here to view complete Q&A of C2090-611 exam
Certkingdom Review
Best IBM C2090-611 Certification, IBM C2090-611 Training at certkingdom.com