CompTIA Data+ (DA0-001) — Question 240

A data analyst wants to improve the performance of the query that is currently running. The query is currently using a SELECT*. Which of the following are the best ways to speed up the query? (Choose two.)

Answer options

• A. Partitioning the table
• B. Creating an index for individual columns
• C. Creating an index for all columns
• D. Creating a stored procedure
• E. Changing the query to use individual columns
• F. Creating table statistics

Correct answer: B, E

Explanation

Options B and E are correct as creating an index for individual columns can significantly improve query performance by allowing faster data retrieval, while changing the query to use specific columns reduces the amount of data processed. Options A, C, D, and F may offer benefits, but they are not as directly impactful on query speed as the chosen options.