PrepAway - Latest Free Exam Questions & Answers

What must be done to convert a populated base table to a multidimensional clustering (MDC) table?

What must be done to convert a populated base table to a multidimensional clustering (MDC)
table?

PrepAway - Latest Free Exam Questions & Answers

A.
Export the data, create an MDC table, and then import or load the data into the MDC table.

B.
Execute the ALTER TABLE … ORGANIZE BY DIMENSIONS statement to convert the table.

C.
Create an MDC table and then move the data in the base table to the MDC table with the
db2move command.

D.
Export the data, execute the ALTER TABLE … ORGANIZE BY DIMENSIONS statement to
convert the table, and then import or load the datainto the converted table.

Explanation:


Leave a Reply