You need to modify the stored procedure usp.LookupConcurrentUsers. What should you do?

The correct answer is A. Add a clustered index to the summary table. Scenario: Query the current open micropayments for users who own multiple micropayments by using a stored procedure named usp.LookupConcurrentUsers

Design and implement database solutions

Question

You need to modify the stored procedure usp.LookupConcurrentUsers. What should you do?

Options

AAdd a clustered index to the summary table.
BAdd a nonclustered index to the summary table.
CAdd a clustered columnstore index to the summary table.
DUsea table variable instead of the summary table.

How the community answered

(48 responses)

A
81% (39)
B
2% (1)
C
4% (2)
D
13% (6)

Explanation

Scenario: Query the current open micropayments for users who own multiple micropayments by using a stored procedure named usp.LookupConcurrentUsers

Topics

#clustered index#stored procedure optimization#index selection#query performance

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice