You administer a SQL Server 2008 infrastructure. You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is…

You administer a SQL Server 2008 infrastructure. You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is frequently queried by several reports. The last partition is heavily queried and frequently modified. You need to minimize the disk space of the table and ensure that this has minimum effect on the query performance. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)