Categories
Top 50 SharePoint Interview Questions for Freshers
If you're looking for SharePoint Interview Questions, you are at the right place. Mindmajix presenting a list of Top 101 interview questions on Sharepoint for Experienced & Freshers.
1. What is Microsoft SharePoint?
Microsoft SharePoint is a browser-based collaboration and document management platform. It is used for creating websites that access workspaces, documents, as well as host defined applications such as blogs and wikis. We can use it as a secure place for storing, organizing, sharing, and accessing information from any device.
2. What are the benefits a company would be getting after switching to SharePoint 2013?
1) Integrated search
2) Improved workflow
3) Improved business intelligence
4) Ease of storage management
5) Mobile compatibility
6) Social media friendly
7) Enhanced publishing, designing, and metadata management
8) Copy-paste option for content authors
9) Ease of customizing error pages
2) Improved workflow
3) Improved business intelligence
4) Ease of storage management
5) Mobile compatibility
6) Social media friendly
7) Enhanced publishing, designing, and metadata management
8) Copy-paste option for content authors
9) Ease of customizing error pages
3. What is LINQ and how it is useful in SharePoint?
LINQ (language integrated query) uses a SQL-like syntax to frame query expression in an object language way to fetch data from the databases in SharePoint.
4. Explain Zones and types in SharePoint?
Zones are the logical paths for accessing the same web application. For each web application, five zones can be created, and they are-
1) Default
2) Intranet
3) Extranet
4) Internet
5) Custom
1) Default
2) Intranet
3) Extranet
4) Internet
5) Custom
5. What is Sharepoint used for and is it free?
It is comprised of a multipurpose set of technologies used for internal purposes to assist and simplify the workflow within an organization. It is not a free platform; a user has to take a subscription for it.
6. What is SharePoint Sandbox, and why is it used?
Sandbox runs in an isolation area while the normal functions of SharePoint operate as usual. It brings stability to the SharePoint farm by restricting the actions that can cause performance, security, and other related issues.
7. How is the Site template different from the Site definition?
Site templates are pre-built functions designed based on particular business needs. These templates are useful for creating and customizing the SharePoint site.
Whereas, Site definition is mainly a combination of XML or ASPX files that contain information about necessary components. It stores information about libraries, web files, navigation bars, and features to be included on the site.
Whereas, Site definition is mainly a combination of XML or ASPX files that contain information about necessary components. It stores information about libraries, web files, navigation bars, and features to be included on the site.
8. Explain Windows SharePoint Services?
Windows SharePoint Services is a portal-based platform used for information sharing, document collaboration, and customized web services. It is available for free with Windows server 2003. As a platform, it makes use of Windows Server, ASP.Net, and IIS.
Also, it supports webmasters with the development and deployment of applications; locates and shares the documents in a distributed environment.
Also, it supports webmasters with the development and deployment of applications; locates and shares the documents in a distributed environment.
9. What is the latest version of SharePoint and explain its features?
1) The latest version of SharePoint is SharePoint Server 2019.
2) The new features supported by the SharePoint server 2019 are listed below:
SharePoint Home:
It brings all the news from communication sites and team sites together into one central board.
Modern team and communication sites:
The major feature of SharePoint Server 2019 is a modern team and communication site, that includes different templates: topic, blank, and showcase.
User-friendly pages, authoring, and web parts:
Anyone can create content easily with the new user-friendly improvements in the SharePoint Server 2019.
Lists and libraries:
SharePoint Server 2019 also supports modern SharePoint lists and libraries. Modern SharePoint lists include conditional formatting features. Modern SharePoint libraries support users to quickly view their information about documents, including metadata and permissions.
Simplified sharing experience:
This modern feature is a major improvement to secure the external sharing of folders and files.
Suite Navigation and App Launcher:
Microsoft has refreshed the Suite navigation and app launcher feature in the latest release of the SharePoint server.
2) The new features supported by the SharePoint server 2019 are listed below:
SharePoint Home:
It brings all the news from communication sites and team sites together into one central board.
Modern team and communication sites:
The major feature of SharePoint Server 2019 is a modern team and communication site, that includes different templates: topic, blank, and showcase.
User-friendly pages, authoring, and web parts:
Anyone can create content easily with the new user-friendly improvements in the SharePoint Server 2019.
Lists and libraries:
SharePoint Server 2019 also supports modern SharePoint lists and libraries. Modern SharePoint lists include conditional formatting features. Modern SharePoint libraries support users to quickly view their information about documents, including metadata and permissions.
Simplified sharing experience:
This modern feature is a major improvement to secure the external sharing of folders and files.
Suite Navigation and App Launcher:
Microsoft has refreshed the Suite navigation and app launcher feature in the latest release of the SharePoint server.
10. What is the difference between SharePoint Online and Office365?
SharePoint Online and Office 365 do share some capabilities-such as storing documents. Office 365 refers to subscription plans, while SharePoint Online is a collaborative platform that allows an enterprise to store, retrieve, manage, and report on digitized documents.
SharePoint Online:
1) It is a component of cloud-based Office 365, and available as a standalone product.
2) It is a collection of web and cloud-based technologies.
3) Custom workflow is needed for content management.
4) For certain types of content, complex security provisions are required.
5) Collaboration is complex.
Office 365:
1) It offers limited access to multiple functionalities.
2) Collaborations are uncomplicated.
3) It shares the server with various tenants(other subscribers).
4) Supports application model and client-side object.
SharePoint Online:
1) It is a component of cloud-based Office 365, and available as a standalone product.
2) It is a collection of web and cloud-based technologies.
3) Custom workflow is needed for content management.
4) For certain types of content, complex security provisions are required.
5) Collaboration is complex.
Office 365:
1) It offers limited access to multiple functionalities.
2) Collaborations are uncomplicated.
3) It shares the server with various tenants(other subscribers).
4) Supports application model and client-side object.
11. What are service application groups used for?
They provide a logical grouping of services scoped for a particular web application.
12. What is SSS in SharePoint?
SSS stands for secure store service, which is a database to store credentials of the application IDs.
13. What are the different input forms to create a workflow in SharePoint?
1) Association form
2) Initiation form
3) Modification form
4) Task edit form
2) Initiation form
3) Modification form
4) Task edit form
14. What is a module in SharePoint?
A module is a file or group of file instances used to define the location of files during the site creation and also to implement a web part page.
15. What are the common differences between SharePoint 2007 and 2010?
1) Service Applications
2) Sandboxed Solutions
3) Developer Dashboard
4) Throttling and List Controls
5) Business Connectivity Services
6) Claims-Based Authentication
2) Sandboxed Solutions
3) Developer Dashboard
4) Throttling and List Controls
5) Business Connectivity Services
6) Claims-Based Authentication
16. What is the site hierarchy model in SharePoint?
1) Farm
2) Web Application
3) Site Collection
4) Web Site
5) Library/List
2) Web Application
3) Site Collection
4) Web Site
5) Library/List
17. What are a site and MySites?
A site contains web pages and several assets such as lists related to it, whereas MySites are the personalized and targeted SharePoint for every user.
18. Name some of the tools used for backing up the SharePoint 2010 environment?
1) SQL server
2) System center data protection manager
3) SharePoint farm backup and recovery
2) System center data protection manager
3) SharePoint farm backup and recovery
19. Which Microsoft tool can be used for incremental backup?
System center data protection manager
20. What authentication is used by the SharePoint crawler, and what is a federated location in SharePoint search?
The SharePoint crawler used NTLM authentication. Federated locations offer information available outside of the internal network to the end-users.
21. What are the software and hardware requirements of SharePoint 2010?
Hardware requirements:
1) Processor 64-bit, four-core, 2.5 GHz minimum per core
2) 4 GB RAM for evaluation use, 8 GB for single and multiple server farm installation
3) The hard disk of 80 GB for production use and additional space for daily operation
Software requirements:
64-bit edition of Windows server 2008 with SP2
1) Processor 64-bit, four-core, 2.5 GHz minimum per core
2) 4 GB RAM for evaluation use, 8 GB for single and multiple server farm installation
3) The hard disk of 80 GB for production use and additional space for daily operation
Software requirements:
64-bit edition of Windows server 2008 with SP2
22. What is the difference between the SharePoint portal server and the site server?
The basic differences between the SharePoint server and Site server are as follows:
SharePoint portal server
1) Web site creation for data sharing and document collaboration
2) SharePoint server services are the key information worker infrastructure to offer additional functionality to the MS office system.
Site server
1) Manages websites with multiple technologies
2) Order processing, content management, production management, etc.
SharePoint portal server
1) Web site creation for data sharing and document collaboration
2) SharePoint server services are the key information worker infrastructure to offer additional functionality to the MS office system.
Site server
1) Manages websites with multiple technologies
2) Order processing, content management, production management, etc.
23. What are cumulative updates and why they are needed?
These are the periodic release of software updates for SharePoint containing solutions for issues developed since the last cumulative update release. It is crucial to install the latest edition to ensure the full functionality of SharePoint.
24. What are the three editions for SharePoint 2010?
Three editions for SharePoint 2010
1) Foundation
2)Server Standard
3) Server Enterprise
1) Foundation
2)Server Standard
3) Server Enterprise
25. What is STSADM and what it is used for?
It is a command-line tool that was added to SharePoint in the year 2010. It exists in the 14HIVE>BIN folder and is used to create a new site collection.
26. What is impersonation in SharePoint?
It is basically a functionality where something is executed in the context of a different identity such as giving anonymous access to users for the account.
27. What is CAML in SharePoint, and why is its use?
CAML (Collaborative Application Markup Language) is an XML-based language used in SharePoint to define the fields and views in sites and lists
28. What is a.ddf file and why it is used in SharePoint solution creation?
In SharePoint, a.ddf is a data directive file used while specifying the source files and their destination locations.
29. How to make the site public in SharePoint?
By default, all sites are private. To make it public, a user has to enable anonymous access for the entire site. Under each website, a user can create ten sub-sites, each having unique permissions
30. Is it possible to download information directly from a SharePoint site to a PDA?
No, that is not possible.
31. Explain how to create a list in SharePoint 2013?
1) Go to the settings menu and tap on the “Add an app” link to add a custom list
2) Apps section under “Site Contents” will be opened
3) Click on “Custom List” under your Apps
4) Add a description and the name of the list to create a list in SharePoint
2) Apps section under “Site Contents” will be opened
3) Click on “Custom List” under your Apps
4) Add a description and the name of the list to create a list in SharePoint
32. How to create a Task Notifications Workflow in SharePoint?
1) Create a new task list workflow
2) Set the condition to "if the current item priority is high."
3) Set the action to "send an email."
4) Define that the email should be sent to the email address of "Assigned To"
5) Enter an e-mail subject with a lookup to the current item task name.
6) Add a link to the ID of the current task and task list's edit form in the email body
7) Publish the workflow.
2) Set the condition to "if the current item priority is high."
3) Set the action to "send an email."
4) Define that the email should be sent to the email address of "Assigned To"
5) Enter an e-mail subject with a lookup to the current item task name.
6) Add a link to the ID of the current task and task list's edit form in the email body
7) Publish the workflow.
33. What does RunWithElevatedPrivileges do?
To bypass the access-denied error, RunWithElevatedPrivileges is used by a non-privileged user. Users can call the RunWithElevatedPrivileges method provided by the SPSecurity class to make a call into the object model.
34. What does SPWeb.EnsureUser method used for?
It is used to check whether the specified login name is associated with the valid user of the Web site or not. If not, it adds it to the Web site.
35. While fetching List items using SharePoint Web Services, how to specify explicit credentials to access the list items?
To specify explicit credentials, instantiate the web service, and then using the credentials properties use the System.Net.NetworkCredential class and give the username, password, and domain as per your wish.
36. What does the content database handle in SharePoint?
1) The Microsoft SharePoint database handles the following things-
2) Published reports
3) Reports models
4) Shared data sources
5) Properties
6) Resources
7) Permissions
2) Published reports
3) Reports models
4) Shared data sources
5) Properties
6) Resources
7) Permissions
37. How to create a document library in SharePoint?
1) Open a web browser and log into SharePoint.
2) Click Site Actions and select Create.
3) Under Libraries, click Document Library.
4) Enter name and description for the library
5) Click Create.
2) Click Site Actions and select Create.
3) Under Libraries, click Document Library.
4) Enter name and description for the library
5) Click Create.
38. What is a document library in SharePoint?
The document library stores list of files and folders where a user can find out who created which file and can add, download, edit, delete a folder or file from a SharePoint document library.
39. Why we use the Callout function in SharePoint 2013?
SharePoint Callout is used to make several types of commands on the SP(add a new item, update and make site navigation links). The user can append a new record to the SP list without the need to open the default add new SP list item dialogue box.
40. How to manage projects in SharePoint?
To manage projects, SharePoint offers many facilities to users such as
1) Dashboards: The dashboards include customs KPIs; reports and graphs
2) Scheduling tools: used to update and assign multi-level tasks
3) Personalization: Filter out tasks that don’t affect your project
4) Resources: To track cost, display availability, and other related data for hours worked
5) Alerting: To alert about various activities important m
1) Dashboards: The dashboards include customs KPIs; reports and graphs
2) Scheduling tools: used to update and assign multi-level tasks
3) Personalization: Filter out tasks that don’t affect your project
4) Resources: To track cost, display availability, and other related data for hours worked
5) Alerting: To alert about various activities important m
41. What does remove-spouse do in SharePoint?
It removes a user or security group completely from the site.
42. How ULS logs and IIS logs are different?
IIS logs store all data related to HTTP requests made by users. ULS logs will contain details once the user is validated by IIS. It stores all details such as SharePoint services and applications.
43. What is the difference between backup/restore and export/import?
Backup/restore is used for site-level, whereas import/export is used for a list and item level.
44. What is Oauth?
Oauth is open-source authentication used to access third-party apps on the Sharepoint site. Third-party apps use the access tokens to fetch data from the SharePoint server for that user.
45. What are the noticeable changes in SharePoint 2016 and SharePoint 2019 from their previous versions?
SharePoint 2016 has the following improved features as compared to its old versions - Durable, fast site collection creation, Main role, Hybrid search, Shortcut keys for Document library functions links.
SharePoint 2019 has got these features - Modern view for pages, SharePoint online has been introduced, New home page to create sites from the different web application.
SharePoint 2019 has got these features - Modern view for pages, SharePoint online has been introduced, New home page to create sites from the different web application.
46. What is the limit of the SharePoint list or library, and what happens if we increase the limit?
The threshold limit for SharePoint list is 5000, which means when a user clicks/ opens a document library or list, he/she can see 5000 items at a time. If the limit is increased, it will display more, but performance will be affected.
47. List out some SharePoint site monitoring tools?
1) Application Insights
2) SCOM
3) Appdynamics
4) OfficeMax
2) SCOM
3) Appdynamics
4) OfficeMax
48. What are the crawl types in SharePoint?
Crawl is the process of accumulating content for search. To fetch the information, the crawl component connects to the content sources and passes crawled items to the content processing component. There are three main types of SharePoint Crawl - Full Crawl, Continuous crawl, and Incremental crawl.
During the full crawl, the search engine crawls to index each item regardless of previous crawl status. The incremental crawler will enable the crawler to cover only newly created or modified items. Continuous crawl regularly checks the items after every 15 minutes and takes instant action and sends it to the content processor.
During the full crawl, the search engine crawls to index each item regardless of previous crawl status. The incremental crawler will enable the crawler to cover only newly created or modified items. Continuous crawl regularly checks the items after every 15 minutes and takes instant action and sends it to the content processor.
49. Explain the difference between the team site and the communication site in SharePoint?
Team site is a private site used to store documents of particular team activities whereas a communication site is dedicated to customers and all company members and is used to publish details of the new products and services offered by the company.
50. What are the OneDrive sync issues?
OneDrive is a cloud solution to store your data file securely so that you can access it from anywhere. Sometimes, a user might face OneDrive SharePoint sync issues due to-
1) Sync conflicts
2) Item threshold
3) No metadata sync
4) Inability to sync individual folders
1) Sync conflicts
2) Item threshold
3) No metadata sync
4) Inability to sync individual folders
