Test information:
Number of questions: 58
Time allowed in minutes: 90
Required passing score: 57%
Languages: English
Recommended Prerequisites:
Experience as a system administrator of PureData System for Transactions
Knowledge of DB2 databases
Knowledge of DB2 pureScale environments
N26 pureScale mastery exam
An IBM professional certification targeting system administrators responsible for maintaining a PureData System for Transactions. This exam will validate a practical knowledge of how to perform day-to-day administration, such as provisioning of instances and databases, access control and monitoring of overall health of the system.
Section 1 – Architecture and Features (17%)
Knowledge and purpose of software components and hardware included in the product (upgrades, High Availability)
Network requirements to connect a PDTX system into the client network
Ability to use Infrastructure Map to inspect system components
Knowledge about advantages of using patterns
Section 2 – DB2 pureScale (14%)
Knowledge of architecture and components of a DB2 pureScale cluster (members, CFs, shared storage, etc.)
Knowledge of DB2 pureScale behavior in different failure scenarios
Knowledge of Workload Balancing, Client Affinity and automatic client re-route
Knowledge of CF and Members states
Section 3 – Operational Tasks (21%)
Ability to create new DB2 pureScale instance and identify and change properties of existing ones. (compatibility considerations)
Knowledge of what takes place during an “instance” deploy
Ability to manage DB2 pureScale instance (instance growth, set permissions, inspect logs, etc)
Ability to create new databases and identify and change properties of existing ones.
Ability to create and use database workload standards and database patterns for deployment of new databases
Ability to manage databases (add storage, backups, TSM, database cloning, set permissions, inspect logs, etc.)
Section 4 – Tooling (12%)
Knowledge of Client Side Database Tools (what and where)
Knowledge of capabilities and operation of the Database Performance Monitor
Knowledge of capabilities and operation of the Database Configuration Manager
Ability to use the Job Scheduler to create and schedule jobs
Knowledge of tools available for migrating existing databases onto the pureData system
Section 5 – Security (16%)
Knowledge of different layers of security (system, instance, database)
Ability to administer system, instance and database users and groups using System Console and Workload Console
Knowledge of user and group permissions at the system, instance and database levels and its implications
Configuring SSH for database users
Ability to grant and revoke instance and database privileges from users and groups using Console and its implications
Configuring and using LDAP for user/group management
Knowledge of PureData Auditing
Section 6 – System Maintenance (12%)
Monitoring HW resources
Monitoring system events, alerts and logs
Performing system backup and restore
Applying system updates (fixpacks)
Performing manual and automated database backups
Section 7 – Troubleshooting (9%)
Diagnostics and diagnostic tools
Type of information available
Difference between events, troubleshooting and problems
IBM Certified Administrator – IBM PureData System for Transactions
Job Role Description / Target Audience
An IBM professional certification targeting system administrators responsible for maintaining a PureData System for Transactions. This exam will validate a practical knowledge of how to perform day-to-day administration, such as provisioning of instances and databases, access control and monitoring of overall health of the system.
Recommended Prerequisite Skills
Experience as a system administrator of PureData System for Transactions
Knowledge of DB2 databases
Knowledge of DB2 pureScale environments
N26 pureScale mastery exam
QUESTION 1
If there is a system problem to diagnose, where do you find system logs to download?
A. In the Events option of the System Console.
B. In the Problems option of the System Console.
C. In the Troubleshooting option of the System Console.
D. In the Infrastructure Map option of the System Console.
Answer: D
Reference: https://www.praxiumgroup.com/adug-www/prev_pres/ADUG%202013-04-05%20-
%20PureData-TechDeepDive.pdf (page 27)
QUESTION 2
PureData System for Transactions top of rack switch supports different connection speeds for
integration into the customer network. What are the different connection speeds supported?
A. 1 Gb SFP Fiber, 1 Gb SFP Copper
B. 10 Gb SFP+ Fiber, 10Gb SFP+DAC
C. 1 Gb SFP Fiber, 10 Gb SFP+ Fiber. 10 Gb SFP+DAC
D. 1 Gb SFP Fiber. 1 Gb SFP Copper. 10 Gb SFP+ Fiber, 10 Gb SFP+DAC
Answer: C
Explanation:
QUESTION 3
Which two items regarding PureData database-level backups are true?
A. Database backups cannot be performed manually.
B. Managed either manually or automatically through the System Console.
C. Managed either manually or automatically through the Workload Console.
D. You must configure Tivoli Storage Manager to enable database backups.
E. The backup image includes DB2 Registry values, customized OS users and groups.
Answer: D,E
Explanation:
QUESTION 4
Which command can be used by a database administrator to display the status of
a pureScale system?
A. db2instance-list
B. db2cluster-cfs-list
C. db2 list node directory
D. db2cluster -cm -list -alert
Answer: A
Reference: https://www-
01.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.mon.doc/doc/t0056
773.html?cp=SSEPGG_9.8.0%2F1-4-0-3-1
QUESTION 5
Which operation can be used to stop member 0 with no impact on the running transaction?
A. db2stop force
B. db2stop quiesce
C. db2stop member 0 force
D. db2stop member 0 quiesce
Answer: D
Explanation:
Click here to view complete Q&A of C2090-310 exam
Certkingdom Review
Best IBM C2090-310 Certification, IBM C2090-310 Training at certkingdom.com