Microsoft
DP-900 · Question #143
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Sign in or unlock DP-900 to reveal the answer and full explanation for question #143. The question stem and answer options stay visible for context.
Submitted by emma.c· Mar 30, 2026Identify considerations for relational data on Azure
Question
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Options
- ASELECT
- BWHERE
- CJOIN
Unlock DP-900 to see the answer
You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#T-SQL#index hints#query optimization#full table scan