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

Exam 70-462 All Questions

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

Exam 70-462 topic 2 question 173 discussion

Actual exam question from Microsoft's 70-462
Question #: 173
Topic #: 2
[All 70-462 Questions]

Which of the following statements will create an index called "SalesDate" on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database?

  • A. CREATE INDEX SalesDate ON SALES (DATEOFSALE);
  • B. MAKE INDEX SalesDate ON SALES (DATEOFSALE);
  • C. CREATE INDEX ON SALES (DATEOFSALE);
  • D. CREATE INDEX SalesDate ON SALES +DATEOFSALE; A
Show Suggested Answer Hide Answer
Suggested Answer: Explanation 🗳️
References:
https://msdn.microsoft.com/en-us/library/ms188783%28v=sql.110%29.aspx
by mr_corte at Nov. 26, 2019, 11:40 a.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
Fame
4 years, 10 months ago
Correct Answer: A
upvoted 1 times
...
mr_corte
5 years, 8 months ago
Answer: A
upvoted 3 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