Lead2pass provide the best training material for IBM C2090-310 certification exams. When you use our products Lead2pass ensure that you emerge successful in your certification exam. We provide with the latest C2090-310 exam dumps, you can easily pass your certification exam with our exam dumps.

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

Exam C2090-310 Q&A from Lead2pass include:
Comprehensive questions with complete details.
100% Accurate and Verified Answers .
Most of Exam Answesrs with Explanations.
Printable questions and answers.
Complete coverage of exam objectives.
Precise explanations.
Regular Updates to Reflect Current Exam Material.

http://www.lead2pass.com/C2090-310.html