PrepAway - Latest Free Exam Questions & Answers

Which code segment should you use?

Your database is 5GB and contains a table named SalesHistory. Sales information is frequently inserted and updated.
You discover that excessive page splitting is occurring.
You need to reduce the occurrence of page splitting in the SalesHistory table.
Which code segment should you use?.

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER DATABASE Sales MODIFY FILE
(NAME = Salesdat3, SIZE = 10GB);

B.
ALTER INDEX ALL ON Sales.SalesHistory REBUILD WITH (FILLFACTOR = 60);

C.
EXEC sys.sp_configure ‘fill factor (%)’, ’60’;

D.
UPDATE STATISTICS Sales.SalesHistory(Products)
WITH FULLSCAN, NORECOMPUTE;

One Comment on “Which code segment should you use?


Leave a Reply