Home » Microsoft » 70-488 » Which code segment should you insert at line MA08?
You create a document reporting Web Part for the Marketing team auditors.
You need to configure throttling for the Web Part.
Which code segment should you insert at line MA08?
A. spQuery.QueryThrottleMode=SPQueryThrottleOption.Strict;
B. spQuery.QueryThrottleMode=SPQueryThrottleOption.Override;
C. spQuery.QueryThrottleMode=SPQueryThrottleOption.Disable;
D. spQuery.QueryThrottleMode=SPQueryThrottleOption.Default;
Correct Answer: B
Explanation/Reference:
The SPQueryThrottleOption enumeration has three values: Default, Override, and Strict. If you use the default value, the standard list view threshold applies to all users except local server administrators, who are not bound by either threshold. If you set the query throttle mode to Override, users who have the required permissions in the Web application user policy can query at the higher “auditors and administrators” threshold. Local server administrators remain unbound by either threshold. Finally, if you set the query throttle mode to Strict, this closes down the local server administrator loophole and the standard list view threshold applies to all users.
Scenario: Auditors have access to the page that provides statistics on Marketing documents. This page con-tains a report on document distribution over projects and information about the most active doc-uments, the top inactive documents, and the most active users. Processing the queries can result in working with huge result sets. You must ensure that the information on this page is always available and that the queries are not throttled. The relevant code segment is available in the code sections area (MarketingAudit.ascx.es).
Reference: Retrieve data more than the threshold limit
