You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy. What should you do?

The correct answer is A. Query system DMVs to monitor avg_chain_length and max_chain_length. You need to anticipate when POSTransaction table willneed index maintenance. The index maintenance strategy for the UserActivity table must provide the optimal structure for both maintainability and query performance.

Administer SQL Server

Question

You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy. What should you do?

Options

AQuery system DMVs to monitor avg_chain_length and max_chain_length.
BCreate a SQL Agent alert when the File Table:
CQuery system DMVs to monitor total_bucket_count.
DQuery system DMVs to monitor total_bucket_count.

How the community answered

(53 responses)

A
77% (41)
B
8% (4)
C
13% (7)
D
2% (1)

Explanation

You need to anticipate when POSTransaction table willneed index maintenance. * The index maintenance strategy for the UserActivity table must provide the optimal structure for both maintainability and query performance.

Topics

#index maintenance#hash indexes#memory-optimized tables#DMVs

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice