sharepoint interview questions and answers

Sharepoint Interview Questions and Answers

by GangBoard Admin, November 24, 2018

In case you’re searching for Sharepoint  Interview Questions and answers for Experienced or Freshers, you are at the correct place. There is parcel of chances from many presumed organizations on the planet. The Sharepoint  advertise is relied upon to develop to more than $5 billion by 2020, from just $180 million, as per Sharepoint  industry gauges. In this way, despite everything you have the chance to push forward in your vocation in Sharepoint  Development. Gangboard offers Advanced Sharepoint  Interview Questions and answers that assist you in splitting your Sharepoint  interview and procure dream vocation as Sharepoint  Developer.

Best Sharepoint  Interview Questions and Answers

Do you believe that you have the right stuff to be a section in the advancement of future Sharepoint , the GangBoard is here to control you to sustain your vocation. Various fortune 1000 organizations around the world are utilizing the innovation of Sharepoint  to meet the necessities of their customers. Sharepoint  is being utilized as a part of numerous businesses. To have a great development in Sharepoint  work, our page furnishes you with nitty-gritty data as Sharepoint  prospective employee meeting questions and answers. Sharepoint  Interview Questions and answers are prepared by 10+ years experienced industry experts. Sharepoint  Interview Questions and answers are very useful to the Fresher or Experienced person who is looking for the new challenging job from the reputed company. Our Sharepoint  Questions and answers are very simple and have more examples for your better understanding.

By this Sharepoint  Interview Questions and answers, many students are got placed in many reputed companies with high package salary. So utilize our Sharepoint  Interview Questions and answers to grow in your career.

In case you are searching for Sharepoint Interview Questions and answers, then you are at the correct place. Our Sharepoint Interview Questions and answers are prepared by 10+ years exp professionals.

Q1) How to fetch ULS logs for Correlation ID in SharePoint online?

Use Get-SPOTenantLogEntry SharePoint online command

Q2) How to fetch ULS logs for Correlation ID in SharePoint on-premise?

Use Merge-SPLogfile SharePoint command

You can get logs per hourly basis, per user and also Area related logs like Search, SharePoint Foundation.

Q3) What is ULS viewer?

A windows application for viewing SharePoint ULS log files more easily. Supports filtering and easy viewing of data

Q4) How many SharePoint is old and list the versions of SharePoint?

17 Years old, Versions: SharePoint 2001, SharePoint server portal 2003, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016,sharepoint 2019 and SharePoint online

Q5) What are the notable changes in SharePoint 2016 and SharePoint 2019 from previous versions?

2016- Fast site collection creation, Main role, Hybrid search, Durable, Shortcut keys for Document library functions links; 2019- Modern view for pages, list, library, like SharePoint online has been introduced, New home page where you have the ability to create sites from the different web application

Q6) What are deprecated features in SharePoint 2016 and SharePoint 2019?

2016-SharePoint Foundation, Excel Services, Forefront Identity Management Service, stsadm.exe;2019-Infopath, Sharepoint Designer, Site Mailbox, Site Manager

Q7) What are teams?

Teams is part of office 365 which comprises skype, Sharepoint, Onenote, Conversations and SharePoint mail box. Client software is available for teams.

Q8) What is Power apps?

Power apps is an alternative to InfoPath which is used to customize SharePoint list forms.

Q9) What is Flow?

Flow is an alternative to SharePoint Designer workflow which is used to enable workflow for list items based on the available flow templates

Q10) What is Office 365 groups?

Office 365 groups are part of Office 365 which comprises conversations, SharePoint site, and Shared mailbox

Q11) What is a difference between IIS logs and ULS logs?

IIS logs have details about HTTP request made by a user. It will have user IP, computer name.

ULS logs will have details after the user is authenticated by IIS. It will have all SharePoint services, service application, what is happening inside SharePoint logs.

Q12) What is a difference between a team site and communication site?

Team site is for internal team collaboration. It is a private site for storing your project documents, working on documents as a team. Communication site is targeted on customer or the whole company, It has details about a new product, new services offered by your company or to publish some news to your organization. Teams sites can be connected to Office 365 group and Teams whereas office 365 groups can’t be connected

Q13) Difference between services in Services in farm and Services in-service.msc?

Services are logical entities installed to the farm, while service instances are server-specific aspects of the service deployed to individual servers

Q14) What happens if SharePoint Timer Service is stopped?

If it stops, all services and timer jobs controlled by the SharePoint timer service will be stopped,

Q15) What is distributed cache service?

The Distributed Cache service provides in-memory caching services to several features in SharePoint Server 2016 IT Preview.

The features  use Distributed Cache service include:

  • Newsfeeds
  • OneNote client access
  • Authentication
  • Security Trimming
  • Page load performance

Q16) What happens if the distributed cache is stopped?

If the cache Cluster is down then you will see Runtime error, unexpected error, access denied, no newsfeed, page loading slowly and so on.

Q17) How much memory is taken by Distributed cache?

When SharePoint Server is installed, it assigns the Distributed Cache service 10 percent of the total physical memory on the server

Q18) What is the main role in SharePoint 2016?

A new farm topology based on MinRole a set of predefined server roles introduced in SharePoint Server2016. SharePoint Server 2016 and 2019 has been optimized for the MinRole farm topology SharePoint will automatically configure the services on each server based on the server’s role.

Q19) What are the types of Man role?

Ans: Front-end, Application, Search, Distributed Cache, Custom

Q20) What is a zone?

SharePoint “Zones” are ways for you to create new entrances for people access your content.  They are not like additional web applications or site collections that create new locations for content.  But rather – think of your content like a house and the default zone is the front door into the house.  Adding an additional zone gives you additional “doors” into your content.
With that new door can be a new address like a new or different URL from the front door – or maybe just a new protocol which to access the date (http or https).
These zones enable you to create what are called “Alternate Access Mappings”.

Q21) What are the types of a zone?

Zones are of Five types:

  • Internet
  • Intranet
  • Extranet
  • Custom
  • Default

Q22) 1000 users, plan SharePoint deployment?

Small farm, 1WFE, 1APP,2 SQL servers clustered and Always-On

Q23) What is web jobs in Azure?

To run some script in a server, you can create web jobs from an Azure portal. It avoids the need for logging the server to perform the activity

Q24) Explain Search Architecture 2013?

You have to explain all the components

Q25) How to troubleshoot Solution Deployment issues?

First, check if a solution has properly installed and working in Dev and UAT environment. Then check if the solution is not getting deployed in any particular server. All servers should be UP and running. Check if the timer service is running in all servers. Check if any custom Timer job is stopped. Make sure you are not deploying solutions from a shared path. Try using stsadm commands if SharePoint commands are not helping.

Q26) How you will configure Software Load balancer in SharePoint?

Load balance can be 2 types. Software load balancer and Hardware load balancer.

Software load balancer- You can use windows load balancer feature to configure/ Software load Balancer SLB)

Q27) How you will configure Hardware Load balancer in SharePoint?

Hard load balancer- F5 load balancer

Q28) What is Oauth?

Oauth is open source authentication. Allow users to access third party apps in Sharepoint site.

SharePoint provides access tokens to Third party apps. Third party apps use the tokens to retrieve data from the SharePoint server for that user.

A flow of Oauth:

1)User authenticated sharepoint using claim

2)sharepoint request client context from ACS

3)ACS provide client context to sharepoint

4)Sharepoint passes client context to User

5)User posts to app passing client context

6)client app is able to pull  refresh token out of client content and request outh from ACS

7)ACS returns oauth token to a client app

8)client app makes cson/rest api calls to sharepoint site passing oauth token

9)sharepoint returns site content to the app

10)client app returns html code to a user device

ACS- Azure access control service.

Q29) What are the types of authentication?

Classic- Windows, NTLM, Kerberos

Claims- ADFS, Form based authentication

Q30) What is ADFS authentication?

ADFS provides single sign-on and access to an external resource

Q31) What is lookup columns in SharePoint?

To use a column values in another list within site or subsite we use lookup columns

Q32) OneDrive sync issues?

OneDrive sync issues main causes

1)Space issue in local machine

2)File length issue

3) Special characters

Q33) How you will restore deleted users OneDrive?

Use Restore-Spodeletedsite command

Q34) Difference between backup/restore vs import/export?

Backup/restore is for site level whereas import/export is for a list and item level

Q35) How you will provide access to Gmail account to your SharePoint online site?

Make sure external sharing is enabled in the site. Once it is enabled add the user in the site. User will receive the invitation in his Gmail. He should accept the invitation to login the site.

Q36) access install account have on SQL?

security admin and db creator

Q37) What is a farm account?

Account which is running SharePoint timer service is farm account

Q38) What is a standalone installation?

Installing SharePoint and SQL in the same server

Q39) Difference between contribute Vs Edit and Read Vs Edit?

Contribute- Add/edit/delete list items

Edit-Contribute+ Manage Lists ie able to add new list/library and manage

Read- Able to view and download documents

View-Able to view documents

Design-Edit+ Approve list items, Customize pages

List PermissionContributeEdit
Manage Lists NOYES
Override List Behaviours NO NO
Add Items YES YES
Edit Items YESYES
Delete ItemsYESYES
View ItemsYESYES
Approve ItemsNO NO
Open ItemsYESYES
View VersionsYESYES
Delete VersionsYESYES
Create AlertsYESYES
View Application PagesYESYES

Q40) Command to mount Content Database?

Mount-SPContentDatabase –Name (Name of Content DB) –Databaseserver (DB server name) –WebApplication (web app url)

Q41) How to add a new search server?

Before you add search components to the server, first start search server instance. It will start both search windows service

$<host n > = Get-SPEnterpriseSearchServiceInstance -Identity “<Server name>”

Start-SPEnterpriseSearchServiceInstance -Identity $<host n >

Run Get-SPEnterpriseSearchServiceInstance to check both the service is running.

Get Active Search topology and clone it then add the component

$ssa = Get-SPEnterpriseSearchServiceApplication

$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active

Get-SPEnterpriseSearchComponent -SearchTopology $active

$ssa = Get-SPEnterpriseSearchServiceApplication

$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active

$clone = New-SPEnterpriseSearchTopology -SearchApplication $ssa -Clone -SearchTopology $active

  • New-SPEnterpriseSearchAdminComponent
  • New-SPEnterpriseSearchAnalyticsProcessingComponent
  • New-SPEnterpriseSearchContentProcessingComponent
  • New-SPEnterpriseSearchCrawlComponent
  • New-SPEnterpriseSearchQueryProcessingComponent

Q42) Request Management service?

Request Management feature in SharePoint 2013 manages incoming requests by evaluating logic rules against the user requests in order to determine what/which action to take, and which machine or machines in the farm should handle the requests

Q43) How many days SharePoint online sites are backed up?

14 days

Q44) What does remove-spouser do?

It removes use completely from the site

Q45) List the Migration Tools?




Q46) What is GAC?

Global Assembly Cache (or just, GAC) is an extraordinary organizer in Windows intended for putting away .NET global DLLs. At the point when SharePoint cultivate arrangements are sent the DLL’s are spared in GAC organizer.

Q47) What is the minimum hardware requirement for SharePoint 2013?

For Single server with a built-in database it is recommended to use

RAM : 8 GB

Processor : 64-bit, 4 cores

Hard disk: 80 GB for system drive

For Web server or application server in a three-tier farm, it is recommended to use

RAM : 12 GB

Processor : 64-bit, 4 cores

Hard disk : 80 GB for system drive

Q48) What is the Power shell command to install farm solution package?

Install-SPsolution -literalpath “sharepointfarmsolution.wsp”  -GACD eployment

Q49) What is SharePoint?

SharePoint is a web-based business collaborative platform integrated with Microsoft office. Its primarily used  as a secure place to store, organize, share, and access information.

  •  Provides business services
  •  Supports Extensibility
  •  Enables integration with external sites/services

 Q50) Name some of the additional features in Sharepoint:

  •  SharePoint Apps
  •  BCS
  •  SharePoint 2013 Work
  •  Managed Metadata
  •  Enterprise Search

Q51) What is the max number of  web applications created in a farm?

It is recommended to create only 20 web applications per farm.

Q52) What is a web application?

A web application is he highest level component in the logical architecture of SharePoint. It  is composed of an Internet Information Services (IIS) web site that acts as a logical unit for the site collections.Web applications have their own “application pools”.

Q53) What is Secure Store service?

The Secure Store Service is an authorization service which provides a database that is used to store credentials. They usually consist of a user identity and password, but can also contain other fields.

Q54) What are the advantages of application pool?

Application pool separates sets of IIS worker processes that share the same configuration and application boundaries Provides better security, reliability, availability and performance Each can run without impacting one another Web applications can share application pools.

Q55) What is the maximum number of content database per farm?

A farm can have a maximum of 500 content databases.

Q56) Explain the types of Managed Path

A wildcard inclusion allows us to append multiple site collections to the path that we specify. An explicit inclusion allows us to create a single site collection with the specified address.

Q57) Is it recommended to disable loop back check in production environment?

No, Its not recommended to disable loop back check in production environment. The recommended way is to add the host name or the host names for the sites in Back Connection Host Names registry key

Q58) What is Incremental Crawl and Continuous Crawl?

Steady Crawls are look crawlers that accumulate the progressions made since the last creep. Gradual Crawls and Full Crawls can’t be kept running in parallel. They assume responsibility and hoard the entire crawler asset. This likewise makes it conceivable to have extremely obsolete indexed lists. A steady slither may not get changes that occur while the gradual creep is running. Constant Crawl settles this issue. It might produce a few sessions in 15 minute interims, that will get the progressions and additionally the progressions made amid the Continuous Crawl. It will amplify the freshness of your pursuit content.

Q59) What is Full crawl?

All the content specified by the content source is crawled even if the content already exists in the search index.

Q60) What is the threshold limit for sharepoint online list view and how it can be handled?

5000 is the threshold for list view and it can be handled by creating folders and moving the items or by filtering to display the latest items.

Q61) What is the difference between SharePoint 2013 and 2016?

In 2016, O365 applications are fully integrated and hybrid search is wizard-driven instead of powershell scripts as in 2013

Q62) What is a timer job?

A Timer Job is an occasionally executed assignment inside SharePoint Server. It can do different errands inside the SharePoint condition on a planned time occasion premise.

Q63) Role of content source in sharepoint.

At the point when a Search benefit application is made, a substance source named “Neighborhood SharePoint destinations” is naturally made and designed for slithering all SharePoint Server destinations in the nearby server cultivate. We can make extra substance sources to determine other substance to creep and how the framework should slither that content.

Q64) What are sandbox and farm solutions?

Farm solutions run on W3WP.exe and farm solutions run on SPUC Worker Process.exe.Application pool is recycled while deploying farm solutions.

Q65) What is the role of Managed Metadata Service?

Managed metadata is a hierarchical collection of centrally managed terms that we can define and then use as attributes for items in sharepoint server 2013.

Q66) What are the ways of backing up and restoring site collection?

Using power shell commands or in the central administration.

Q67) What is Managed account and where it is used?

Managed accounts are service accounts managed by sharepoint.They are used for creation of service applications and web applications.

Q68) What is the powershell command to move site collection between content database?

Get-SPSite -ContentDatabase <SourceContentDb> | Move-SPSite -DestinationDatabase <DestinationContentDb>

Q69) How to make a sharepoint site public?

It can be made public by enabling “Anonymous access” in web app settings.

Q70) What are most commonly used applications by SharePoint Administrator?

  •  Sharepoint Designer
  •  Infopath Designer
  •  ULS viewer
  •  Powershell

Q71) What is a site column?

A site column is a reusable column definition, or template, that one can assign to multiple lists across multiple SharePoint sites. Site columns are useful if an organization wants to establish some consistent settings across lists and libraries.

Q72) What is a content type?

A substance type is a reusable gathering of metadata (segments), work process, conduct, and different settings for a classification of things or archives in a SharePoint Server rundown or report library. Content sorts empower you to deal with the settings for a classification of data in a concentrated, reusable manner .

Q73) How auditing is done in Sharepoint?

Under site settings audit logs will be available from there it can be generated and analysed for organisation use.

Q74) What is the difference between sharepoint online and sharepoint 2013?

Sharepoint online is hosted in cloud and 2013 is hosted in onprem environment.Sharepoint admins have full control over the farm where as in sharepoint online its limited.

Q75) Can multiple SharePoint installs point to the same DB?

Multiple SharePoint introduces can utilize a similar database server. Not actually a similar database on that server. That server should be SQL Server 2000 / SQL Server 2005. It can’t be Oracle or another merchant.

Q76) What are different permission types in Sharepoint?

Limited access,View Only,Read,Contribute,Edit,Design,Full control.

Q77) What is the difference between edit and cotribute permissions?

Contribute- Add/edit/delete list items

Edit-Contribute and Manage Lists i.e able to add new list or library and manage

Q78) What is the powershell command to return sitecollection along with all the subsites?

Get-SP Web Application http://site | Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL

Q79) What are alternate access mapping?

Alternate access mappings guide clients to the right URLs amid their cooperation with SharePoint Server 2013 (while perusing to the landing page of a SharePoint Server 2013 site, for instance). Alternate access mappings empower SharePoint Server to delineate solicitations to the right web applications and locales, and they empower SharePoint Server to serve the right substance back to the client.

Q80) What are the types of authentication?

Classic- Windows, NTLM, Kerberos

Claims- ADFS, Form based authentication

Q81)What is the difference between backup/restore and export/import commands?

Backup/restore will restore items with new GUID.Backup/restore will restore workflows and customs solutions but in export/import they can be restored.

Q82) What are differences Between auto Hosted, Provider Hosted and SharePoint Hosted?

  • Autohosted apps for SharePoint are cloud-hosted apps.
  • Provide hosted apps include components that are deployed and hosted outside the SharePoint farm.
  • SharePoint hosted apps are hosted either on an on-premises or Office 365 SharePoint farm.

Q83)What are differences between Application Pages and Site Pages?

Application These are the typical pages conveyed in SharePoint ,the greater part of them are found under _Layouts organizer which can be sent at ranch level or application level. Site pages will be pages that are made, altered, and tweaked by end clients. They are essentially utilized for the substance in a site. Website pages come in two kinds—a standard page and a Web Parts page.

Q84) How many days the deleted content will be available in Recycle Bin?

The erased article will remain in the Recycle Bin for 30 days as a matter of course.

Q85) What is master page and use of it?

Master page gives designs to set of pages. Ace Pages are a layout that different pages can acquire from to keep steady usefulness. The pages that acquire from Master Pages are alluded to as substance pages.

Q86) What is Page Layout?

Page design manages the general look and feel of a site page. A page design depends on a substance type to decide the sort of substance that can be put away on pages. Page design contains field controls and web part.

Q87) What is a SharePoint Feature? What files are used to define a feature?

SharePoint Feature is a practical segment that can be initiated and deactivate at different extensions all through a SharePoint occurrences, extent of which are characterized as

  • Farm
  • Web Application
  • Site
  • Web

Q88)What is Authentication and Authorization?

A verification framework is the manner by which you recognize yourself to the PC. The objective behind a validation framework is to check that the client is really who they state they are.When the framework knows who the client is through validation, approval is the means by which the framework chooses what the client can do.


No Comments

    Leave a Reply

    Your email address will not be published Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


    Looking for Training?

    Subscribe & Get latest Videos!

    Looking for Online Training