CompTIA Data+ (DA0-001) — Question 122

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

Answer options

• A. To return a subset of records
• B. To insert a temporary table
• C. To prevent SQL injections
• D. To increase the query speed

Correct answer: C

Explanation

The correct answer is C, as parameterization helps in preventing SQL injection attacks by ensuring that user inputs are treated as data rather than executable code. Options A and D relate to performance and data retrieval but do not address security concerns. Option B is not relevant to the purpose of parameterization.