IBM
A2090-614 · Question #99
In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
The correct answer is C. To improve query performance in a data warehouse environment. See the full explanation below for the reasoning.
Question
In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
Options
- ATo improve access performance for tables in an OLTP database.
- BTo improve index performance in a data warehouse environment.
- CTo improve query performance in a data warehouse environment.
- DTo improve insert/delete performance for tables in an OLTP database.
How the community answered
(30 responses)- A7% (2)
- B3% (1)
- C77% (23)
- D13% (4)
Community Discussion
No community discussion yet for this question.