What should you do?

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.

View Answer

Answer: C