IBM Information Management DB2 10 pureScale Technical Mastery Test v3 v6.0 (P2090-054)

Page:    1 / 5   
Total 74 questions

Which one of the following sentences does NOT describe a benefit of Temporal Tables?

  • A. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
  • B. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
  • C. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
  • D. Temporal tables provide a quick and easy way to track and record data changes in the table.


Answer : C

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.


Answer : C

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.


Answer : B

Which DB2 licensing type is based on the number of users allowed to access the data server?

  • A. PVU (Processor Value Unit) licensing
  • B. Sub-capacity licensing
  • C. Authorized User (AU) licensing
  • D. Per Server licensing


Answer : C

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

  • A. 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.
  • B. 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.
  • C. 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.
  • D. 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.


Answer : A

Which of the following options does NOT describe a benefit of DB2's Row Compression?

  • A. Compression allows you to reduce CPU workload because there is less data to process.
  • B. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).
  • C. Compression allows you to cache more data in the buffer pools using the same amount of space.
  • D. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.


Answer : A

How can you verify that a DB2 installation was successful?

  • A. Verification is performed by running the VERIFY INSTALL command.
  • B. Verification is completed by the DBA using the database verification toolkit.
  • C. Verification is automatically performed by the AUTO_CONFIGURE feature.
  • D. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.


Answer : D

Which of the following questions is FALSE about DB2 Audit facility?

  • A. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.
  • B. The DB2 Audit facility logs configuration changes made by STMM.
  • C. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to keep historical records of database activities.
  • D. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.


Answer : B

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

  • A. When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
  • B. DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
  • C. DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
  • D. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.


Answer : C

Which one of the following options is CORRECT?

  • A. In both DB2 pureScale and HADR environments data is available all the time.
  • B. DB2 pureScale transfers log files from a primary database to a standby database.
  • C. HADR persists data in the cluster caching facilities (CFs).
  • D. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.


Answer : D

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.


Answer : D

Which one of the following options is FALSE?

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


Answer : A

Which one of the following options is CORRECT about DB2 pureScale feature?

  • A. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.
  • B. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.
  • C. DB2 pureScale persists data in the cluster caching facilities (CFs).
  • D. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.


Answer : D

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

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


Answer : D

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.


Answer : C

Page:    1 / 5   
Total 74 questions