You need to develop the tabular project to support the date analysis requirements.
What should you do?
A. · Create one date table named Date.
· Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
· Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
B. · Create two date tables, one named Order Date and one named Ship Date.
· Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
· Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
C. · Create one date table named Date.
· Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
· Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
D. · Create two date tables, one named Order Date and one named Ship Date.
· Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
· Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
