ExamGecko
Question list
Search
Search

List of questions

Search

Question 151 - DA0-001 discussion

Report
Export

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

A.
Making a temporary table
Answers
A.
Making a temporary table
B.
Creating a flat file
Answers
B.
Creating a flat file
C.
Indexing documents
Answers
C.
Indexing documents
D.
Creating an execution plan
Answers
D.
Creating an execution plan
Suggested answer: C

Explanation:

The correct answer is C. Indexing documents.

Indexing documents is a query optimization technique that involves creating a data structure that allows faster access to the data in the documents. Indexing documents can reduce the amount of data that needs to be scanned for a particular query, thus improving the performance and efficiency of the query. Indexing documents can also help with searching, sorting, filtering, and aggregating the data in the documents12

asked 02/10/2024
Willians Lima Pereira
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first