P2090-054 Online Practice Questions and Answers

Which of the following options describes correct cluster caching facility states when both primary and secondary cluster caching facilities are in sync?

A. primary: PRIMARY secondary: SECONDARY

B. primary: SYNC secondary: SYNC

C. primary: PRIMARY secondary: PEER

D. primary: PEER secondary: CATCHUP

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

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.

Which one of the following options is correct about DB2 pureScale installation?

A. A single setup image is required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.

B. Different setup images are required for for installing both members and cluster caching facilities. An invocation of the Setup Wizard is required to install all of the DB2 Members of the DB2 pureScale feature. Another invocation of the Setup Wizard is required to install all of the Cluster Caching Facilities.

C. A single setup image is required for installing both members and cluster caching facilities. A single invocation of the Setup Wizard from the installation-initiating host installs all of the components of the DB2 pureScale feature across all hosts that you specify as part of the DB2 pureScale environment.

D. Different setup images are required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.

A database administrator retrieved the following status from the DB2 members in a DB2 pureScale environment: Which of the following options will start ONLY the member hosted in NODE102?

A. db2start member on NODE102

B. db2start NODE102

C. db2start member 1

D. db2cluster -node node102 -exit - maintenance

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.

What is the DB2 Load utility?

A. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.

B. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.

C. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

D. The DB2 Load utility can be used to load and create external functions in a DB2 database.

Which one of the following options contains a benefit of the Java Generic Table Functions?

A. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

B. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

C. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.

D. Java Generic Table Functions can be implemented in any programming language.

Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?

A. The IMPORT utility is now deprecated and INGEST is the recommended alternative.

B. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.

C. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.

D. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.

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.