Question:Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table? 

A ALTER TABLE Table1 REBUILD WITH (DATA_COMPRESSION = PAGE) 
B ALTER TABLE Table1 REBUILD PARTITION = 1 WITH (DATA_COMPRESSION = NONE) GO 
C ALTER TABLE Table1 REBUILD PARTITION ALL WITH (DATA_COMPRESSION = PAGE ON PARTITIONS(1) ) 
D All of these 

+ Answer
B 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description