C2090-600 IBM DB2 11.1 DBA for LUW Practice Exam Questions

C2090-600 IBM DB2 11.1 DBA for LUW


About IBM DB2 11.1 DBA for LUW

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,


Exam Prerequisites 

There are no prerequisites for the exam. 


Course Outline

1. DB2 Server Management

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

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

Create and modify table constraints

Enforce constraint checking with the SET INTEGRITY command

Create and use triggers

4. Monitoring DB2 Activity

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

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

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

Configure and manage HADR

Implement a DB2 pureScale environment

7. Security

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


Exam Pattern 

  • Exam Name: IBM DB2 11.1 DBA for LUW
  • Exam Code: C2090-600
  • Length of Time:  90 Minutes
  • Exam Questions: 60
  • Pass Score: 38/60


What do we offer?

  • Full-Length Mock Test with unique questions in each test set
  • Practice objective questions with section-wise scores
  • An in-depth and exhaustive explanation for every question
  • Reliable exam reports evaluating strengths and weaknesses
  • Latest Questions with an updated version
  • Tips & Tricks to crack the test
  • Unlimited access


What are our Practice Exams?

  • Practice exams have been designed by professionals and domain experts that simulate exam scenario.
  • Practice exam questions have been created on the basis of content outlined in the official documentation.
  • Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
  • Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
  • You can also create your own practice exam based on your choice and preference 


100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee! 

If you are not able to clear the exam, you can ask for a 100% refund.

Tags: C2090-600 IBM DB2 11.1 DBA for LUW Practice Exam, C2090-600 IBM DB2 11.1 DBA for LUW Exam Questions, C2090-600 IBM DB2 11.1 DBA for LUW Free Test, C2090-600 IBM DB2 11.1 DBA for LUW Exam Dumps