Microsoft Discussions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Go to Exam

Exam 70-464 topic 3 question 12 discussion

Actual exam question from Microsoft's 70-464

Question #: 12
Topic #: 3

[All 70-464 Questions]

You are evaluating the index design for the database.
You have the following requirements:
✑ minimize the amount of time it takes for usp_AttendeesReport to run
✑ minimize the amount of database fragmentation.
You need to recommend a change to Indexes.sql
Which line of code should you use to replace line 12 of Indexes.sql?

A. (LastName);
B. (FirstName) INCLUDE (LastName);
C. (LastName, FirstName);
D. (LastName) INCLUDE (FirstName);

Show Suggested Answer

Suggested Answer: C 🗳️
Topic 3, Scenario 3

by raja1234567890 at Oct. 7, 2020, 1:36 p.m.

Comments

Submit Cancel

Luzix

4 years, 7 months ago

Answer: D as no FIRST_NAME in filter

upvoted 2 times

...

raja1234567890

4 years, 8 months ago

Answer: D as no FIRST_NAME in filter

upvoted 2 times

...