SHAREPOINT INTERVIEW
QUESTIONS & ANSWERS
Safa Ayedi I safaayedi@[Link]
Junior / Fresher Level
1. What is SharePoint and why is it used?
SharePoint is a Microsoft collaboration platform used to store, organize, share, and manage information. It
helps teams collaborate, manage documents, automate workflows, and build internal business applications.
2. What are the different versions of SharePoint?
SharePoint is available as:
SharePoint Online (cloud-based)
SharePoint On-Premise (2016, 2019, Subscription Edition)
3. What is SharePoint Online?
SharePoint Online is the cloud version of SharePoint included in Microsoft 365. It is fully managed by
Microsoft and receives automatic updates.
4. What is a Site and a Subsite?
A Site is an independent workspace. A Subsite exists under another site. In modern SharePoint, Microsoft
recommends using Site Collections instead of Subsites.
5. What is a Document Library?
A Document Library is used to store, manage, version, and share documents securely.
6. What is a SharePoint List?
A SharePoint List stores structured data similar to a database table, using rows and columns.
7. Difference between List and Library?
A List stores structured data, while a Library is designed to store files and documents.
8. What is a Column in SharePoint?
A Column defines the type of data stored, such as text, number, date, choice, or lookup.
9. What is a Content Type?
A Content Type is a reusable collection of columns, workflows, and settings that define a specific type of
content.
10. What are Views in SharePoint?
Views control how data is displayed using filters, sorting, grouping, and conditional formatting.
11. What is Check-in / Check-out?
Check-out locks a document so only one user can edit it. Check-in releases the document for others.
12. What is Versioning?
Versioning keeps track of changes and allows users to restore previous versions of a file.
13. What is a Web Part?
A Web Part is a component that can be added to a SharePoint page to display content or functionality.
14. What are SharePoint Pages?
Pages are used to display content such as text, images, lists, and web parts.
15. Modern vs Classic SharePoint?
Modern SharePoint is responsive, faster, and integrates with Power Platform. Classic SharePoint is outdated.
16. What is OneDrive in relation to SharePoint?
OneDrive is personal storage built on SharePoint technology
Safa Ayedi I safaayedi@[Link]
17. What are Permissions in SharePoint?
Permissions control what actions users can perform, such as read, edit, or full control.
18. SharePoint Groups vs Microsoft 365 Groups?
SharePoint Groups apply only to a site, while Microsoft 365 Groups work across Teams,Outlook,Planner,and SharePoint.
19. What is a Workflow?
A Workflow automates business processes like approvals and notifications.
20. What is the Recycle Bin?
The Recycle Bin temporarily stores deleted items and allows recover
Safa Ayedi I safaayedi@[Link]
Mid-Level (2–5 Years)
21. What are Site Collections?
A Site Collection is a group of SharePoint sites that share common settings, permissions, and features.
22. What are Hub Sites?
Hub Sites connect related sites and provide unified navigation and branding.
23. Team Site vs Communication Site?
Team Sites are used for collaboration, while Communication Sites are used for broadcasting information.
24. How does Permission Inheritance work?
Permissions are inherited from the parent site by default but can be broken when needed.
25. How is Power Automate used with SharePoint?
Power Automate automates workflows such as approvals, notifications, and data synchronization.
26. How does Power Apps integrate with SharePoint?
Power Apps is used to create custom forms and applications connected to SharePoint lists.
27. What is Managed Metadata?
Managed Metadata allows centralized management of terms using the Term Store.
28. How does SharePoint Search work?
Search works by crawling content, indexing it, and returning results based on queries
29. What is the List View Threshold?
The List View Threshold is 5,000 items per view.
30. How do you handle large lists?
By using indexed columns, filtered views, folders, and proper list design.
31. What are SharePoint Templates?
Templates are preconfigured site structures used to create sites quickly.
32. Choice vs Lookup column?
Choice uses static values, while Lookup retrieves data from another list.
33. What is External Sharing?
External Sharing allows sharing content with users outside the organization
34. What is Version History?
Version History allows recovery of previous versions of files or items.
35. What is Co-authoring?
Co-authoring allows multiple users to edit the same document simultaneously.
36. What are SharePoint Add-ins?
Add-ins extend SharePoint functionality using external components.
37. What is REST API in SharePoint?
REST API allows programmatic interaction with SharePoint data.
38. What is SPFx?
SPFx (SharePoint Framework) is a client-side development framework for modern SharePoint.
39. How do you migrate data to SharePoint?
Using tools like SharePoint Migration Tool (SPMT), PowerShell, or third-party tools.
40. What is Microsoft Graph?
Microsoft Graph is a unified API to access Microsoft 365 services.
Safa Ayedi I safaayedi@[Link]
Senior / Architect Level (5+ Years)
41. Explain SharePoint Architecture.
SharePoint architecture includes presentation, service, data, and security layers integrated with Microsoft 365.
42. What is SPFx used for?
SPFx is used to build modern, secure, and scalable SharePoint customizations.
43. SharePoint Online vs On-Premise?
SharePoint Online is cloud-based with automatic updates, while On-Premise is self-hosted and managed internally.
44. How do you design a secure SharePoint solution?
By applying least privilege access, MFA, DLP policies, sensitivity labels, and audit logs.
45. What are Governance best practices?
Governance includes naming conventions, permission management, lifecycle policies, and monitoring usage.
46. How do you handle performance issues?
By optimizing lists, using indexing, CDN, caching, and efficient SPFx code.
47. What is Search Schema?
Search Schema maps crawled properties to managed properties for search optimization.
48. What are Retention Policies?
Retention Policies control how long content is retained or deleted
49. What is Compliance in SharePoint?
Compliance ensures legal and regulatory requirements using tools like eDiscovery and audit logs.
50. What is DLP?
Data Loss Prevention prevents sensitive information from being shared unintentionally.
51. How do you manage backup and restore?
Using version history, recycle bin, and admin-level restore tools.
52. How do you automate SharePoint using PowerShell?
By using PnP PowerShell to manage sites, permissions, and configurations.
53. What is PnP PowerShell?
PnP PowerShell is a set of simplified PowerShell commands for SharePoint management.
54. How do you manage tenant-level settings?
Through the SharePoint Admin Center.
55. What is SharePoint Hybrid?
Hybrid SharePoint combines SharePoint Online and On-Premise environments.
56. How do you handle customizations safely?
By using SPFx, Microsoft Graph, and supported APIs.
57. What are SharePoint limits and boundaries?
They define storage limits, list size limits, and platform constraints.
58. Explain Authentication and Authorization.
Authentication is handled by Azure AD, while authorization is managed through permissions.
59. How do you monitor SharePoint usage?
Using admin reports, audit logs, and Power BI dashboards
60. How do you design SharePoint for enterprise scale?
By using Hub Sites, strong governance, automation, security, and scalable architecture.
Safa Ayedi I safaayedi@[Link]