You are creating a new table in a database. Your business requires you to store data in the table for only seven days.
You need to implement a partitioned table to meet this business requirement.
Which tasks should you complete?
A.
Create the partition function
Create the partition scheme
Create the table
B.
Create the partition function
Create the table
Create a filtered index
C.
Add a secondary file to the primary filegroups
Create the table
Create the distributed partitioned view
D.
Create the partition function
Create the partition scheme
Create the distributed partitioned view