Microsoft Azure Data Fundamentals — Question 216

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Answer options

• A. SELECT
• B. WHERE
• C. JOIN

Correct answer: B

Explanation

The correct answer is B, as the WHERE clause is used to filter records based on specified conditions, which can lead the database to utilize indexes for efficient data retrieval. Options A and C do not directly influence index usage; SELECT is for choosing data and JOIN is for combining tables.