In which scenario should a DBA consider creating a multidimensional clustering (MDC) table
instead of a regular base table?

A.
To improve access performance for tables in an OLTP database.

B.
To improve index performance in a data warehouse environment.

C.
To improve query performance in a data warehouse environment.

D.
To improve insert/delete performance for tables in an OLTP database.

Explanation: