PrepAway - Latest Free Exam Questions & Answers

Which two situations could account for the high ratio?

An accounting trace shows a high get page per SQL ratio for a query which retrieves just one row
each time it is executed. Which two situations could account for the high ratio? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use of a matching unique index scan.

B.
Use of anonmatching index scan.

C.
Use of an index with low cardinality.

D.
Use of an index with high cardinality.

E.
Use of a single column index that is a GENERATED ALWAYS identity column.


Leave a Reply