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？（）

• 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.