CompTIA Data+ (DA0-001) — Question 195

Which of the following query optimization techniques involves examining only the data that is needed for a particular task?

Answer options

• A. Making a temporary table
• B. Creating a flat file
• C. Indexing documents
• D. Creating an execution plan

Correct answer: C

Explanation

The correct answer is C, as indexing documents allows the database to quickly access only the relevant data needed for queries, thus optimizing performance. The other options, such as making a temporary table and creating a flat file, do not specifically target data access efficiency and may involve handling more data than necessary. Creating an execution plan is about outlining how a query will be executed rather than focusing on the specific data needed.