You are designing a SharePoint 2010 application that has more than 7,000 items in a list named Customers.
Resource throttling is used to specify a list view threshold of 5,000. You have a requirement to ensure that users
in a domain group named Customer Auditors are allowed to perform operations on all items via a custom
application.
You need to design the application to meet the requirements.
Which approach should you recommend?
A.
Grant Full Read permissions to the Customer Auditors group.
B.
Add the Customer Auditors group to the Site Owners group.
C.
Add the Customer Auditors group to the Administrators group on each Web front-end server.
D.
Add the Customer Auditors group to the Administrators group on the Central Administration server.
Query throttling is a new administrative feature in SharePoint 2010. It allows farm administrators to mitigate the performance issues associated with large lists by restricting the number of items that can be accessed when you execute a query (known as the list view threshold). By default, this limit is set to 5,000 items for regular users and 20,000 items for users in an administrator role.
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquerythrottleoption(v=office.14).aspx=
If the farm administrator has enabled object model overrides, you can also change list view thresholds programmatically. For example, you can do the following:
– Change the global list view threshold for a Web application by setting the SPWebApplication.MaxItemsPerThrottledOperation property. [Not applied in this case]
– Override the list view threshold for an individual list by setting the SPList.EnableThrottling property to false. [Not applied in this case]
– Override the query throttling settings on a specific query by using the SPQueryThrottleOption enumeration. [Applied because custom application for specific users/group]
It does not modify for ordinary users to use List View Threshold when using the object model override way.
In SPQueryThrottleOption (it describes ‘throttling’ that should apply to the query.) for example:
query.QueryThrottleMode = SPQueryThrottleOption.Override;
SPQueryThrottleOption enumeration has three values: Default, Override, and Strict.
Default: The standard list view threshold practical in addition to all of the user’s local server Administrator.
Override: The local server Administrator is not limited, defined in the Web application user policy of auditors and administrators users are subject to the “auditors and administrators” level limits, of course, this value is higher than the standard list view threshold .
Strict: The standard list view threshold useful to all users, including in front of the local server Administrator.
From the above analysis we can determine, we should Customer Auditors this domain group member to the local server Administrator. Because if the user is a local administrator on the server no throttling limits will apply to the query.