最新的IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018免費考試真題

A. Classic Row Compression

B. Temporary Tables Compression

C. Declared Global Temporary Tables Compression

D. Adaptive Compression

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

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

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

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

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

B. Temporal tables provide a quick and easy way to track and record data changes in the table.

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

D. Temporal tables allow better data management by letting the application control data integrity and uniqueness.

A. HADR persists data in the cluster caching facilities (CFs).

B. In both DB2 pureScale and HADR environments data is available all the time.

C. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.

D. DB2 pureScale transfers log files from a primary database to a standby database.