IBM P2090-054 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-054
Exam Name/Title: IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3
Certification Provider: IBM
Corresponding Certification: IBM Information Management

Exam Questions: 70
Updated On: May 30, 2026

Question #22

What is a DB2 instance?

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

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

C. A DB2 instance is just another name for DB2 Database.

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

Discussion 0

Correct Answer: D Vote an answer

Question #23

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

A. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

B. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

C. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

D. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

Discussion 0

Correct Answer: D Vote an answer

Question #24

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 import data into a database, while the INGEST can only create database objects based on a script file.

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 perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.

Discussion 0

Correct Answer: C Vote an answer

Question #25

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

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.

Discussion 0

Correct Answer: C Vote an answer

Question #26

Which one of the following options is NOT a new feature introduced in DB2 10?

A. Multi-Temperature Data Management

B. INGEST utility

C. Temporal Tables

D. Table Partitioning

Discussion 0

Correct Answer: D Vote an answer

Question #27

Which one of the following options is FALSE?

A. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into DB2 tables.

B. WLM is not supported in DB2 pureScale environments.

C. Implementation of a row and column access control policy is transparent to applications accessing the database.

D. HADR with multiple standbys supports reads on all standby databases.

Discussion 0

Correct Answer: B Vote an answer

Question #28

What is the DB2 Load utility?

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

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

C. 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.

D. 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.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM P2090-054 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-054 exam.