Which condition must be met so that the optimizer can choose to completely bypass a table and
cover the query through index-only access?

A.
The exclusive lock mode is selected.

B.
OR optimization is performed.

C.
50% percent of the rows are updated.

D.
All columns represented in the query are available in an index.