You are hired as a database consultant at Domain.com. The Domain.com network contains a SQL Server database server named Certkiller -DB01. Certkiller -DB01 host a database named CK_Sales that stores line items from Domain.com’s online sales transactions. Domain.com processes about 40,000 transactions every day. An application that processes the sales transactions requires a clustered index on a column named TransID.
You need to create a table that supports an efficient reporting solution that queries the transactions by date.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)