You administer a SQL Server 2008 instance that contains a database named AdventureWorks. You plan to use data compression to conserve disk space. You compress a table named VeryLarge that has a…

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. You plan to use data compression to conserve disk space. You compress a table named VeryLarge that has a clustered index named Index1 and a non- clustered index named Index2. Both indexes are partitioned. You execute the following Transact-SQL statement. ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW); You need to ensure that all the indexes of the VeryLarge table are compressed by using row-level compression. You need to accomplish this goal by using minimum resources. Which Transact-SQL statement should you execute?