You have a SharePoint list named Assets that contains 1,000,000 items. The list contains a
column named Urgent. Approximately 100 items have a value of True in their Urgent column. You
use the following line of code to retrieve the Assets list. SPList assetsList = currentUeb.Lists
[“assets”]; You need to retrieve all of the items in the list that have a value of True in their Urgent

column. You must retrieve the items in the minimum amount of time. What should you do?

A.
Iterate through the assetsList .Items collection.

B.
Iterate through the assetsList .Fields collection.

C.
Call assetsLists. Getltems and specify theSPQuery parameter.

D.
Call assetsList. Items.GetDataTable ( ) and retrieve DataRowCollection