1. Home
  2. IBM
  3. C2090-600 Exam Syllabus

IBM C2090-600 Exam Topics

IBM C2090-600 Exam

IBM DB2 11.1 DBA for LUW

Total Questions: 60

What is Included in the IBM C2090-600 Exam?

Authentic information about the syllabus is essential to go through the IBM C2090-600 exam in the first attempt. Study4Exam provides you with comprehensive information about IBM C2090-600 exam topics listed in the official syllabus. You should get this information at the start of your preparation because it helps you make an effective study plan. We have designed this IBM certification exam preparation guide to give the exam overview, practice questions, practice test, prerequisites, and information about exam topics that help to go through the IBM DB2 11.1 DBA for LUW exam. We recommend you use our preparation material to cover the entire IBM C2090-600 exam syllabus. Study4Exam offers 3 formats of IBM C2090-600 exam preparation material. Each format provides new practice questions in PDF format, web-based and desktop practice exams to get passing marks in the first attempt.

IBM C2090-600 Exam Overview :

Exam Name IBM DB2 11.1 DBA for LUW
Exam Code C2090-600
Actual Exam Duration 90 minutes
Expected no. of Questions in Actual Exam 60
Official Information https://www-03.ibm.com/certify/exam.html?id=C2090-600
See Expected Questions IBM C2090-600 Expected Questions in Actual Exam
Take Self-Assessment Use IBM C2090-600 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

IBM C2090-600 Exam Topics :

Section Weight Objectives
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

Updates in the IBM C2090-600 Exam Topics:

IBM C2090-600 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual  C2090-600 exam on the first attempt, you need to put in hard work on these questions as they cover all updated IBM C2090-600 exam topics included in the official syllabus. Besides studying actual questions, you should take the IBM C2090-600 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the IBM DB2 11.1 DBA for LUW C2090-600 exam practice test. Online and Windows-based formats of the C2090-600 exam practice test are available for self-assessment.

 

C2090-600 Exam Details

Free C2090-600 Questions