C2090-600 IBM DB2 11.1 DBA for LUW Questions and Answers

Audit policy changes are applied instantly and affect all inflight transactions.

Multiple audit policies can be associated with the same table at the same time.

The audit policy applied to a table is automatically applied to any view based on that table.

If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original user.

LOAD

INGEST

IMPORT

TRANSPORT

To prunethe contents of a staging table.

To prune the contents of a synopsis table.

To prune the contents of a materialized query table (MQT).

To prune the contents of a declared global temporary table.

Compression must be explicitly enabled for BLU MPP tables

Compression requires decompression to evaluate partition joins

Unique compression dictionaries are generated for each partition

Each table has a single compression dictionary that getsreplicated across all partitions

Friday

Monday

Saturday

Wednesday

The LOAD actions can be run from a client machine.

Object ownership cannot be changed after a successful schema copy operation.

Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

Loading data into tables containing XML columns is only supported for the LOAD actions.