C2090-614 Exam - Free IBM Questions and Answers

Question #1 (Topic: Topic 1)

Which table configuration CANNOT utilize multi-temperature storage?

A. A range-partitioned table utilizing multiple table spaces that map to DMS containers. B. Multiple tables containing the same data at different ages placed into the same table space. C. Multiple tables containing the same data at different ages placed into separate table spaces. D. A range-partitioned table utilizing multiple table spaces that map to individual storage groups.

Answer: B

Question #2 (Topic: Topic 1)

What will occur when a database administrator adds a new automatic storage path to an
existing storage group?

A. New table spaces will start consuming storage on the new path. B. Existing table spaces will not consume storage on the new path. C. The storage group will be placed in "Rebalance Pending" mode. D. DB2 will verify that space is available on the storage path specified.

Answer: B

Question #3 (Topic: Topic 1)

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be
used with?

A. Data class, work class, and a limit B. Data class, action class, and a threshold C. Service subclass, action class, and a limit D. Service subclass, work class, and a threshold

Answer: D

Question #4 (Topic: Topic 1)

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)

Answer: C

Question #5 (Topic: Topic 1)

To configure instance-level auditing with db2audit, which authority is required?

A. SYSADM B. SYSCTRL C. SECADM D. SYSMAINT

Answer: A

IBM C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam