IBM PureData System for Transactions - Administration (C2090-310) Free Practice Test

Question 1

Which state indicates that a compute node will not accept any new database connections, but the current connections on the compute node will continue to run?

A. Quiesced

B. Discovery

C. Available

D. Maintenance

Correct Answer: C

Question 2

When creating a database from the workload console, which field is optional?

A. Schema file

B. Database user

C. Collating sequence

D. Code set

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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. 10 Gb SFP+ Fiber, 10Gb SFP+DAC

B. 1 Gb SFP Fiber. 1 Gb SFP Copper. 10 Gb SFP+ Fiber, 10 Gb SFP+DAC

C. 1 Gb SFP Fiber, 1 Gb SFP Copper

D. 1 Gb SFP Fiber, 10 Gb SFP+ Fiber. 10 Gb SFP+DAC

Correct Answer: D

Question 4

What is stored on the shared file system in a pureScale cluster?

A. Tablespace containers, DB2 diagnostic log files, and active log files for all members.

B. Tablespace containers, active log files for all members, and cluster tiebreakers.

C. Instance home directory, DB2 executables. and tablespace containers.

D. DB2 executables, tablespace containers, and active log files for all members.

Correct Answer: A

Question 5

Which is a valid opportunity that can result from a storage monitoring job run?

A. Backup compression recommendations

B. Table space merge recommendations

C. Change page size recommendations

D. Drop seldom-used index recommendations

Correct Answer: A

Question 6

Which list defines features available with the Database Performance Monitor?

A. Instance alerts, database alerts, user-defined alerts, and system templates for monitoring

B. Instance alerts, database alerts, and system templates for monitoring

C. Instance alerts, user-defined alerts and system templates for monitoring

D. Database alerts, user-defined alerts, and system templates for monitoring

Correct Answer: C

Welcome to TestSimulate

IBM PureData System for Transactions - Administration (C2090-310) Free Practice Test