C2090-600 IBM DB2 11.1 DBA for LUW
Test information:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 64%
Languages: English
DB2 Server Management (15%)
Configure and manage DB2 servers, instances, and databases
Create and manage database storage paths
Exploit autonomic features
Explain the functionality of WLM
Describe the capabilities of Data Server Manager
Physical Design (22%)
Implement BLU Acceleration
Describe DB2 pureScale enhancements
Create, manage, and alter DB2 objects
Demonstrate the proper use of compression
Describe the SQL compatibility available
Describe the partitioning capabilities available
Business Rules Implementation (10%)
Create and modify table constraints
Enforce constraint checking with the SET INTEGRITY command
Create and use triggers
Monitoring DB2 Activity (12%)
Demonstrate the proper use of monitoring tools
Use the DB2 Problem Determination tool (db2pd)
Describe the capabilities of dsmtop
Capture and analyze EXPLAIN information
Utilities (13%)
Demonstrate the proper use of DB2’s data movement utilities
Demonstrate the proper use of REORG, REORGCHK, REBIND, RUNSTATS, FLUSH PACKAGE CACHE, and ADMIN_CMD
Perform an INPLACE table REORG
Demonstrate the proper use of db2look and db2move
High Availability (13%)
Perform database-level and table space level backup and recovery operations
Configure and manage HADR
Implement a DB2 pureScale environment
Security (15%)
Explain the use of LDAP authentication
Create and use trusted contexts
Restrict access to sensitive data
Explain how to encrypt data in transit and data at rest
Configure and use the Audit facility
IBM Certified Database Administrator – DB2 11.1 for Linux, UNIX, and Windows
Job Role Description / Target Audience
This intermediate level certification is intended for those who understand the DB2 11.1 technology and have the skills required in the day-to-day administration of DB2 instances and databases. To attain the certification, candidates must pass two tests. To gain additional knowledge and skills, and prepare for the tests based on the job roles and test objectives, click on the link to the test below and refer to the Test Preparation tab,
QUESTION: No: 1
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST
database configuration parameter for a database named SAMPLE to AUTOMATIC?
A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
C. CONNECT TO sample; UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC
IMMEDIATE;CONNECT RESET;
D. ATTACH TO db2instI;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;
Answer: C
QUESTION: No: 2
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a
DB2 database? (Choose two.)
A. Catalog a storage access alias in the DB2 database
B. Create an FTP account on IBM Softlayer Object Storage
C. Use the DB2REMOTE parameter of the LOAD command
D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
E. Create a local disk alias at the database server operating system level that points to IBM Softlayer
Object Storage
Answer: A,C
QUESTION: No: 3
Which of the following statements about compression for BLU MPP tables is TRUE?
A. Compression must be explicitly enabled for BLU MPP tables
B. Compression requires decompression to evaluate partition joins
C. Unique compression dictionaries are generated for each partition
D. Each table has a single compression dictionary that getsreplicated across all partitions
Answer: D
QUESTION: No: 4
A production database has the following daily midnight backup schedule which includes all table spaces.
The database incurs the same volume of daily actMty (inserts, updates, and deletes).
Sunday – Delta
Monday – Incremental
Tuesday – Delta
Wednesday – Delta
Thursday- Incremental
Friday – Delta
Saturday- Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest
time to complete?
A. Friday
B. Monday
C. Saturday
D. Wednesday
Answer: A
Click here to view complete Q&A of C2090-600 exam
Certkingdom Review
Best IBM C2090-600 Certification, IBM C2090-600 Training at certkingdom.com