Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
Shadow tables are a unique type of Materialized Query Table (MQT) characterized by two primary distinctions. Firstly, shadow tables must be organized by column, meaning they are arranged in a columnar format, which typically enhances analytical query performance. Secondly, shadow tables must be maintained by replication, meaning that their data is automatically kept in sync with the source table. These features set shadow tables apart from standard MQTs.
The good answer is C,D. A shadow table is a column-organized copy of a row-organized table that includes all columns or a subset of columns. Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061564.html