Microsoft
70-432 · Question #189
70-432 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
Question
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?
Options
- AALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH
- BALTER INDEX ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
- CALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
- DALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.