You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50,000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Place a nonclustered index on the date column.
B.
Add a unique clustered index on the date column.
C.
Map each partition to a filegroup, with each filegroup accessing a different physical drive.
D.
Create a partitioning scheme that partitions the data by date.