Online Access Free P2090-054 Exam Questions

What is a DB2 instance?

• A.A DB2 instance is just another name for DB2 Database.
• B.A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.
• C.DB2 does not use instances. It requires only databases to operate.
• D.A DB2 instance is a copy of a database that can be accessed standalone from the database server.

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?

• A.Temporary Tables Compression
• B.Classic Row Compression
• C.Declared Global Temporary Tables Compression
• D.Adaptive Compression

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

• A.Tiebreaker is used to determine which clients are accessing the data on the storage.
• B.Tiebreaker is used to determine which databases are currently active and can be accessed by the clients directly in graphical user interface (GUI).
• C.Tiebreaker is used by DB2 to transfer data when packets collide.
• D.Tiebreaker is used to determine which half of the DB2 pureScale instance should remain online upon a communication failure.

Which one of the following options is FALSE?

• A.HADR with multiple standbys supports reads on all standby databases.
• B.Implementation of a row and column access control policy is transparent to applications accessing the database.
• C.WLM is not supported in DB2 pureScale environments.
• D.The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into DB2 tables.

Which of the following is NOT a reason for a database administrator to place a DB2 pureScale node into maintenance mode?

• A.To update the DB2 Cluster Services software.
• B.To be able to perform software and hardware updates on both cluster caching facilities (primary and secondary) at the same time.
• C.To ensure that the system does not reboot when installing new software on the system.
• D.When moving a server to a different location and requiring to disconnect it from the cluster.