Certified Data Management Professional – Fundamentals (CDMP) — Question 13

When reviewing data access plans, sequential searching is slowing the database.
One way to fix this is:

Answer options

• A. Reducing the number of database users
• B. Creating new indexes
• C. Converting it to an in-memory database
• D. Moving the database to the cloud
• E. Adding more memory

Correct answer: B

Explanation

Creating new indexes is the correct solution because indexes can significantly speed up data retrieval by allowing the database to find data without having to scan every record sequentially. The other options, such as reducing users or moving to the cloud, do not directly address the inefficiencies caused by sequential searching, while converting to an in-memory database may not be feasible for all applications.