SharePoint MCQs (Multiple-Choice Questions)

1. What is Microsoft SharePoint primarily used for?

1. Video game development
2. Collaboration, content management, and information sharing
3. Operating system development
4. Image compression

Answer: B) Collaboration, content management, and information sharing

Explanation:

SharePoint provides capabilities for collaboration, document and content management, intranets, lists, sites, and business applications.

2. Which SharePoint offering is hosted as part of Microsoft 365?

1. SharePoint Online
2. SharePoint Embedded OS
3. SharePoint Desktop
4. SharePoint Runtime

Answer: A) SharePoint Online

Explanation:

SharePoint Online is Microsoft's cloud-hosted SharePoint service available through Microsoft 365.

3. Which SharePoint site type is commonly used for collaboration among team members?

1. Team site
2. Search-only site
3. Archive-only site
4. System site

Answer: A) Team site

Explanation:

Team sites are designed to support collaboration, including sharing documents, lists, and other resources among team members.

4. Which SharePoint site type is primarily designed for publishing information to a broad audience?

1. Communication site
2. Database site
3. Terminal site
4. Execution site

Answer: A) Communication site

Explanation:

Communication sites are designed to communicate information, news, and organizational content to a broader audience.

5. What is a SharePoint list primarily used for?

1. Storing structured business data
2. Compiling operating-system drivers
3. Rendering video files
4. Creating executable programs

Answer: A) Storing structured business data

Explanation:

SharePoint lists provide structured storage for business data using columns and list items.

6. What is a SharePoint document library?

1. A specialized list for storing and managing files
2. A database server
3. A SharePoint scripting engine
4. A browser extension

Answer: A) A specialized list for storing and managing files

Explanation:

A SharePoint document library is a special type of list used to store files and their associated metadata.

7. What is a list item in SharePoint?

1. A single record stored in a SharePoint list
2. A SharePoint site collection
3. A web server process
4. A SharePoint theme

Answer: A) A single record stored in a SharePoint list

Explanation:

A list item represents one record in a SharePoint list. Its column values contain the data associated with that item.

8. What defines the type of data stored in a SharePoint list field?

1. Column type
2. Site theme
3. Page layout
4. Navigation style

Answer: A) Column type

Explanation:

SharePoint columns have types such as text, number, date, choice, person, lookup, and hyperlink that define the data they can store.

9. What is a SharePoint content type?

1. A reusable definition of metadata and behavior for a type of content
2. A browser cache
3. A site theme
4. A network protocol

Answer: A) A reusable definition of metadata and behavior for a type of content

Explanation:

A content type defines a reusable set of columns and other characteristics for items or documents.

10. What is a site column in SharePoint?

1. A reusable column definition that can be used across lists and libraries
2. A page header
3. A navigation menu
4. A document library folder

Answer: A) A reusable column definition that can be used across lists and libraries

Explanation:

Site columns provide reusable field definitions that can be incorporated into content types and lists or libraries.

11. Which technology is the recommended development model for extending modern SharePoint Online?

1. SharePoint Framework (SPFx)
2. Classic COM automation
3. Windows Forms
4. ASP.NET Web Forms only

Answer: A) SharePoint Framework (SPFx)

Explanation:

Microsoft identifies the SharePoint Framework as the recommended development model for extending the modern SharePoint experience.

12. What does SPFx stand for?

1. SharePoint Framework
2. SharePoint Function Extension
3. SharePoint File Exchange
4. SharePoint Framework XML

Answer: A) SharePoint Framework

Explanation:

SPFx is the SharePoint Framework, Microsoft's client-side development and extensibility model for SharePoint and related Microsoft 365 experiences.

13. What type of component is an SPFx web part?

1. A client-side component that can be added to a SharePoint page
2. A Windows kernel module
3. A SQL Server stored procedure
4. A SharePoint database table

Answer: A) A client-side component that can be added to a SharePoint page

Explanation:

SPFx web parts are client-side components that can be placed on modern SharePoint pages to provide custom functionality.

14. Which language is commonly used with TypeScript-based SPFx development?

1. TypeScript
2. COBOL
3. Fortran
4. Assembly only

Answer: A) TypeScript

Explanation:

SPFx development commonly uses TypeScript together with modern JavaScript tooling and web technologies.

15. Which SPFx extension type can customize areas such as headers or other page placeholders?

1. Application Customizer
2. Database Customizer
3. SQL Customizer
4. Server Customizer

Answer: A) Application Customizer

Explanation:

An SPFx Application Customizer can add custom client-side functionality to designated page placeholders and other supported areas.

16. Which SPFx extension is used to customize the rendering of field values in a list?

1. Field Customizer
2. Application Customizer
3. Page Customizer
4. Site Customizer

Answer: A) Field Customizer

Explanation:

A Field Customizer provides a customized rendering of data for fields within a SharePoint list.

17. Which SPFx extension adds custom actions to SharePoint command surfaces?

1. Command Set
2. Field Set
3. Application Set
4. Page Set

Answer: A) Command Set

Explanation:

SPFx Command Sets extend SharePoint command surfaces by adding custom actions and client-side behaviors.

18. Which API can be used to access SharePoint sites and content through Microsoft Graph?

1. Microsoft Graph API
2. Direct SQL API
3. Windows Registry API
4. COM Database API

Answer: A) Microsoft Graph API

Explanation:

Microsoft Graph provides APIs for working with SharePoint sites, lists, list items, document libraries, and other Microsoft 365 resources.

19. Which resource represents a SharePoint list in Microsoft Graph?

1. list
2. table
3. collection
4. shareList

Answer: A) list

Explanation:

Microsoft Graph represents a SharePoint list using the list resource. A list has relationships to columns, content types, items, and other resources.

20. Which Microsoft Graph resource represents an item in a SharePoint list?

1. listItem
2. listRecord
3. shareItem
4. recordItem

Answer: A) listItem

Explanation:

Microsoft Graph represents an item in a SharePoint list with the listItem resource. Column values are exposed through its field value set.

21. Which API endpoint style is associated with the SharePoint REST service?

1. /_api/web
2. /sharepoint/sql
3. /sp/database
4. /api/sharepointdb

Answer: A) /_api/web

Explanation:

SharePoint's REST service uses endpoints such as /_api/web to work with SharePoint objects and data.

22. Which HTTP method is commonly used to create a new list item through a REST API?

1. POST
2. GET
3. HEAD
4. TRACE

Answer: A) POST

Explanation:

POST is commonly used when creating resources through SharePoint REST APIs, such as adding a new list item.

23. Which HTTP method is primarily used to retrieve SharePoint data through REST?

1. GET
2. POST
3. DELETE
4. PATCH

Answer: A) GET

Explanation:

GET requests are used to retrieve resources such as lists, list items, and other SharePoint objects through REST APIs.

24. What is the purpose of an ETag in SharePoint REST operations?

1. To help manage version or concurrency information
2. To specify a document's file extension
3. To define a site's theme
4. To authenticate a browser without credentials

Answer: A) To help manage version or concurrency information

Explanation:

ETag values can be used to identify the current version of a resource and help control concurrent updates in SharePoint REST operations.

25. What is the purpose of Microsoft Graph's contentType resource?

1. To represent a SharePoint content type
2. To represent a SharePoint user session
3. To represent a SharePoint theme
4. To represent a site navigation node only

Answer: A) To represent a SharePoint content type

Explanation:

Microsoft Graph provides a contentType resource for SharePoint content types, which can define columns that apply to list items.

26. Which object is commonly used to identify the current SharePoint web in server-side SharePoint APIs?

1. SPWeb
2. SPPage
3. SPBrowser
4. SPTheme

Answer: A) SPWeb

Explanation:

In the classic SharePoint server object model, SPWeb represents a SharePoint website.

27. Which classic SharePoint object represents a SharePoint site collection?

1. SPSite
2. SPCollection
3. SPSiteWeb
4. SPRoot

Answer: A) SPSite

Explanation:

In the classic SharePoint server object model, SPSite represents a site collection.

28. Which technology is commonly used to query SharePoint data from client-side .NET applications?

1. CSOM
2. ADO Classic only
3. WinForms API
4. Registry API

Answer: A) CSOM

Explanation:

SharePoint Client-Side Object Model (CSOM) provides client-side APIs for interacting with SharePoint from supported application environments.

29. What does CSOM stand for?

1. Client-Side Object Model
2. Cloud SharePoint Object Manager
3. Client SharePoint Online Module
4. Content Server Object Model

Answer: A) Client-Side Object Model

Explanation:

CSOM stands for Client-Side Object Model and provides APIs for interacting with SharePoint objects from client applications.

30. Which Microsoft Graph API can be used to create a column in a SharePoint list?

1. The list columns API
2. The user profile API only
3. The Teams chat API only
4. The mail API only

Answer: A) The list columns API

Explanation:

Microsoft Graph provides an endpoint under a list resource for creating a column definition, such as POST /sites/{site-id}/lists/{list-id}/columns.

31. Which feature can be used to control the type of values users can enter into a SharePoint column?

1. Column type
2. Site theme
3. Page template only
4. Navigation menu

Answer: A) Column type

Explanation:

Column definitions specify how data is stored and entered, such as text, number, date, choice, person, or lookup values.

32. Which SharePoint feature can be used to organize reusable metadata across multiple content types?

1. Site columns
2. Site themes
3. Page comments
4. Navigation nodes

Answer: A) Site columns

Explanation:

Site columns provide reusable metadata definitions that can be incorporated into content types and used across SharePoint lists and libraries.

33. Which SharePoint component can define a reusable collection of columns for documents or list items?

1. Content type
2. Web browser
3. Theme
4. Page navigation

Answer: A) Content type

Explanation:

Content types allow organizations to define reusable metadata and content structures for specific types of documents or list items.

34. What is the primary purpose of a SharePoint view?

1. To display list or library data in a selected arrangement
2. To create a new operating system
3. To compile TypeScript code
4. To replace SharePoint authentication

Answer: A) To display list or library data in a selected arrangement

Explanation:

Views control how list or library information is displayed and can include filtering, sorting, grouping, and selected columns.

35. Which SPFx component can be used to display custom functionality on a modern SharePoint page?

1. Web part
2. Database trigger
3. Windows service
4. SQL view

Answer: A) Web part

Explanation:

SPFx web parts are client-side components designed to provide custom functionality that can be added to modern SharePoint pages.

36. Which Microsoft Graph client is specifically provided for consuming Microsoft Graph from SPFx solutions?

1. MSGraphClientV3
2. SharePointGraphClient
3. SPGraphClient
4. GraphShareClient

Answer: A) MSGraphClientV3

Explanation:

Microsoft documents the native MSGraphClientV3 as the SPFx-provided client for calling Microsoft Graph from SPFx solutions.

37. Which library provides a fluent API for working with SharePoint data from SPFx applications?

1. PnPjs
2. WinFormsJS
3. SharePointSQL
4. SPDatabaseJS

Answer: A) PnPjs

Explanation:

PnPjs is an open-source library that provides fluent APIs for SharePoint REST queries and supports capabilities such as batching and caching.

38. Which technology is commonly used to automate SharePoint provisioning and administration from PowerShell?

1. PnP PowerShell
2. SQL PowerShell only
3. WebForms PowerShell
4. HTML PowerShell

Answer: A) PnP PowerShell

Explanation:

PnP PowerShell provides PowerShell commands for automating many SharePoint and Microsoft 365 administration and provisioning tasks.

39. Which SharePoint feature is used to control who can access content?

1. Permissions
2. Page layout
3. Theme
4. View formatting

Answer: A) Permissions

Explanation:

SharePoint permissions determine what users or groups can do with sites, lists, libraries, folders, and items.

40. Which SharePoint permission level generally allows a user to modify existing list or library content without full control over the site?

1. Edit
2. Read
3. View Only
4. Limited Access

Answer: A) Edit

Explanation:

The Edit permission level allows users to add, edit, and delete lists and documents and other supported content within the granted scope.

41. What is a SharePoint group primarily used for?

1. Grouping users to simplify permission management
2. Compiling SharePoint code
3. Storing SQL queries
4. Creating browser tabs

Answer: A) Grouping users to simplify permission management

Explanation:

SharePoint groups allow administrators and site owners to assign permissions to collections of users rather than configuring each user individually.

42. What is the main purpose of a SharePoint document library column?

1. To store metadata associated with documents
2. To compile documents into executable files
3. To replace document permissions
4. To convert documents into databases

Answer: A) To store metadata associated with documents

Explanation:

Columns in document libraries store metadata such as department, document type, status, date, or owner.

43. Which Microsoft Graph relationship allows a SharePoint list to expose its columns?

1. columns
2. fieldsOnly
3. schemaOnly
4. listColumnsOnly

Answer: A) columns

Explanation:

The Microsoft Graph list resource exposes a columns relationship containing the field definitions for the list.

44. Which Microsoft Graph resource can represent a file in a SharePoint document library?

1. driveItem
2. fileTable
3. documentObject
4. shareFile

Answer: A) driveItem

Explanation:

Microsoft Graph can represent files in SharePoint document libraries as drive items. Library items can also be represented through the SharePoint list-item model.

45. Which statement about SharePoint document libraries is correct?

1. They are a special type of SharePoint list used for files
2. They can store only plain text values
3. They cannot have custom metadata
4. They cannot be accessed through APIs

Answer: A) They are a special type of SharePoint list used for files

Explanation:

Microsoft describes document libraries as a special list type for storing files. They can also be extended with custom columns for metadata.

46. Which SharePoint API approach can be used to combine multiple REST requests into one request?

1. OData $batch
2. REST $combine
3. HTTP $mergeall
4. SharePoint $multi

Answer: A) OData $batch

Explanation:

The SharePoint Online REST service supports the OData $batch query option for combining multiple requests into a single service call.

47. Which approach is recommended when creating SharePoint site columns and content types programmatically in modern SharePoint solutions?

1. SharePoint CSOM or REST APIs
2. Direct SQL database modification
3. Windows Registry editing
4. Browser cookie manipulation

Answer: A) SharePoint CSOM or REST APIs

Explanation:

Microsoft guidance recommends using SharePoint CSOM or REST APIs for programmatic creation of site columns and content types rather than directly modifying SharePoint databases.

48. What is the main advantage of using Microsoft Graph for SharePoint development?

1. It provides a unified API surface for SharePoint and other Microsoft 365 services
2. It requires direct access to SharePoint SQL databases
3. It works only with SharePoint Server 2010
4. It replaces all SharePoint permissions

Answer: A) It provides a unified API surface for SharePoint and other Microsoft 365 services

Explanation:

Microsoft Graph provides a unified API surface across Microsoft 365 services, including SharePoint sites and content.

49. What does the following Microsoft Graph request retrieve?

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items

1. The items in the specified SharePoint list
2. The permissions of the entire Microsoft 365 tenant
3. The columns of every SharePoint site
4. The source code of the SharePoint site

Answer: A) The items in the specified SharePoint list

Explanation:

The Microsoft Graph list-item endpoint retrieves the collection of items belonging to the specified SharePoint list.

50. An SPFx web part needs to retrieve data from a SharePoint list and display selected fields on a modern SharePoint page. Which approach directly fits this requirement?

1. Build the web part with SPFx and use a supported SharePoint data API such as Microsoft Graph or SharePoint REST
2. Modify the SharePoint SQL database directly from the browser
3. Replace the SharePoint site with a Windows service
4. Store the list data in the browser's local registry

Answer: A) Build the web part with SPFx and use a supported SharePoint data API such as Microsoft Graph or SharePoint REST

Explanation:

SPFx is the recommended extensibility model for modern SharePoint Online, and Microsoft documents both Microsoft Graph and SharePoint REST as supported ways to work with SharePoint data. An SPFx web part can therefore retrieve list data through an appropriate API and render the required fields on the page.