What is the purpose of a database index in a schema?

The correct answer is B. To speed up data retrieval operations. Indexes create a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space.

Data Model and Schema Management

Question

Options

ATo enforce data validation rules
BTo speed up data retrieval operations
CTo link two schemas together
DTo store large binary files

How the community answered

(46 responses)

A
13% (6)
B
78% (36)
C
2% (1)
D
7% (3)

Explanation

Indexes create a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space.

Topics

#database index#schema performance#data retrieval

Community Discussion

No community discussion yet for this question.

Full AD0-E331 Practice