Microsoft Exam 70-464 Topic 13 Question 6 Discussion

Actual exam question for Microsoft's 70-464 exam

Question #: 6
Topic #: 13

You need to optimize the index structure that is used by the tables that support the fraud detection services.

What should you do?

AAdd a hashed nonclustered index to CreateDate.

BAdd a not hash nonclustered index to CreateDate.

CAdd a not hash clustered index on POSTransactionId and CreateDate.

DAdd a hashed clustered index on POSTransactionId and CreateDate.
The fraud detection service will need to meet the following requirement (among others):
* Detect micropayments that are flagged with a StatusId value that is greater than 3 and that occurred within the last minute.

Show Suggested Answer

Suggested Answer: A

by Casie at May 04, 2022, 02:02 AM

Limited Time Offer

25%

Off

Get Premium 70-464 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!