With Lead2pass complete study guide for the IBM C2090-310 Certification exam you will find questions and answers from previous exams as well as ones that our experts believe will be on the upcoming exams due to upgrades and new releases. This gives you the resources you actually need to pass the exam instead of just studying material without any knowledge of what might be on a test. If you want a career in the IT world, a certification is the only answer to ensure you get your dream job.
QUESTION 1
When creating a database from the workload console, which field is optional?
A. Code set
B. Schema file
C. Database user
D. Collating sequence
Answer: C
Explanation:
Reference:http://www.ibm.com/developerworks/data/library/techarticle/dm-1404hadrpure/
QUESTION 2
Which two items are true about automatic database backups via Tivoli Storage Manager?
A. Automatic backups are invoked as online backups excluding transaction logs.
B. The backup image includes OS user account and group settings as well as DB2 registry
values.
C. IBM Tivoli Storage Manager must be configured only before the database is created to
use this function.
D. IBM Tivoli Storage Manager must be configured before the instance that hosts the
database is created to use this function.
E. The maximum number of backup images that can be stored is seven; after this the
oldest image is deleted automatically when a new image is created.
Answer: DE
QUESTION 3
There are an even number of members in a pureScale cluster.
What happens to the pureScale cluster if half of the members and the primary Cluster Caching facility (CF) fail simultaneously and the remaining CF is in peer state?
A. The cluster would stay online only if a tiebreaker disk was configured.
B. The cluster would go offline because primary Cluster caching facility failed.
C. The remaining member and standby cluster caching facility would also be
shutdown and restarted.
D. The cluster would remain online only if the I/O for failed members is fenced off using
SCSI Persistent reserve protocol.
Answer: C
QUESTION 4
A user is not able to delete an instance.
What could be the cause of this failure?
A. The user is not the instance owner.
B. The user does not have the ‘AH’ privilege.
C. The user does not have the ‘Write’ privilege.
D. The user does not have the ‘Delete’ Privilege.
Answer: A
QUESTION 5
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
Explanation:
Reference: http://www.praxiumgroup.com/adug-www/prev_pres/ADUG%202013-04- 05%20-%20PureData-TechDeepDive.pdf (page 27)
QUESTION 6
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
QUESTION 7
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: DE
QUESTION 8
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
Explanation:
Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.mon.doc/do c/t0056773.html?cp=SSEPGG_9.8.0%2F1-4-0-3-1
QUESTION 9
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
QUESTION 10
You need to grant user jane the ability to create new databases on an instance db2sdin9.
Which statement describes the correct procedure to grant user jane this access?
A. Grant jane the “Create new patterns” right under Workload Management.
B. Grant jane the “Manage all databases and client configurations (Full permission)” rights
under Workload Management.
C. Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the
list of “Access granted to” users.
D. Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the
list of “Instance available to” users.
Answer: C
QUESTION 11
When looking up the information for the storage nodes, what does the location information show?
A. The topology map of the storage network.
B. The city and state the storage unit is installed in.
C. The port on the network switch the storage unit is connected.
D. The rack and physical location within that rack in rack unit numbers.
Answer: A
Being a IBM C2090-310 certified professional guarantee a better future and success for you. Lead2pass IBM certification preparation exams would prove themselves to be the most helpful step in the direction of that IBM goal. You can easily find IBM preparation material for all certifications in Lead2pass by visiting our website below:
http://www.lead2pass.com/C2090-310.html
![]() |
![]() |
![]() |
![]() |
![]() |
|
---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
|
Lead2pass | Testking | Pass4sure | Actualtests | Others | |
$99.99 | $124.99 | $125.99 | $189 | $29.99-$49.99 | |
Up-to-Dated | ✔ | ✖ | ✖ | ✖ | ✖ |
Real Questions | ✔ | ✖ | ✖ | ✖ | ✖ |
Error Correction | ✔ | ✖ | ✖ | ✖ | ✖ |
Printable PDF | ✔ | ✖ | ✖ | ✖ | ✖ |
Premium VCE | ✔ | ✖ | ✖ | ✖ | ✖ |
VCE Simulator | ✔ | ✖ | ✖ | ✖ | ✖ |
One Time Purchase | ✔ | ✖ | ✖ | ✖ | ✖ |
Instant Download | ✔ | ✖ | ✖ | ✖ | ✖ |
Unlimited Install | ✔ | ✖ | ✖ | ✖ | ✖ |
100% Pass Guarantee | ✔ | ✖ | ✖ | ✖ | ✖ |
100% Money Back | ✔ | ✖ | ✖ | ✖ | ✖ |