You are designing an application that will use Windows Azure Table storage to store millions of data points each day.
The application must retain each day’s data for only one week.
You need to recommend an approach for minimizing storage transactions.
What should you recommend?
A.
Use a separate table for each date.
Delete each table when it is one week old.
B.
Use a separate table for each week.
Delete each table when it is one week old.
C.
Use a single table, partitioned by date.
Use Entity Group Transactions to delete data when it is one week old.
D.
Use a single table, partitioned by week.
Use Entity Group Transactions to delete data when it is one week old.