Introduction to IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows Exam

The IBM C2090-600 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the DB2 DBA for LUW certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the IBM DB2 11.1 DBA for LUW will help guide you through the study process for your certification.

C2090-600 IBM DB2 11.1 DBA for LUW Exam Summary

●     Exam Name: IBM DB2 11.1 DBA for LUW

●     Exam Code: C2090-600

●     Exam Price: $200 (USD)

●     Duration: 90 mins

●     Number of Questions: 60

●     Passing Score: 63%

●     Schedule Exam: Pearson VUE

●     Sample Questions: IBM DB2 DBA for LUW Sample Questions

●     Recommended Practice: IBM C2090-600 Certification Practice Exam

Exam Syllabus: C2090-600 IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows

1. 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

 

2. 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

 

3. Business Rules Implementation (10%)

- Create and modify table constraints

- Enforce constraint checking with the SET INTEGRITY command

- Create and use triggers

 

4. 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

 

5. 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

 

6. High Availability (13%)

- Perform database-level and table space level backup and recovery operations

- Configure and manage HADR

- Implement a DB2 pureScale environment

 

7. 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 C2090-600 Certification Sample Questions and Answers

To make you familiar with IBM DB2 11.1 DBA for LUW (C2090-600) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for DB2 DBA for LUW C2090-600 Certification to test your understanding of IBM C2090-600process with real IBM certification exam environment.

 

C2090-600 IBM DB2 11.1 DBA for LUW Sample Questions:-

 

01. Which operation can be performed with trusted context privileges that are acquired through a role?

a) DML operations

b) DDL operations

c) Server maintenance operations

d) Security administration operations

 

02. Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA?

(Choose two.)

a) XML

b) REAL

c) NUMBER

d) VRCHAR2

e) VARBINARY

 

03. What levels of authority are needed to create a storage group?

(Choose two.)

a) DBADM

b) SYSADM

c) SQLADM

d) SYSCTRL

e) SYSMAINT

 

04. What does dsmtop use to gather metrics?

a) db2pd

b) db2dart

c) the system catalog

d) monitoring table functions

 

05. For any given column-organized user table, the associated synopsis table may contain information for which of the following data types?

(Choose two.)

a) XML

b) BLOB

c) CLOB

d) VARCHAR

e) DATETIME

 

06. How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

a) Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

b)Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API.

c) Set the sort heap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

d) Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

 

07. Where does the DB2 Problem Determination tool (db2pd) get information from?

a) DB2memory sets

b) the db2diag.log file

c) Monitoring table functions

d) A set of pre-defined event monitors

 

08. You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

a) LOAD

b) INGEST

c) IMPORT

d) TRANSPORT

 

09. Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

a) When the registry variableDB2_AUTORECLAIMSPACE=YES

b) After termination all the back-end processes using TERMINATE command

c) After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON

d) When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

 

10. Which two of the following functions of DB2 Workload Manager are restricted by license?

(Choose two.)

a) Creating, using, or altering thresholds

b) Granting, altering, or revoking workload privileges

c) Using or altering the default service classes and workloads

d) Creating service classes, service subclasses, and workloads

e) Creating, activating, stopping or dropping workload management event monitors

 

Answers:-

Answer 1:- a

Answer 2:- c, d

Answer 3:- b, d

Answer 4:- d

Answer 5:- d, e

Answer 6:- b

Answer 7:- a

Answer 8:- a

Answer 9:- d

Answer 10:- a, d