Tuesday, 15 November 2016

SharePoint Interview Questions and Answers


SharePoint interview question and answers Part 1

1. What all are new OOB Webparts/Apps

o   SharePoint 2013 Minimal Download Strategy
o   Promoted Links App
o   Design Manager
o   Remote event receivers
o   Cross-site publishing
o   SharePoint 2013 Service Application Databases
o   Timeline web part
o   FAST Query Language (FQL) features that are deprecated
o   OAuth in SharePoint 2013
o   PDF file support
o   Shredded Storage
o   Image Renditions
o   New master pages
o   Mobile Apps
o   Audio and Video Content Type
o   TilesViewWebPart

2. SharePoint 2013 come with some new delegate controls 
  1. SuiteBarBrandingDelegate delegate Control
  2. SuiteLinksDelegate delegate Control
  3. PromotedActions Delegate Control etc.
3.  News Feeds, Tags, Follow etc. and what are the social feature you have worked?

4.  What is Design Manager, SharePoint Designer and InfoPath Designer? 

5.  What is OData and OAuth

o   OAuth is to authorize requests by an app for SharePoint to access SharePoint resources on behalf of a user and also OAuth used to authenticate apps in the Office Store, an app catalog.
o   Producers expose their data in a structured way via a web service. Examples include SharePoint Foundation 2010, SharePoint Server 2010, SQL Azure, Windows Azure Table Storage, Windows Azure Marketplace, SQL Server Reporting Services, Microsoft Dynamics CRM 2011, and Windows Live. 

6. What is Pages layouts and how can we use it?

o   In a page layout, you are essentially telling SharePoint what it should fill all those empty bookshelves with. You declare a control (a certain shelf), and then tell SharePoint what goes inside

7. What is cross site publishing SharePoint 2013 and how / why to use it?
o   Cross-site publishing feature is used to store and maintain content in one or more authoring site collections and display the content in one or more publishing site collections. Cross-site publishing will make life easy for you as it:

1.       Can be used across site collections, web applications, and even across farms.
2.       Separates content authoring from branding and rendering, meaning how you author content has nothing to do with how it is displayed to users.
3.       Allows you to mix pages and catalog content. 

8. SharePoint services names and what are Newly introduced?

o   Access Service , Access Service 2010
o   App Management Service
o   Business Data Connectivity Service
o   Excel Services Application
o   Machine Translation Service
o   PerformancePoint Service
o   PowerPoint Automation Service
o   Managed Metadata Service
o   Search Service
o   Secure Store Service
o   State Service
o   User and Health Data Collection Service
o   User Profile Service
o   Visio Graphics Service
o   Word Automation Services
o   Work Management Service
o   Microsoft SharePoint Foundation Subscription Settings Service

9. Managed metadata services, term set, how to import term set, how to create and manage term set (example country-state-city)

o   The managed navigation feature in SharePoint Server 2013 enables you to build navigation for a publishing site that is derived from a SharePoint managed metadata taxonomy. In SharePoint Server 2010, by default, you could base navigation only on the structure of a site. To create site navigation based on any data structure, you had to create a custom navigation provider. By using managed navigation, you can design site navigation around important business concepts. Managed navigation also lets you create friendly URLs without changing the structure of your site. In SharePoint Server 2010, all publishing site URLs contained a reference to the Pages library and any folders within that library — for example, http://contoso.com/Pages/AboutUs.aspx. In SharePoint Server 2013, you can create URLs that are better for Search Engine Optimization (SEO), and easier for site visitors to read — for example, http://contoso.com/AboutUs.

10. How to configure Managed Meta data Navigation?
11. What is USerProfile service, how to consume it and how many ways you can consume it?
o   User Service side code, Client side code, InfoPath forms , Designer we can consume UPSA

12.   Improvements in SharePoint Search / what is FAST Search?

13.   What is Workflow Manager and Improvements in current version? (architecture, Service and commands)

14. What is webpart life cycle,

o   OnInit – Configuration values set using WebBrowsable properties and those in web part task pane are loaded into the web part.
o   OnLoad
o   CreateChildControls – All the controls specified are created and added to controls collection. When the page is being rendered for the first time the method generally occurs after the OnLoad() event. In case of postback, it is called before the OnLoad() event. We can make use of EnsureChildControls() – It checks to see if the CreateChildControls method has yet been called, and if it has not, calls it.
o   LoadViewState – The view state of the web part is populated over here.
o   OnPreRender – Here we can change any of the web part properties before the control output is drawn.
o   RenderContents – Html Output is generated.
o   OnUnload(EventArgs e)
o   Dispose()

15. SharePoint 2013 Authentication

o   Windows claims
o   Security Assertion Markup Language (SAML)-based claims
o   Forms-based authentication claims
 
16. What is Distributed caching?

o   A new service called Distributed Cache. The Distributed Cache service is built on Windows Server AppFabric, which implements the AppFabric Caching service. Windows Server AppFabric installs with the prerequisites for SharePoint Server 2013.

The Distributed Cache service provides in-memory caching services and does not have a dependency on databases for several features in SharePoint Server 2013. Some of the features that use the Distributed Cache service include:
      • Newsfeeds
      • Authentication
      • OneNote client access
      • Security Trimming
      • Page load performance
o   When the service is enabled, these features use the Distributed Cache for quick data retrieval. Blob Cache and Output Cache do not use a distributed caching service since these types of cache exist on each Web Front End server in the farm

17. Types of events available in SharePoint –
(Sync and aSync or Adding / Added)

o   Item Level
o   Security / Permission
o   List
o   Web
18. Remote event receiver.
o   By Client service in SharePoint (app- we use in provider hosted app).

19. Name the REST Api operation names?
o   GET, PUT, POST, Delete

20. What query string element enables a client webpart to talk back to the parent?
o   SenderId.

21. What is the PFX and CER cert ?
o   PFX is required by the App and the CER is needed by SharePoint

22. What is .App file? What it contains?
o   It is like .zip file

23.   What API do Apps use? (both REST and CSOM)

24.   Where will you find the necessary DLLs to refer? (15/16 hive ISAPI folder)

25.   What serialization formats are used with REST in SharePoint?(JSON and ATOM)

26.  What are Ghosted pages and Unghosted pages?
       The pages those are stored in File system are Ghosted pages which are faster and UnGhosted pages are those are being stored in SharePoint Database and comparative slower in rendering. 

27. What is SharePoint Object Hierarchy?

  • SPFarm
  • SPWebApplication
  • SPSiteCollection
  • SPWeb
  • SPList
  • SPListItemCollection
  • SPListItem, SPField


Recommends reading below points (search over internet)



1.       How to Configure Search Service Application? How to Create/Config its Databases, Crawls and scopes?
2.       What is Display templates, how to you use?
3.       What all are the new features of SharePoint?
4.       What is Image rendition and Shredded storage?
5.       How to improve SharePoint site performance?
6.       What is Site Ribbon- how to add option in it? And how to hide it from specific site.
7.       How to create or Override - delegate controls
8.       Master pages creation/ branding, Important/Required control name those needs to be added in MasterPage.
9.       How to create Responsive SharePoint site? (bootstrap in html5 and css3)
10.   PDF file support, what is I Filter PDF?
11.   Feature stapling, and how and why to do it?
12.   Sandbox solution-2013 supported? on Which Process is run and why? – SPUCWorkedProcess.exe – rest search it over internet
13.   SPQuery vs SiteDataQuery
14.   Can we user list Joins in SharePoint? How to apply joins, tell me important tag names?
15.   One Issuer ID can be setup for hosting multiple clients/apps in provider hosted apps?
16.   What is JSON and ATOM format?
17. What is Reusable Workflows
18. SharePoint Permission Hierarchy?
19. Content and Config DataBase Difference?
20. BCS service, operation names and how to Configure it.




Sunday, 16 October 2016

Automated Windows Server monitoring, maintance on daily alert email using powershell, check low space

Hey, Hello Dear reader, we have another blog, that is useful for Windows Admin, Server Admin or SharePoint Admins also,

We have number of servers for productions, UAT and Integration so going to each server (DB, WFE, Application and DMZ servers) etc and checking for frees pace or Server should have all running services running etc that's really hectic and time consuming, people already started making thier task automated to monitor 10 of or even 100s of server..

In short, yeah we can MAKE WORK Short as blog link says, we can do it in simpler way.

we need to create a task scheduler and run PowerShell script that can check for free space, running services and process etc... and send an email for all these details.

Here I am sharing sample script to check timely Server space daily and sends an alert email using powershell.





Any time above sample can be downloaded on clicking Download here link.

--
Comments & Feedback are welcome, and yeah don't forget to share this make short link.



Saturday, 10 September 2016

SharePoint solution wsp Deployment SPSolution using PowerShell or STSADM - Uninstall, Remove, Add, Install

You are looking to have some handy commands or camdlets so this is/was/will very often commands that you may keep using as SharePoint Admin and developer SharePoint Environment so you can bookmark this blog.
is/was/will... why was? actually if you are working on SharePoint Online. for on premise you will need to have these information. ;)

So the deployment process includes below set of steps for existing Solutions in SharePoint.
  1. Retract solution
  2. Remove wsp
  3. Add wsp
  4. Deploy soltion. 
For new Solution deployment you will perform above mentioned two steps 3 and 4.
  
First Deactivate Solution then Remove Solution, then Add Solution from local drive and Activate to desired scope.


There are 3 simple ways to do so.
  1. From SharePoint site, go deactivate then from CA retract and remove solution.
  2. Second way is STSADM.exe
  3. Third and most preferred way is PowerShell.
Uninstalling wsp package using PowerShell command

Uninstall-SPSolution –Identity "MyWPSFile.wsp" –WebApplication "WebApp Url"

Remove wsp package using PowerShell command

Remove-SPSolution–Identity "MyWPSFile.wsp"

Add wsp package using PowerShell command

Add-SPSolution "C:\Praveen\MyWPSFile.wsp"

Installing SharePoint wsp package using PowerShell command

Install-SPSolution –Identity "MySolution.wsp" –WebApplication "url" –GACDeployment 

Installing SharePoint wsp at SharePoint 2013 version to deploy file at 15 hive and/or 14 hive, using PowerShell command


  • Uninstall-SPSolution SolutionName.wsp -AllWebApplications  #Solution deployed on AllWebApp
     
  • Remove-SPSolution SolutionName.wsp

    Add-SPSolution -LiteralPath "E:\Solutions\SolutionName.wsp"
     
  • Install-SPSolution -Identity SolutionName.wsp -GACDeployment -AllWebApplications -CompatibilityLevel "All" # You can mentioned 15 or 14 or both (All) to copy all files to 14 and 15 hive of your sharepoint 2013 version
     
  • Update-SPSolution also help you in same case.

Using STSADM command


open command prompt with Admin privileges and go to below path,
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\BIN
 

Add Solution
stsadm.exe -o addsolution -filename "c:\Praveen\MySolution.wsp"
 

Deploy Solution
stsadm.exe -o deploysolution -name "MySolution.wsp" -url "http://server/" -allowgacdeployment -immediate



Activate feature
stsadm.exe -o activatefeature -name "MySolution.wsp" -url "http://server/"


For bulk feature deployment or big releases we can plan sequence of wsp deployment and feature activation using PowerShell scripts and Configuration xml / csv or text files.


--
Thanks and let me know if needs any help


Sunday, 7 August 2016

SharePoint send email jQuery, without server code

You have a requirement or and this is one of the very common scenario to send email from SharePoint using jQuery or client side code...

No problem! we have simple solution, No need to create workflows or server code for emails, just use this simple function:

function UtilitySendEmail(fromEmails, toEmails, emailBody, subject) {

var siteurl = _spPageContextInfo.webServerRelativeUrl;

/* Yes, you can user SPUtility as service that has SendEmail Menthod.*/

var urlTmplt = siteurl + "/_api/SP.Utilities.Utility.SendEmail";
$.ajax({
   contentType: 'application/json',
   url: urlTmplt,
   type: "POST",
   data: JSON.stringify({
       'properties': {
           '__metadata': { 'type': 'SP.Utilities.EmailProperties' },
           'From': fromEmails,
           'To': { 'results': [toEmails] },
           'Body': emailBody,
           'Subject': subject
       }
   }
 ),
   headers: {
       "Accept": "application/json;odata=verbose",
       "content-type": "application/json;odata=verbose",
       "X-RequestDigest": $("#__REQUESTDIGEST").val()
   },
   success: function (data) {
      alert("Email has been sent");
   },
   error: function (err) {
       alert(err.responseText);
   }
});
}

You can call this Method to email in SharePoint Online, and SharePoint 2013+ versions.