IBM DB2 DBA for Linux UNIX and Windows Exam Certification Details:
Exam Code | C2090-611 |
Schedule Exam | Pearson VUE |
Books / Training | DB2 10.5 for LUW New Features and Database Upgrade Considerations DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs |
Number of Questions | 59 |
Sample Questions | IBM DB2 DBA for Linux UNIX and Windows Sample Questions |
Duration | 90 mins |
Exam Price | $200 (USD) |
Passing Score | 61% |
Exam Name | IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows |
IBM C2090-611 Exam Syllabus Topics:
Topic | Details | Weights |
---|---|---|
Utilities | -Demonstrate the ability to use traditional data movement utilities -Demonstrate the ability to use the Ingest utility -Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities -Demonstrate the ability to use the DB2 Design Advisor utility | 14% |
DB2 Server Management | -Demonstrate the ability to configure/manage DB2 servers, instances, and databases -Demonstrate the ability to use autonomic features -Demonstrate the ability to use Data Studio
| 10% |
Security | -Describe DB2 authorizations and privileges -Knowledge of the security administrator role -Demonstrate general knowledge of the Audit facility -Demonstrate knowledge of the trusted context -Demonstrate knowledge of row column access control (RCAC) -Demonstrate knowledge of LBAC | 15% |
Monitoring DB2 Activity | -Demonstrate the ability to use Admin views and SQL functions for monitoring -Knowledge of Work Load Manager monitoring features -Demonstrate the ability to use additional auto-monitoring tools -Demonstrate the ability to identify the functions of Problem Determination Tools -Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information | 10% |
High Availability | -Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery) -Demonstrate the ability to perform database-level and table space level backup and recovery operations -Demonstrate the ability to configure and manage HADR (read from standby) -Demonstrate knowledge of DB2 pureScale (HA features only) | 10% |
Physical Design | -Demonstrate the ability to create a database and manipulate various DB2 objects
-Demonstrate knowledge of partitioning capabilities | 26% |
Business Rules Implementation | -Demonstrate the ability to create constraints on tables -Demonstrate the ability to create views WITH CHECK OPTION -Demonstrate the ability to create and using triggers -Demonstrate the ability to use the set integrity command | 8.5% |
Connectivity and Networking | -Demonstrate the ability to configure database connectivity -Demonstrate knowledge of DB2 Discovery -Demonstrate knowledge of LDAP | 6.5% |
If you are still looking for A2090-611 test online materials, our products will be your good choice. We are a legal authorized enterprise offering all kinds of IT real test materials with high pass rate. Our A2090-611 test online materials are edited by experienced experts who specialized in IBM IBM Certified Database Administrator exams. We guarantee our test questions are high passing rate and can help most candidates pass test easily. In fact we are famous by our high-quality A2090-611 test online materials. If you are still upset about your exam, choosing us will help you half the work with double results.
We release three versions of test questions for each exam: PDF version, Soft version and Test online version. Take A2090-611 exam for example, the questions and answers for three versions are totally same. The difference is pattern of manifestation, easy to understand and remember.
PDF version of A2090-611 test online materials is easy to download and print. People can write on paper and practice repeatedly. It is available for companies to make presentations and communications among co-workers and candidates. Many candidates think A2090-611 test online materials are surefooted and dependable.
Soft version of A2090-611 test online materials is software that simulates the real tests' scenarios. You will be familiar with examination atmosphere, boost your confidence and good psychological diathesis. A2090-611 test online materials will help users take it easy while taking part in the real test. You can set up timed test like the real test; you can use our A2090-611 test online materials any time to test your own exam simulation test scores. Our software will remind users of practicing day to day. This software version of IBM A2090-611 test online materials is installed on JAVA and Windows operating system. Many candidates find our test questions are not available, as our A2090-611 test online materials do not support downloading by Mobil Phone and Pad. Our software can be installed on multiple computers for self-paced at-your-convenience training. Our A2090-611 test online materials can be installed more than 200 personal computers.
APP version of A2090-611 test online materials is also client that its functions are similar with soft version. App version is much stabler than Soft version. Part of software version of A2090-611 test online materials is not available for entering in but our APP version can. APP version of online test engine supports Windows / Mac / Android / iOS, etc. as it is the software based on WEB browser. Applicable range of APP version is wider than Soft version. Especially for exams we release great quantity of test questions, APP version of IBM A2090-611 test online materials will be best choice for you.
Besides good products, we provide excellent customer service. We offer 7*24 online service support about A2090-611 test online materials. Before passing test, we will be together with every user. We believe our test questions will help candidates pass Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows exam for sure. If you are determined to gain IBM Certified Database Administrator certification, our IBM A2090-611 test online materials will be your best choice.
After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)