DS0-001 · Question #56
DS0-001 Question #56: Real Exam Question with Answer & Explanation
The correct answer is B: To provide quick and efficient access to data. Indexes are data structures that allow a database engine to locate rows without scanning an entire table, making reads significantly faster - this is their primary purpose, making B correct. Option A is wrong because indexes actually consume additional disk space rather than help
Question
Which of the following is an advantage of creating indexes?
Options
- ATo help with space allocation
- BTo provide quick and efficient access to data
- CTo reduce memory
- DTo update the query plan
Explanation
Indexes are data structures that allow a database engine to locate rows without scanning an entire table, making reads significantly faster - this is their primary purpose, making B correct. Option A is wrong because indexes actually consume additional disk space rather than helping allocate it. Option C is wrong because indexes typically increase memory usage, as the engine loads index pages into the buffer cache. Option D is wrong because while the query optimizer uses indexes when building query plans, creating an index doesn't itself update the query plan - the plan is generated fresh at query time.
Memory tip: Think of an index like a book's index in the back - it doesn't change the book's size story (A), doesn't save paper (C), and doesn't rewrite the table of contents (D) - it simply lets you find information fast (B).
Community Discussion
No community discussion yet for this question.