You are building a new index for an application. You need to reduce the storage space used by the index and to minimize logical reads. What should you configure?
Suggested Answer:D🗳️
The data compression feature to help reduce the size of the rowstore tables and indexes. It can also help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk. Incorrect Answers: A: Setting the SORT_IN_TEMPDB option to ON can reduce the time that is required to create or rebuild an index. C: PAD_INDEX secifies index padding. The default is OFF. References: http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-sql-server-data-compression/ https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/relational-databases/indexes/sort-in-tempdb-option-for-indexes?view=sql-server-2017
This section is not available anymore. Please use the main Exam Page.70-464 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Zikato
4 years, 6 months agoDolous
4 years, 5 months ago