The IBM C2090-310 PDF, C2090-310 practice exam and C2090-310 questions and answers at Lead2pass are written and prepared by IBM affiliated trainers and lecturers with decades of experience in the IT field. This ensures that you are equipped with the latest and most current information to give you a better chance of passing the IBM C2090-310 exam.
Vendor: IBM
Exam Code: C2090-310
Exam Name: PureData System for Transactions
Version: DEMO
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
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
If you want to get more C2090-310 exam preparation material,you can download the free demos in PDF files on Lead2pass.It would be great help for you exam.Wish you pass the exam successfully.