Top 25 SharePoint Online interview questions and answers

Hello Friends, Below are top SharePoint online interview questions and answers which will be helpful if you are preparing for SharePoint job interviews. We are going to post more SharePoint 2016 interview questions and answers, SharePoint 2013 interview questions and answers, and Office 365 SharePoint Online interview questions and answers.

Here interview questions and answers will be helpful for SharePoint developers as well as SharePoint administrators. Even if you are an experienced developer or you are preparing for SharePoint jobs, these SharePoint online interview questions and answers will be helpful.

If you are looking out for SharePoint end to end training with job placement, you can check out the SharePoint development training course.

SharePoint Online interview questions and answers

Office 365 SharePoint Online interview questions and answers:

1- What is SharePoint Online? How is it related to Microsoft Cloud Service Office 365?

Answer: Office 365 is the cloud service provided by Microsoft which has lots of features. These features can be used as subscription-based. Few services are like Mail, Calendar, People. Yammer, OneDrive, Planner, Task, Delve, Word, Excel, PowerPoint, OneNote, Sway, PowerApps, etc.

Apart from all these services, Microsoft also provides SharePoint as a part of the services. This is known as SharePoint online. It has all the features of SharePoint like the on-premise version. But Microsoft does not allow server-side code in Office 365 SharePoint online. If you want to know the features of Office 365, you can sign up for an Office 365 trial version.

2- What are the difference between SharePoint Online and SharePoint On-Premise?

Answer: There are lots of differences between SharePoint Online and SharePoint on-premise version. In SharePoint on-premise, the server will be maintained by your organization, but in the case of SharePoint online, everything will be maintained by Microsoft, you just need to use it.

Similarly, patches and updates will be taken care of by Microsoft, but in an on-premise environment, everything will be taken care of by your IT team of the organization.

In SharePoint Online, Microsoft does not allow you to deploy any server-side code but we can develop and deploy solutions using the server object model in an on-premise environment.

Alternatively, Microsoft has improved the client-side object model and we can develop and deploy SharePoint Add-ins using the client object model. Check out a very good article on Difference between SharePoint online and SharePoint on-premise

3- What are SharePoint Add-ins? Is it the same as SharePoint Apps

Answer: According to MSDN definition, A SharePoint Add-in is a self-contained piece of functionality that extends the capabilities of SharePoint websites to solve a well-defined business problem. We can develop pages, lists, workflows, custom content types, list templates, Web Parts, etc in SharePoint Add-in.

These are nothing but the Apps which have been introduced in SharePoint Online and SharePoint 2013 versions. Microsoft later renamed Apps to Add-in.

4- What are different types of SharePoint Add-ins?

Answer: There are two kinds of SharePoint Add-ins.

SharePoint Hosted Add-in:
There is no server-side code in case of a SharePoint-hosted add-in. All business logic in a SharePoint-hosted add-in uses JavaScript either directly on a custom page or in a JavaScript file that is referenced from a custom page.

Custom pages in a SharePoint-hosted add-in are generally ASP.NET pages (ASPX) and they can declaratively reference ASP.NET and in-the-box SharePoint controls, but there can be no code behind. However, you can customize the SharePoint controls using a client-side rendering option and custom JavaScript.

The JavaScript in SharePoint-hosted add-ins can access data and resources that are outside of the add-in web by using either of two techniques for safely working around the browser’s same origin policy: a special JavaScript cross-domain library or a specific JavaScript WebProxy class. Using these techniques a SharePoint-hosted add-in can work with data on the host web, its parent subscription.

SharePoint-hosted add-ins consist almost entirely of SharePoint components in an add-in web. A user can run a SharePoint-hosted add-in from a tile on the Site Contents page of the SharePoint website to which it’s installed.

Provider Hosted Add-in:
Any SharePoint component that can be in a SharePoint-hosted add-in can also be in a provider-hosted add-in. But provider-hosted add-ins are distinguished from SharePoint-hosted add-ins because they include at least one remote component; such as a web application, service, or database that is hosted externally from the SharePoint farm or SharePoint Online subscription.

This could be a server in the same corporate network as a SharePoint farm or a cloud service. The external components can be hosted on any web hosting stack, including the Linux, Apache, MySQL, PHP (LAMP) stack.

When the remote components are implemented with .NET, the managed code SharePoint Client-Side Object Model (CSOM) library is available.

For remote components that are not based on .NET, there is a set of REST/OData APIs that can be used to access SharePoint data. These can also be used from a .NET client if you prefer working with an OData interface.

5- How we can deploy a SharePoint Add-in to SharePoint online

Answer: We can deploy the SharePoint Add-ins to the following two places.
SharePoint Add-in Catalog: We can upload the SharePoint Add-in to the organization’s add-in catalog site.

An Add-catalog is nothing but a special collection in SharePoint online which contains a special type of document library that is used to upload and store app package files.

Once you add the add-in to the add-in catalog, the ad-in will be available to all SharePoint site collections.

To the Office Store: We can also deploy SharePoint Add-ins to the Office store. Microsoft has a Seller Dashboard to help you sell add-ins through the Office Store.

After you deploy the add-in in, either way, it’s available for installation on the add add-in page of SharePoint websites.

6- Can we use server-side object model in SharePoint add-in?

Answer: No, we can not use any server-side code in SharePoint Add-in. We can use only client-side code like JavaScript Object Model (jsom) code (SharePoint hosted add-in) or Client-side object model (csom, .Net managed object model code) in Provider hosted add-in.

7- What object model we can use in provider hosted add-in in SharePoint online?

Answer: In provider-hosted add-in, we can use .Net managed object model code (csom). Here we can write code using below two dlls:

  • Microsoft.SharePoint.Client.dll
  • Microsoft.SharePoint.Client.Runtime.dll

8- Can we create web applications in SharePoint online?

Answer: We can not create a web application in SharePoint online. We can create site collections from the SharePoint Admin center.

9- Can we add a custom domain in Office 365 SharePoint online?

Answer: Yes we can add a custom domain in office 365 SharePoint online. You can go to the Office 365 Admin Center and click on +Add a domain in the Domains section.

10- Can we use site collection storage quota in SharePoint online

Answer: Yes we can increase site collection storage quota in the SharePoint site. We can do it from the SharePoint Admin center. Read a SharePoint Online tutorial on SharePoint online Office 365 how to increase SharePoint site storage quota.

11- We have a small organization, which Office 365 plan should I take

Answer: There are lots of plans are available for your business needs. You can check out in Office 365 official site and you can compare and choose.

12- Can we connect to SharePoint Online sites using PowerShell

Answer: Yes, As a developer we can connect to SharePoint Online site collections from PowerShell. We can do lots of operations using PowerShell in SharePoint Online. For this, we need to install the “SharePoint online management shell”.

You check out a details SharePoint blog on How to connect to SharePoint online site using SharePoint Online Management Shell?

13- How can we work with the JavaScript object model in SharePoint online?

Answer: We can do lots of site collection level, list level or item level, etc operations using the javascript object model in SharePoint online. SharePoint provides a script editor web part where we can write the JavaScript object model code. Or we can also develop SharePoint Add-ins and where we can write a JavaScript object model code. You can read some JavaScript Object model (jsom) SharePoint online tutorials.

14- How can we work with Rest API in SharePoint online?

Answer: Like Jsom, we can use Rest API inside a script editor web part or inside SharePoint Add-ins in SharePoint online. You can check out some SharePoint online rest API tutorials.

15- Can we use event receiver in SharePoint online?

Answer: We can not use event receivers in SharePoint online, instead we can use remote event receivers. Remote event receivers can be developed as a provider hosted add-in and can be deployed to Microsoft Azure.

You can read SharePoint remote event receiver tutorial on: Steps to create a Remote event receiver for SharePoint Online and deploy into Microsoft Azure

16- Can we develop visual web part for SharePoint online site?

Answer: We can develop a visual web part as a sandboxed solution for SharePoint online sites. Sandboxed solutions are deprecated nowadays, so better you should develop as a SharePoint Add-in.

17- How can we retrieve SharePoint host web data in-app web in SharePoint Add-ins?

Answer: Yes you can retrieve host web data from add-in web inside SharePoint hosted add-in. Read: How to retrieve host website title in add-in web in SharePoint hosted add-in in SharePoint Online Office 365 Site?

You can also read a SharePoint tutorial on How to retrieve all host web lists in add-in web in SharePoint Online Office 365 in SharePoint hosted add-in?

18- What type of declarative components can you deploy for SharePoint Online?

Answer: Pages, lists, workflows, custom content types, list templates, Web Parts, Content-Type, Site column, etc.

19- Which features differentiate a SharePoint Library from a SharePoint List?

Answer: checkin\check out, Major, Minor version, Document mandatory

20- In SharePoint Libraries, permissions can be granted on which of the following?

Answer: folder,document set ,documents

21- In order for Sally to access sites hosted in SharePoint Online, which two tasks must be performed after her identity is added to Office 365 using directory synchronization?

Answer: 1. An administrator must assign a SharePoint license to Sally
2. Sally must be assigned permissions for the site collection on Office 365.

22- When saving the security certificate used for communications between SharePoint Server on-premises and SharePoint Online, the security certificate must be in which format?

Answer: Base-64 encoded X.509 (.CER)Base-64 encoded X.509 (.CER)

23- A reverse proxy server is required for?

Answer: Outbound search.

24- The protocol for the Result Source used for Outbound search in SharePoint online is?

Answer: Remote SharePoint.

25- What is the difference between host web and app web in SharePoint Online?

Answer: Before starting development in SharePoint Add-in, it is really important to understand what is host web and what is add-in web.

Host Web:
When an add-in that includes SharePoint components is installed on a website, it is listed on the Site Contents page from which it can be launched. That listing, which is the launch point of the add-in, is the only required addition to the website, although certain other things can optionally be added, such as a custom action or an add-in part. The website to which the add-in is installed is called the host web.

Add-in Web:
Other than these UI elements, the SharePoint Add-in components, and content, such as lists, content types, workflows, and pages, are deployed to a different website in a special isolated domain. This fact is largely hidden from the user. The special website to which the add-in is deployed is called an add-in web.

26- What is the SharePoint On-Premises latest version?

SharePoint 2019 is the latest version of SharePoint on-premises. It has lots of new features like the modern SharePoint team site, modern list, and modern libraries.

You can upload files up to 15GB size to SharePoint document library.

The URL path length increased to 400 characters from 260 characters.

I hope all these SharePoint Online interview questions and answers will be helpful.

  • >