What should you do?

You need to implement a strategy for efficiently storing sales order data in the data warehouse.

What should you do?
A . Separate the fact Orders table into multiple tables, one for each month that has orders, and use a local partitioned view.
B . Separate the fact Orders table into multiple tables, one for each day that has orders, and use a local partitioned view.
C . Create daily partitions in the fact Orders table.
D . Create monthly partitions in the fact Orders table.

View Answer

Answer: C