Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 8 Question 69 Discussion

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
B) SELECT
A) WHERE
C) JOIN

Microsoft DP-900 Exam - Topic 8 Question 69 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 69
Topic #: 8
[All DP-900 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: B

by Tyra at Oct 06, 2023, 11:16 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ilda
10 months ago
Wait, are we sure about this? Sounds too simple!
upvoted 0 times
...
Melvin
10 months ago
I agree, hints are key for index usage!
upvoted 0 times
...
Bobbye
10 months ago
Definitely not JOIN, that’s for combining tables.
upvoted 0 times
...
Gilberto
10 months ago
I thought SELECT would do that!
upvoted 0 times
...
Glynda
11 months ago
The correct answer is actually using a hint like INDEX.
upvoted 0 times
...
Tasia
11 months ago
I vaguely recall that using WHERE can help the optimizer choose an index, but I’m not confident if that’s the only option here.
upvoted 0 times
...
Estrella
11 months ago
I’m a bit confused. I thought JOINs were more about combining tables rather than directing the use of indexes.
upvoted 0 times
...
Vannessa
11 months ago
I remember practicing a question about optimizing queries, and I feel like SELECT was involved in that context. Could it be the right choice?
upvoted 0 times
...
Shanice
11 months ago
I think the answer might be related to how we filter results, so maybe it's the WHERE clause? But I'm not entirely sure.
upvoted 0 times
...
Dalene
11 months ago
I've got this! The answer is C - JOIN. When you use a JOIN, the database will try to use indexes on the join columns to speed up the query, rather than doing a full table scan.
upvoted 0 times
...
Linn
11 months ago
I'm a bit confused by this question. I know indexes are important for performance, but I'm not sure which specific T-SQL statement is used to instruct the database to use an index. I'll have to think about this one a bit more.
upvoted 0 times
...
Monroe
11 months ago
Okay, let me think this through. The question is asking about a T-SQL statement to use an index instead of a full table scan. That sounds like it's probably related to the WHERE clause, so I'm going to go with option A.
upvoted 0 times
...
Catrice
11 months ago
Hmm, I'm not sure about this one. I know indexes are used to speed up queries, but I can't remember the exact syntax to force the database to use an index. Maybe it's one of the other options?
upvoted 0 times
...
Lou
11 months ago
This looks like a pretty straightforward question. I'd go with option B - SELECT, since that's the main statement used to retrieve data from a table.
upvoted 0 times
...
Tennie
11 months ago
Hmm, I'm not sure about this one. The options seem a bit confusing - I'll have to think it through carefully.
upvoted 0 times
...
Rebecka
12 months ago
I'm a little confused by the wording of this question. None of the options seem like a perfect fit. I'll have to think about this one a bit more.
upvoted 0 times
...

Save Cancel