nerdexam
Microsoft

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

Developing for Data Access

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)
  • A
    10% (3)
  • B
    79% (23)
  • C
    3% (1)
  • D
    7% (2)

Explanation

MNEMONIC RULE: "SPQuery for minimum time" Spquery in Sharepoint 2010-Tutorial

Topics

#SPQuery#large list#list query performance#CAML

Community Discussion

No community discussion yet for this question.

Full 70-573 Practice