Online Access Free C2090-614 Practice Test

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

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

What must you do before an online table space backup operation can be performed?

• A.Create a full database backup image.
• B.Create one or more tables in the table space.
• C.Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
• D.Create an incremental backup image of the table space.

What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)

• A.Global Lock Management (GLM)
• B.Shared Communications Area (SGA)
• C.Automated Member Restart (AMR)
• D.Group Transaction Routing (GTR)
• E.Buffer Pool Synchronization (BPS)

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

• A.ALTER TABLESPACE tbsp1 REDUCE MAX
• B.ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
• C.ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);
• D.ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

What statement regarding Asynchronous index cleanup (AIC) is correct?

• A.AIC activates a newly attached partition after the index entries have been synchronized.
• B.AIC removes all invalid index entries that refer to the attached partitions.
• C.AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
• D.AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).