C2090-614 Online Practice Questions and Answers

Which statement about value compression is correct?

A. To use value compression, you must have a license for the DB2 Storage Optimization Feature.

B. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.

C. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.

D. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.

The following query is executed frequently against the SALES table:

SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?

A. CREATE INDEX sales_idx ON sales (region)

B. CREATE INDEX sales_idx ON sales (sales_person)

C. CREATE INDEX sales_idx ON sales (region, sales_person)

D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Which statement about data type mappings is true in a federated system?

A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.

B. Data types can be mapped in both directions between a remote and local data type.

C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.

D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.

If the following statements are executed:

CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot;

What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.

B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.

C. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.

D. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?

A. It will backup just the catalog partition.

B. It will backup all partitions simultaneously.

C. It will backup just the partition that the command is executed from.

D. It will backup just the partitions that reside on the host that the command is executed from.

Which is NOT a valid method for prefetching data?

A. Smart data prefetching

B. Read-ahead prefetching

C. Consecutive prefetching

D. Sequential detection prefetching

When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?

A. Frequency of access; acceptable access time; volatility of the data.

B. Acceptable access time; redundancy of the data; volatility of the data.

C. TIR (table/index data ratio); frequency of access; volatility of the data;

D. Frequency of access; redundancy of the data; acceptable access time;

You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?

A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.

B. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.

C. Issue a LIST UTILITIES statement with the 'SUSPEND ' option specified.

D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.