70-573 · Question #58
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…
The correct answer is B. Call assetsLists. Getltems and specify theSPQuery parameter. MNEMONIC RULE: "SPQuery for minimum time" Spquery in Sharepoint 2010-Tutorial
Question
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?
Options
- AIterate through the assetsList .Fields collection.
- BCall assetsLists. Getltems and specify theSPQuery parameter.
- CCall assetsList. Items.GetDataTable ( ) and retrieve DataRowCollection .
- DIterate through the assetsList .Items collection.
How the community answered
(29 responses)- A10% (3)
- B79% (23)
- C3% (1)
- D7% (2)
Explanation
MNEMONIC RULE: "SPQuery for minimum time" Spquery in Sharepoint 2010-Tutorial
Topics
Community Discussion
No community discussion yet for this question.