Page 9 of 10PREVNEXT

SharePoint lists V: Techniques for managing large lists

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


What is the List View Threshold?

10,000 items.

The point at which SharePoint limits your use of a large list.

10,001 items

The point at which SharePoint limits your creation of new items in a list.

Your list has 5,002 items. You create a view. The view contains a filter that only shows items where the column “Product ID” is equal to “A-101.” You’re pretty sure that there should be 510 items in the view. But instead, you get the warning: “Displaying only the newest results below.”

Normally, you don’t mind this warning. But today your boss has asked for a report that contains all 510 items. What should you do?

Simply filter the list without using a view.

Ask your administrator to create the view.

Have your administrator create an index for the Product ID column.

Have your administrator create an index for the Product Name column.

What is the Daily Time Window for Large Queries?

A range of time when you can use your large list without limitation.

7:00PM – 7:00AM every day, Greenwich Mean Time.

A range of time that anyone can configure in Central Administration.

A range of time that your administrator can set up so that you can create a large list of more than 5,000 items.

Your list has 5,002 items. You want to filter the column “Product ID” to see all items where “Product ID” is equal to “A-101.” You’re pretty sure that there should be 510 items as a result. However, when you click the column name to run the filter, you get the warning: “Cannot show the value of the filter.”

Which of the following will NOT allow you to filter and see all 510 items?

Datasheet View.

Export to Excel.

Creating a new view that filters for “Product ID” equal to “A-101.”

Open with Access

Which of the following is the best strategy for managing a large list?

Ask your administrator to turn on the Daily Time Window for Large Queries, from 9:00 AM to 5:00 PM.

Don’t add more than 5,000 items to a list.

Tell your users to use the list very late at night, when most people aren’t using the site.

Make views with filters, so your users see smaller sets of data rather than all of the items.

Page 9 of 10PREVNEXT