ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam
Go to Exam

Exam 70-464 topic 3 question 10 discussion

Actual exam question from Microsoft's 70-464
Question #: 10
Topic #: 3
[All 70-464 Questions]

B\Batch 1 -
While testing usp.GetFutureSessions, you discover that IX_Sessions is accessed by a scan rather than a seek.
You need to minimize the amount of time it takes to execute usp_GetFutureSessions.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
  • E. Option E
  • F. Option F
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
Future delivery dates.
by raja1234567890 at Oct. 7, 2020, 1:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
LiamLin
3 years, 9 months ago
B ERROR: Incorrect WHERE clause for filtered index 'IX_Sessions' on table 'dbo.Sessions'. C Cannot use SEEK because DeliveryTime is not ther first column of index Should be A and E
upvoted 1 times
...
Luzix
4 years, 7 months ago
C also is in the answer because it´s make a covering index.
upvoted 1 times
...
raja1234567890
4 years, 8 months ago
BCE is the answer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel