If you're looking for SharePoint Interview Questions for Experienced & Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research SharePoint has a market share of about 50.3%. So, You still have opportunity to move ahead in your career in SharePoint. Mindmajix offers advanced SharePoint Interview Questions 2019 that helps you in cracking your interview & acquire dream career as SharePoint Developer.
Q. What is SharePoint?
SharePoint is an enterprise collaborative web platform developed by Microsoft. SharePoint provides the advantage of rapid solutions development through reusable components like:
In the core SharePoint is built on ASP.NET/ISAPI with backend supported by SQL Server. The previous version of SharePoint 2010 was SharePoint 2007 and the successor is SharePoint 2013.
Q. What are the 3 editions of SharePoint 2010?
There are 3 editions for SharePoint 2010
SharePoint foundation is a freed edition having document management and collaboration features.
SharePoint server standard is built on top of SharePoint foundation and involves business level functionalities.
SharePoint server enterprise is built on top of server standard and targets large enterprises.
Q. What are the advantages of using SharePoint ?
SharePoint provides skill, cost & time advantages. For IT professionals, SharePoint provides development of web sites, lists & libraries. There is lot of flexibility in customization and security aspects. In forms management side SharePoint supports InfoPath. Thus the skill of IT Professional can be used instead of a developer.
For developers, SharePoint provides extensibility through programming. Creation of web parts for user interfaces, integration of Logic through workflows in some of the aspect where SharePoint infrastructure supports rapid application development.
In the time & cost advantage side, for example a CRUD (Create/Read/Update/Delete) form in ASP.NET takes 8 hours to produce & deploy, the same can be done in SharePoint within 5 minutes.
Q. What are the Document Management Features of SharePoint 2010?
3.Document Check in / Check out
4.Client Side Intergration
5.Document Set support
6.Document ID Integration
8.Content Type Hub
9.MMS (Managed Metadata Service)
Q. What are the Record Management features of SharePoint 2010?
The records management features are
1.Records Center & In – Place Records
2.Content Type Organization
3.MMS (Managed Metadata Service)
4.Content Approval Policy
5.Record Hold Policy
6.Record Retention Policies
These features can be applied to Document Management too.
Q. Can we install SharePoint 2010 on Windows 7?
yes. The SharePoint foundation version can be installed on client operating systems like windows 7, windows 8 etc.
There are some restrictions like window 7 professional editions are required to support the Authentication infrastructure of SharePoint 2010.
Installing on client operation system supports development of components against SharePoint 2010.
Q. What are Cumulative Updates and why it is needed?
They are periodic release of software updates for SharePoint. It contains hot fixes and support issues being fixed since the last cumulative update release.
We need to install the latest cumulative update based on the SharePoint edition to ensure the full functionality of SharePoint with hot fixes.
Q. Why I should go for SharePoint instead of other frameworks?
It purely depends on the problem you are trying to solve. For example if your project is having document management features then SharePoint can provide some ready solutions using its Document Management feature.
If you have requirements for lot of form creation & deployment in the solution life cycle, then SharePoint could address it using the Records Management feature.
If you have crate more sophisticated security aspects like windows authentication & role based authorization then the SharePoint security aspects could address it.
In these sense the cost of creating a new solution with or without SharePoint has to be evaluated and depending on the advantage side SharePoint could be chosen.
Q. What are the Enterprise content Management features of SharePoint 2010?
Following are some of the few ECM features in SharePoint 2010:
3.Document ID Service
4.Co – Authoring
7.Managed Metadata Service
8.Content Type Hub
Q. What are 14 hive folders?
The base folder for SharePoint binaries and 14 represents the version of SharePoint 2010. The location is on drive:
for SharePoint 2007 the folder was 12 and named 12 HIVE folders.
Q. What are the Collaboration features of SharePoint 2010?
Following are some of the few collaboration features of SharePoint 2010:
4.Email & Messages
Q. What is a Site Collection?
A site collection is a group of web sites that have same owner and share same settings.
Q. How to create a new Site Collection in SharePoint ?
Following are the ways to create new site collection:
1.Use Central Administration > Crate site collections link
2.Use Power Shell command
3.Use STASADM command
4.Use Server object Model
Q. What is STSADM?
STSADM is a command line tool included with SharePoint 2010. It resides in the 14 HIVE > BIN folder.
Q. What is PowerShell?
PowerShell is a Microsoft windows Task Automation framework. It has a scripting language associated.
The PowerShell coming along with SharePoint 2010 Installation contains the CMDLETS for SharePoint tasks.
Q. How t crate a new Site in SharePoint?
Use SharePoint user interface web application > Site Action > New Site link to crate a new site.
Q. How to restore a Site Collection after deletion?
Use one of the following options:
1.Use Recycle Bin
2.Use Restore from last back up
Q. How to copy a list with data from one site to another?
Following are the steps to achieve it:
1.Use Save as Template option on the List, Check the Include Content option while saving.
2.Download the Template file (STP) and upload it to the destination site Template Gallery.
3.Use the New List from Template option to create a list from this template.
Q. What is the Site Hierarchy Model in SharePoint?
Following is the Hierarchy Model:
5.Library / List
Basic Intro SharePoint Architecture Questions
Q. What are Web Applications in SharePoint?
An IIS Web site created and used by SharePoint 2010. Saying an IIS virtual server is also an acceptable answer.
Q. What is an application pool?
A group of one or more URLs that are served by a particular worker process or set of worker processes.
Q. Why are application pools important?
They provide a way for multiple sites to run on the same server but still have their own worker processes and identity.
Q. What are zones?
Different logical paths (URLs meaning) of gaining access to the same SharePoint Web application.
Q. What are Web Application Policies?
Enables security policy for users at the Web application level, rather than at the site collection or site level. Importantly, they override all other security settings.
Q. What is a site collection?
A site collection contains a top-level website and can contain one or more sub-sites web sites that have the same owner and share administration settings.
Q. What are content databases?
A content database can hold all the content for one or more site collections.
Q. What is a site?
A site in SharePoint contains Web pages and related assets such as lists, all hosted within a site collection.
Q. What are My Sites?
Specialized SharePoint sites personalized and targeted for each user.
Q. What is the difference between Classic mode authentication and Claims-based authentication?
As the name implies, classic authentication supports NT authentication types like Kerberos, NTLM, Basic, Digest, and anonymous. Claims based authentication uses claims identities against a against a trusted identity provider.
Q. When would you use claims, and when would you use classic?
Classic is more commonly seen in upgraded 2007 environments whereas claims are the recommended path for new deployments.
Q. Describe the potential components for both a single server, and multiple servers, potentially several tiered farms:
A single-server SharePoint Server 2010 environment leverages a built-in SQL Server 2008 Express database. The problems with this environment is scalability, not being able to install the with built-in database on a domain controller, the database cannot be larger than 4 GB, and you cannot use User Profile Synchronization in a single server with built-in database installation.
An example of a multiple tier farm would be a three-tier topology, considered one of the more efficient physical and logical layouts to supports scaling out or scaling up and provides better distribution of services across the member servers of the farm. This is considered a good architecture since one can add Web servers to the Web tier, add app servers to the application tier, and add database servers to the database tier.
SharePoint Backup and Restore Questions
Q. What are some of the tools that can be used when backing up a SharePoint 2010 environment?
1.SharePoint farm backup and recovery
3.System Center Data Protection Manager
Q. What Microsoft tool can be used for incremental backups?
System Center Data Protection Manager
Managed Metadata Questions
Q. What is Managed Metadata?
Managed metadata is a hierarchical collection of centrally managed terms that you can define, and then use as attributes for items.
Q. What are Terms and Term Sets?
A term is a word or a phrase that can be associated with an item. A term set is a collection of related terms.
Q. How do Terms and Term Sets relate to Managed Metadata?
Managed metadata is a way of referring to the fact that terms and term sets can be created and managed independently from the columns themselves.
Q. Are there different types of Term Sets?
There are Local Term Sets and Global Term Sets, one created within the context of a site collection and the other created outside the context of a site collection, respectively.
Q. How are terms created and used?
There are several ways; however the most common is to use the Term Store Management Tool.
Q. How is Managed Metadata, and the related Term technology used?
Through the UI, the most common use is through the managed metadata list column which allows you to specify the term set to use. It also related to searching and enhancing the user search experience.
Sandbox Solutions Questions
Q. What is a sandboxed solution?
Components that are deployed to run within the sandboxed process rather than running in the production Internet Information Services (IIS) worker process.
Q. What are some examples of things that might run within the SharePoint sandbox?
Web Parts Event receivers Feature receivers Custom Microsoft SharePoint Designer workflow activities Microsoft InfoPath business logic
Q. Why are sandboxed solutions used?
Primarily because they promote high layers of isolation. By default they run within a rights-restricted, isolated process based around Code Access Security (CAS). Isolation is possible to increase with activities like running the sandboxing service on only specific SharePoint 2010 servers.
Q. What is a content source in relation to SharePoint search? What’s the minimum amount of content sources?
A content source is a set of options that you can use to specify what type of content is crawled, what URLs to crawl, and how deep and when to crawl. You must create at least one content source before a crawl can occur.
Q. What is a search scope?
A search scope defines a subset of information in the search index. Users can select a search scope when performing a search.
Q. What is a federated location with SharePoint search?
Federated locations provide information that exists outside of your internal network to your end-users.
Q. How does managed metadata affect search?
Enhances the end-user search experience by mapping crawled properties to managed properties. Managed properties show up in search results and help users perform more successful queries.
Q. What is query logging in SharePoint 2010?
Collects information about user search queries and search results that users select on their computers to improve the relevancy of search results and to improve query suggestions.
Q. What authentication type does the SharePoint crawler use?
The crawl component requires access to content using NTLM authentication.
Q. Please describe what a Service Application is in SharePoint 2010.
Service applications in SharePoint 2010 are a set of services that can possibly be shared across Web applications. Some of these services may or may not be shared across the SharePoint 2010 farm. The reason these applications are shared is the overall reduction of resources required to supply the functionality these services cultivate.
Q. What are Service Application Groups used for?
Just provides a logical grouping of services that are scoped to a particular Web Application.
Q. How are Service Applications deployed in terms of IIS (Internet Information Services)?
They are provisioned as a single Internet Information Services (IIS) Web site.
Q. Explain how connections are managed with Service Applications.
A virtual entity is used that is referred to as a proxy, due to label in PowerShell.
Q. What are some common examples of SharePoint 2010 services architectures, and what are the advantages of each design?
The three most popular designs are single farms with either a single service application group or multiple service application groups, or Enterprise services farms.
Single farms with a single service application group are generally the most common, and have the advantages of easy deployment, simple service application allocation, effective resource utilization and cohesive management.
Single farms with multiple service application groups is less common, and have the advantage of potential individual management of service applications as well as allowing data isolation, and while being more complex to deploy and maintain allows targeting of sites to particular service applications.
Enterprise Service Farms is pretty uncommon as it is a complete farm dedicated to Service Applications but promotes autonomous management and high levels of data isolation.
Q. Are there any other type of relevant service architectures?
Depending on the environment requirements, a specialized farm can also be used in order to deploy specific services tailored to the organizational requirements which can aid in scaling out and conservation of resources.
Q. What is the User Profile service?
Allows configuring and managing User profile properties, Audiences, Profile synchronization settings, organization browsing and management settings, and My Site settings.
Q. What are User Profiles?
Aggregates properties from diverse identity content sources together to create unified and consistent profiles across an organization, used throughout the SharePoint environment.
Q. What is Excel Services?
Allows sharing, securing, managing, and using Excel 2010 workbooks in a SharePoint Server Web site or document library. Excel Services consists of the Excel Calculation Services (ECS), Microsoft Excel Web Access (EWA), and Excel Web Services (EWS) components.
Q. What is PerformancePoint Services?
Allows users to monitor and analyze a business by building dashboards, scorecards, and key performance indicators (KPIs).
Q. What is Visio Services?
Allows users to share and view Microsoft Visio Web drawings. The service also enables data-connected Microsoft Visio 2010 Web drawings to be refreshed and updated from various data sources.
Q. What is Access Services?
Allows users to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an internet browser, the Access client, or a linked HTML page.
Q. What is the Secure Store Service (SSS)?
A secure database for storing credentials those are associated with application IDs
Q. What is Content Deployment?
Content deployment enables you to copy content from a source site collection to a destination site collection.
Backup / DR Questions
Q. Describe how redundancy can be built into a SharePoint environment. Please be specific in regards to any auxiliary components.
Multiple front-end web servers (WFE’s) can be deployed and correlated through Windows NLB or anything approach. Application servers can be deployed into the farm for a variety of purposes, depending on organizational requirements. Databases can be clustered or mirrored, again depending on requirements and environment.
Q. From a basic standpoint, what is the difference between SQL clustering and mirroring?
Clustering provides a failover scenario whereby one or more nodes can be swapped as active depending on whether a node goes down. In mirroring, transactions are sent directly from a principal database and server to a mirror database to establish essentially a replica of the database.
Q. What Is Governance in terms of SharePoint 2010?
Governance is the set of policies, roles, responsibilities, and processes that guide, direct, and control how an organization’s business divisions and IT teams cooperate to achieve business goals.
Q. What are some useful, OOB features of SharePoint that aid with governance of an environment?
Any of the below are acceptable answers. There are some others but these are the major ones that I generally look for from a candidate:
Site templates – consistent branding, site structure, and layout can be enforce a set of customizations that are applied to a site definition.
Quotas – limits to the amount of storage a site collection can use.
Locks – prevent users from either adding content to a site collection or using the site collection.
Web application permissions and policies – comprehensive security settings that apply to all users and groups for all site collections within a Web application.
Self-service site creation – enables users to create their own site collections, thus must be incorporated into a governance scheme.
Q. Describe the monitoring features that are baked into SharePoint 2010.
Diagnostic logging captures data about the state of the system, whereas health and usage data collection uses specific timer jobs to perform monitoring tasks, collecting information about:
1.Performance Counter Data
2.Event Log Data
3.Timer Service Data
4.Metrics For Site Collections and Sites
5.Search Usage Data
Q. What is a declarative workflow? Can non-authenticated users participate in workflows?
Workflows that are created by Microsoft SharePoint Designer 2010, the default setting enable deployment of declarative workflows. Yes, however you do not give non-authorized users access to the site. The e-mail message and attachments sent from notifications might contain sensitive information.
Q. What do you mean by MOSS ?
1.MOSS stands for Microsoft Office SharePoint Server.
2.It is the complete version of a portal-based platform for collaboratively creating, managing and sharing documents and Web services.
Q. Explain the following: a.) SPSite b.) SPWeb
a.) SPSite –
i) It is a site collection and an be represented as SPSite class in the object model.
ii) SPSite object is a primary entry points to the server object model.
iii) It is used frequently in SharePoint application development.
b.) SPWeb –
i) It is a specific site under site collection in Sharepoint.
ii) It is represented as SPWeb class in the server object model.
Q. Explain the following:
a) Site template –
i) Site template provides the basic component and layout of a new site to be created in SharePoint.
ii) It contains specific design information about a site which includes –
the list that is part of the site,
web part pages used in the site,
the site’s themes and borders,
changes to the quick launch bar,
some site content like document libraries
iii) It allows to build the SharePoint applications to be instantiated time and again.
b) Site definition –
i) Site definition is a collection of XML or ASPX files which contains all the necessary components.
ii) It contains three files – webTemp.xml, onet.xml, default.aspx.
ii) It contains information of web parts, lists, libraries, features, and navigation bars to be included in the site which are packaged in SharePoint solution files (.wsp).
iii) Everything packaged into a single file makes the transportation of everything easy .
c) ONET.xml –
i)Onet.xml file specifies all the components contained in a site. It is considered as the core of a site definition.
ii)It is present at following location:
Q. What are the various classes in Server Object Model from development point of view?
Following are the classes in Server Object Model from development point of view:
Q. Which class is used to retrieve data from multiple lists?
1.SPSiteDataQuery class is used to retrieve data from multiple lists.
2.It queries the data from multiple lists across different sites in a collection.
3.Usually it is used in list aggregation, where list data from team sites or other subsites is collated and presented in a single interface.
4.It aggregates the data from SharePoint lists only while ignoring data from external lists.
Q. What do you mean by WSP?
1.WSP stands for Web Solution Package. It is a cabinet file that contains assemblies, resource files, features, images, application pages, site definitions etc. into single file.
2.Whenever any customization or upgradation or updation is carried out in SharePoint, various items like assemblies, resource files, features, images, application pages, site definitions etc. are required to deployed.
3.It becomes difficult to deploy these items separately in development, staging and production. This called for a powerful deployment tool in the form of WSP.
Q. a) How is AllowUnsafeUpdates used?
1.When a developer updates the content database without requiring a security validation AllowUnsafeUpdates property is set to true.
2.One the operation is carrried out, the property is again set to false .
b) What is CAML?
1.CAML – also called as Collaborative Application Markup Language is the custom XML language in SharePoint.
2.It is used to define key objects such as lists, columns, and content types.
Q. Which is better – SPS or STS?
Before we begin – let us see what do these two abbreviations stand for.
SPS means SharePoint Portal Services
STS means SharePoint Team Services
i) Document management system in SPS is better than STS.
ii) The search engine in SPS is better, more efficient and possesses the capability to crawl multiple content sources in comparison to STS.
iii) If Document Management is not required, STS is easier to manage for team environment while SPS is better for an organization where Document Management is required.
Q. a) Name the various input forms that can be created for a workflow ?
3.Task edit form.
b) Differentiate between CustomMasterUrl & MasterUrl?
– MasterUrl is used to change the layout of all end user pages while CustomMasterUrl is used for changing the layout of admin pages.
Q. What are the various zones in SharePoint?
Zones provide the separate logical paths of authentication for the same web application. 5 zones can be created for each web application :
Q. Explain Farm in SharePoint.
1.Farm is a collection of SharePoint servers with same configuration database.
2.All the required information to run the farm is carried in Configuration DB. There exists only one configuration database for each farm.
3.Central administration is used for the administration of each farm.
Q. Explain WebApplication.
1.WebApplication is a IIS website. Content database is created for each WebApplication
2.WebApplication can be created from central admin.
3.Once a web application is created, it can be extended to different zones.
Q. a) Differentiate between WSS 3.0 and MOSS 2007.
1.WSS 3.0 is freely available with Windows Server while MOSS 2007 is a paid product.
2.MOSS 2007 has some more features like Enterprise Search, Business Data Catalog(BDC), User Profile, Excel Services, Single-Sign on, additional Workflows, My site feature etc. in addition to those in WSS 3.0.
b)What tools can be used to back up a SharePoint 2010 environment?
1.SharePoint farm backup and recovery
Q. Explain a) BDC b) BCS
a.) BDC also called Business Data Catalogue is used to connect to an external database and read it in SharePoint.
b.) BCS also called Business connectivity Services is new in SharePoint2010. BCS aids in reading and writing into the external Database.
Q. Explain Content types in Sharepoint.
1.A content type is a WSS type definition which is flexible and reusable.
2.It is used to define the columns and behavior for an item in a list or a document in a document library.
Q. a) Differentiate between Library vs List.
1.Library is used to store the document whereas Lists are the container of similar items in the form of rows and columns.
2.Core documents like Word, Excel, and PowerPoint can be created using a Library while you can not create a document in a List. List can be used to attach a document.
b) What do you mean by Field Control ?
1.Field controls are ASP.NET 2.0 server controls. They provide basic field functionality in SharePoint.
2.They also provide basic general functionality such as displaying or editing list data as it appears on SharePoint list pages.
Q. a) What are the various types of input forms that can be created for a workflow?
Four tyes of input forms can be created for a workflow:
4.Task edit form
b) Explain an ancestral type. How is it related to content types?
1.An ancestral type is the base type that the content typed is derived from.
2.It defines the metadata fields included with the custom content type.
Q. Explain Microsoft SharePoint Portal Server?
1.SharePoint Portal Server is a portal server that connects people, teams, and knowledge across business processes.
2.It integrates information from various systems into one secure solution through single sign-on and enterprise application integration capabilities.
3.It provides flexible deployment and management tools, and facilitates end-to-end collaboration through data aggregation, organization, and searching.
4.It enables users to quickly find relevant information through customization and personalization of portal content and layout as well as through audience targeting.
Q. Explain a) Custom action.
1.It Represents a link, toolbar button, menu item, or any control that can be added to a toolbar or menu appearing in the UI.
2.Custom actions are defined through a custom action element within a feature definition file. Custom actions can be bound to a list type, content type, file type, or programmatic identifier (ProgID).
b) Event receiver.
1.Event receivers can be defined by using a receiver element within a feature definition file.
2.They evaluate an event and define the behavior of an application.
Q. Explain Module in Sharepoint
1.A module is a file or collection of file instances which define the location where the files are installed during site creation.
2.They are used to implement a Web Part Page in the site.
3.Modules can be defined by using a module element within a feature definition file.
|SSAS||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
Free Demo for Corporate & Online Trainings.