TOP 50 SharePoint Interview Questions

Hello guys! It’s been a long time I haven’t posted anything. So I am here with ‘TOP 50 SharePoint Interview Questions’ that will be asked in any SharePoint interview. These questions are divided into section and are applicable to all SharePoint developers with an experience ranging from 0-5 years.

The most important section among these would be the Scenario Based Questions which you may not find anywhere. Try to answer these questions. You can use comment box for that. You can Specify Question number and write the answer. I will be publishing the answers after some time. Have fun !

App Model (add-ins in Sharepoint)

Q1. What is Host Web and App web?

Q2. How to create app domain and app catalog?

Q3. Where the apps get deployed in SharePoint?

Q4. How provider hosted apps communicate with SharePoint site?

Q5. What is the major difference between Sandbox Solutions, Farm Solutions and Apps?

Q6. What is oAuth and ODATA?

Q7. What are the features that we cannot implement using app model?

Q8. What is the use of App.manifest file?

Q9. What are the different ways of hosting an app?

Q10. Can we perform CRUD operations on list items in app web? How?

Client Object Model

Q11. What is the difference between

1. Load() and LoadQuery()?
2. Load() and ExecuteQuery()?
3. ExecuteQuery() and ExecuteQuery Async()?
4. item.update() and item.systemupdate()?

Q12. What are the js files required to be loaded on a page for Java Script Object Model?

Q13. Can we execute a code with elevated permissions in .net managed COM?

Q14. What is request digest and its use?

Q.15 Write down an ajax block to update a list item containing a column of type People [Multiple select]?

Q16. What is SP.RequestExecutor?

REST API

Q17. What is the limit to retrieve no of items from list? Is there any way to retrieve more than 5000 items from list?

Q18. Write down the ajax block to insert an item into SharePoint list.

Q19. What are the scenarios where you will prefer REST api over JSOM?

Q20. How does REST call works in SP2013?

Q21. Why do we call it as REST api instead of simple web service?

Q22. How can we make sure that multiple REST service calls get executed in sequential order? What are the different ways of doing it?

Q23. How can we use REST service to retrieve search results from SharePoint?

Q24. Can we elevate privileges to get access to resources using REST api?

General

Q25. How the request is processed by IIS for SharePoint site and ASP.NET web site?

Q26. Explain Page life cycle in ASP.NET?

Q27. What is CLR? What are the features of CLR?

Q28. What is the default limit of lookup columns in a view? How can we increase the limit? What will be impact?

Q29. What is claims based authentication? Advantages over other authentication methods?

Q30. What are zones? How can we achieve single sign-on for different sites in an organization?

Q31. What are ContentDB and ConfigDB? Can we have different contentDB for different site collection?

Q32. What is Shredded storage? What if versioning is disabled?

Q33. How to design a master page in SP2013?

Q34. What are display templates in SP2013? How to modify the header of the search results? How to modify individual results?

Q35. What are search verticals in SP2013?

Q36. What are the differences between SP2010 Enterprise and SP2013 Search?

Q37. What are crawled properties and managed properties?

Q38. What are different types of crawling mechanism provided by SP2013? What is the difference between Incremental and Continuous crawl?

Q39. How can we show the contents of SharePoint On premises site on SharePoint Online search results?

Q40. What are callout popup in SharePoint 2013? How can we create custom call out popup?

Scenario Based Questions

Q41. A root site collection has a list named Contacts. How would you show all items of this list on a sub site using OOB features of SharePoint?

Q42. There are two lists say Departments and Employees. End user should be able to fill the details in both the lists from a single place, how would you achieve this? What are the different approaches and which one would you prefer and why?

Q43. A company has two SharePoint web sites, a) On Premises and b) Office 365. There is a requirement that contents of On Premises site should be searchable on Office 365 site. Is it possible? If yes then how?

Q44. A SharePoint on premises site has two lists say Employees and Departments.

Employees

EmployeeName	Single Line of Text
Salary	Number
Address	Single Line of Text
DOJ	Date and Time
DeptId	Lookup

Departments

DeptId	Number
Department Name	Single Line of Text

On deletion of a record from Departments list, all the records with respective DeptId should be deleted.

1. Can we achieve this OOB way?
2. What will you choose between Workflow and Event receiver and why?
3. What if these lists are on SharePoint online site and user has only READ permission on both the lists?

Q45. A company has SharePoint online site and they want to showcase their line of business data from SQL Server to SharePoint site. What are the different approaches? Which one will you choose? and why?

Q46. There are three different Companies say Company A, Company B and Company C. They have their own SharePoint2013 on premises portals.

Company A acquires Company B and Company C. Company A wants to have all the sites hosted on their own domain and accessible by all the users.

What are all the steps in sequence that you need to perform?

Q47. Consider the scenario in Q.6, What if all these sites are hosted on SharePoint online?

Q48. A company has a SharePoint 2013 on premises site which is accessible only within the organizational network. They decided to allow the site to be accessed externally by users from same organization from any network. How it can be achieved?

Q49. SharePoint2013 on premises web application has 50 site collections. All these site collections need to have a custom content type say EmployeeContentType. How will you achieve this with minimum development efforts and flexibility of modifying content type?

Q50. There is a requirement of adding a custom link to site settings page. Can we achieve this is SharePoint On premises? If yes then how? Is it possible with SharePoint online?