P2090-054 Online Practice Questions and Answers

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. When moving a server to a different location and requiring to disconnect it from the cluster.

D. To ensure that the system does not reboot when installing new software on the system.

Consider a scenario where your DB2 pureScale cluster caching facilities are in PEER state. What would be the state of the secondary cluster caching facility upon failure of the primary cluster caching facility and a successful takeover?

A. ERROR

B. PEER

C. PRIMARY

D. NEW_PRIMARY

Consider the scenario where the primary cluster caching facility failed while the secondary cluster caching facility was in CATCHUP state. Which of the following outcomes is CORRECT?

A. The DB2 pureScale cluster would freeze. A database administrator must restore the database from a previous backup and then roll forward the database to a point in time before the freeze.

B. DB2 cluster services will initiate a group restart with the former secondary cluster caching facility becoming the primary CF for the cluster. The instance will be temporarily unavailable while the services restart automatically

C. The instance would be brought down. DB2 cluster services then restarts only the secondary cluster caching facility now in the primary role.

D. The takeover operation succeeds and the secondary cluster caching facility will be promoted to primary. The cluster would continue processing incoming read-only transactions.

Which one of the following options is CORRECT about Temporal Tables?

A. Temporal tables are complex to maintain and require major application changes.

B. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.

C. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.

D. Temporal tables are used to model data in the past, present, and future.

DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the CORRECT statement about HADR.

A. HADR protects against data loss by saving data changes from a source database into a local recovery log file.

B. HADR protects against data loss by replicating data changes from a backup database file to a standby database.

C. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

D. HADR feature is only available for DB2 Advanced Enterprise Edition.

What is the DB2 Design Advisor?

A. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.

B. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.

C. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.

D. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.

Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?

A. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.

B. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

C. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.

D. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBAC protected column.

Which one of the following options is TRUE about DB2 pureScale?

A. DB2 pureScale feature does not support range-partitioning tables.

B. A DB2 pureScale installation is only supported on AIX platform.

C. DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).

D. DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).

What is a table space in DB2?

A. A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.

B. A table space is a DB2 component that manages access to databases.

C. A table space is a space reserved for catalog tables and base table data.

D. A table space is a logical storage grouping that can be composed of one or more containers.

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?

A. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

B. Table data is protected against direct access to the table. Access using views is unrestricted.

C. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

D. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.