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