Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

Note! Following P2090-054 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

P2090-054 IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Questions and Answers

Questions 4

What is the purpose of the tiebreaker disk in a DB2 pureScale environment?

Options:

A.

Tiebreaker is used to determine which half of the DB2 pureScale instance should remain online upon a communication failure.

B.

Tiebreaker is used to determine which clients are accessing the data on the storage.

C.

Tiebreaker is used to determine which databases are currently active and can be accessed by the clients directly in graphical user interface (GUI).

D.

Tiebreaker is used by DB2 to transfer data when packets collide.

Buy Now
Questions 5

Which one of the following statements is TRUE about DB2 Workload Management (WLM)?

Options:

A.

DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.

B.

DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

C.

DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

D.

DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.

Buy Now
Questions 6

Which one of the following options contains the minimum configuration for a DB2 pureScale cluster capable of recovering from a member failure?

Options:

A.

1 cluster caching facility and 1 DB2 members.

B.

2 cluster caching facilities and 1 DB2 member.

C.

1 cluster caching facility and 2 DB2 members.

D.

2 cluster caching facilities and 2 DB2 members.

Buy Now
Questions 7

How does DB2 pureScale handle member(s) failover scenarios?

Options:

A.

All data remains locked until the failover operation is completed.

B.

Future connections are evenly distributed among the surviving members of the cluster.

C.

Current connections to the failed member will be on hold until the member recovers and is back online.

D.

DB2 pureScale requires database administrator intervention to handle failover scenarios.

Buy Now
Questions 8

Consider the scenario where a client application is connected to DB2 pureScale "member 1". The DB2 pureScale environment has three DB2 pureScale members. In a situation where "member 1" fails, the client is still able to execute operations against the DB2 pureScale cluster with minimal interference. Which of the following technologies allow the client to continue performing operations?

Options:

A.

Decentralized log files for member recovery.

B.

Geographically Dispersed pureScale Cluster (GDPC).

C.

Automatic Client Reroute.

D.

Redundant cluster caching facility.

Buy Now
Questions 9

What is a DB2 instance?

Options:

A.

A DB2 instance is just another name for DB2 Database.

B.

A DB2 instance is a copy of a database that can be accessed standalone from the database server.

C.

A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.

D.

DB2 does not use instances. It requires only databases to operate.

Buy Now
Questions 10

The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?

Options:

A.

Temporary Tables Compression

B.

Declared Global Temporary Tables Compression

C.

Adaptive Compression

D.

Classic Row Compression

Buy Now

SWG Technical Mastery | P2090-054 Questions Answers | P2090-054 Test Prep | IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Questions PDF | P2090-054 Online Exam | P2090-054 Practice Test | P2090-054 PDF | P2090-054 Test Questions | P2090-054 Study Material | P2090-054 Exam Preparation | P2090-054 Valid Dumps | P2090-054 Real Questions | SWG Technical Mastery P2090-054 Exam Questions

Exam Code: P2090-054
Exam Name: IBM Information Management DB2 10 pureScale Technical Mastery Test v3
Last Update: Apr 14, 2023
Questions: 69