Given the following database design:

A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM
dimension table and the SALES fact table. Which action should be performed to improve query
performance?

A.
Create a replicated summary table for the SALES table using the table space TS_REPL.

B.
Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.

C.
Create an index on both the DATE_DIM and the SALES table for the column that is used in the
collocated join.

D.
Create a replicated summary table for the SALES table using the table space TS_DIM and
create an index on the DATE_DIM table.

Explanation: