What is the best design to achieve the goal?

You need to design a data warehouse schema to support a multidimensional cube. The fact
table will contain multiple columns representing order dates, shipping dates, and billing
dates. The cube will contain a measure group based on the fact table.
What is the best design to achieve the goal? More than one answer choice may achieve the
goal. Select the BEST answer.

A.
In the database, create a time table for each date column in the fact table.
From the data source view, join each date column in the fact table to the corresponding time
table.
Create dimensions for each time table.

B.
In the database, create a time table containing a column that corresponds to each date
column in the fact table.
From the data source view, join each date column in the fact table to the corresponding
column in the time table.
Create a dimension for the time table.

C.
In the database, create a time table that uses an integer primary key and a datetime
column.
Create a dimension based on the time table.

From the Cube Designer, use the Dimension Usage tab to define a relationship between the
measure group date columns and the datetime column of the time dimension.

D.
In the database, create a time table that uses an integer primary key and a datetime
column.
Create a dimension based on the time table.
From the Cube Designer, use the Dimension Usage tab to define a relationship between the
measure group date columns and the key column of the time dimension.