Tuesday, 23 April 2013

Sharepoint 2013 Interview Question

1) Describe the Cloud App Model.
The Cloud App Model that enables you to create apps. Apps for SharePoint are self-contained pieces of functionality that extend the capabilities of a SharePoint website.

2) Why build Apps?
Enables you to build apps for SharePoint by using familiar tools and a rich set of features. Familiar programming model and access to SharePoint data and services, Multiple options for hosting, Familiar user experience for end users, Integration with apps for Office, and SharePoint Store and App Catalog.

3) What as an App in its most basic form?
A web application that is registered with SharePoint using an app manifest

4) What is an app manifest?
An app manifest is an XML file that declares the basic properties of the app along with where the app will run and what to do when the app is started.

5) Where can the code for an app run?
SharePoint-hosted apps, Provider-hosted and auto hosted apps, Apps that have a mix of components in SharePoint and in the cloud

6) How does an app communicate with SharePoint?
  1. REST and JavaScript APIs
  2. Managed APIs (.NET)
7) How can the app authenticate to SharePoint?
  1. Inside SharePoint
  2. In the cloud
8) How are apps distributed?
Apps for SharePoint are distributed as an app package.

9) What are some options for app publishing?
  1. Public SharePoint app store
  2. Organization’s app catalog
10) What is OData?
The Open Data protocol (OData) lets you access a data source, such as a database, by browsing to a specially constructed URL.

11) What is the primary benefit of OData?
Simplified approach for connecting to and working with data sources that are hosted within an organization.

12) What technologies does OData use?
  1. HTTP
  2. Atom
  3. JavaScript Object Notation (JSON)
13) How can you avoid direct code against the OData source?
Business Connectivity Services (BCS) can communicate with OData sources, or producers, without having to code directly to the OData source.

14) What is an OData producer, and some examples?
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, Windows Live.

15) What is OAuth?
An open protocol for authorization.

16) What does OAuth enable?
Secure authorization from desktop and web applications in a simple and standard way.

17) What is OAuth used?
To authorize requests by an app for SharePoint to access SharePoint resources on behalf of a user and to authenticate apps in the Office Store, an app catalog, or a developer tenant.

18) What is an Access token?
Access tokens are issued by the OAuth security token service (STS) to request app permissions.

19) What are the three types of authorization policies?
user-only policy, user + app policy, or app-only policy

20) How does an app for SharePoint requests permissions to access SharePoint resources?
An app for SharePoint requests the permissions that it needs during installation from the user who is installing it and then the developer of an app must request, through the app manifest file, the permissions an app needs.

21) How is an app granted the permissions requested?
An app must be granted permissions by the user who is installing it and users can grant only the permissions that they have; the user installing the app must be able to grant all permissions required by the app, or app installation fails.

22) When is an app granted the permissions it asked for?
An app is installed by a website administrator, a app is explicitly granted permission by a tenant administrator or website administrator or an end user gives consent.

23) What are scopes in terms of SharePoint permissions?
Scopes indicate where in the SharePoint hierarchy a permission request applies.

24) What are some of the features of Office 365 Development Tools?
Create and manage projects, develop apps, share and publish apps.

25) What office technology can be used to build SharePoint 2013 workflows?
Visio 2013 includes a SharePoint 2013 Workflow template that can be used.

26) What is a workflow stage shape in SharePoint Designer 2013?
A stage can contain any number of shapes and may include branching. The stage or step itself might be one node of a longer workflow.

27) What is a workflow loop shape in SharePoint Designer 2013?
Loops are a series of connected shapes that will execute as a loop, returning from the last shape in the series to the first, until a condition is satisfied.

28) What is a step shape in SharePoint Designer 2013?
Steps represent a grouped series of sequential actions.

29) What is an example approach to navigate SharePoint data structure in SharePoint 2013?
Managed code or the SharePoint REST service.

30) What is the SPContextWebInformation structure?
Contains the initialization properties that can be used in subsequent REST requests.

31) What is a WebInfo object?
From REST resources it is an object that contains the scalar properties of the site, but that does not include any associated entity sets such as list collections or field collections.

32) What request type from a REST resource allows one to create a SharePoint object?
POST request.

33) What request type from a REST resource allows one to access the contents of a file ?
GET request.

34) What request type from a REST resource allows one update the contents of a file?
PUT request.

35) What request type from a REST resource allows one to delete a SharePoint object?
POST to that resource including an X-Http-Method header of DELETE.

36) What are HTML ETags?
The SharePoint REST service uses HTML ETags for concurrency control.

37) What are ETags useful for?
When you perform a PUT, PATCH, MERGE, or DELETE request, you can specify an ETag in the If-Match HTTP request header.

38) What are the factors to consider when choosing a SharePoint API?
The type of application, existing skills, and the device on which the code runs.

39) What is Client-side rendering?
Client-side rendering provides a mechanism that you can use to produce your own output for a set of controls that are hosted in a SharePoint page.

40) What are remote event receivers?
Remote event receivers handle events that occur to an item in the app, such as a list, a list item, or a web.

41) What is Microsoft Push Notification Service?
Using the Microsoft Push Notification Service (MPNS), Windows Phone apps can receive notifications through the Internet of events triggered on Microsoft SharePoint Server.

42) What is the benefit os MPNS?
The app can be registered to receive notifications from the server, and an event receiver can initiate a notification and send it to the receiving app for handling.

43) What are some benefits of the new Geolocation field type?
Allows incorporation of location, maps, and proximity search features into their web and mobile apps and solutions.

44) What are interactive social feeds?
Interactive social feeds are designed to encourage people to share information and to stay connected with people and content.

45) What are some common programming tasks when working with social feeds?
Get the user for the current context, get the feed for the current user, get the personal feed for a particular user.

46) What are feed types?
Feed types represent slices of feed data.

47) What are some examples of feed types?
Personal, News, Timeline, Likes, and Everyone.

48) What method do the server, client, and JavaScript object models use to retrieve feed types?
The GetFeed method.

49) What API’s can be used to programmatically follow people?
Client object models, mobile client object model, JavaScript object model, representational State Transfer (REST) service, and server object model.

50) What is the SocialFollowingManager object?
Consolidates the core Following People and Following Content functionality for the current user.

51) What is the PeopleManager object?
Provides some functionality that SocialFollowingManager does not provide, not really worth grilling about.

52) What is an external content enrichment web service?
Enables users to modify the managed properties of crawled items before they are indexed.

53) At a high level, how does the web service client work?
The web service client works with managed properties that you can configure as input properties or as output properties.

54) What is a trigger condition in terms of a web service callout?
A trigger condition is an expression that is used to configure the web service callout.

55) How does one use the Search .NET Framework managed CSOM?
Get a ClientContext instance then use the Microsoft.SharePoint.Client.Search.Query namespace

56) Do custom search solutions support SQL syntax?
No.

57) What are Query properties?
Provide information about a search query.

58) What is the the ONEAR operator?
Provides ordered near functionality.

59) What is a display template in terms of SharePoint search?
Display templates define the visual layout and behavior of a result type by using HTML, CSS, and JavaScript.

60) What are result types in terms of SharePoint search?
Result types define how to display a set of search results.

61) How does one use the connector framework in terms of SharePoint search?
Enables you to retrieve claims information for content stored in custom external data sources that are crawled.

62) What is Keyword Query Language (KQL)?
Allows you to you specify the search terms or property restrictions that are passed directly to the search service.

63) What is FAST Query Language (FQL)?
FQL is a structured query language that supports advanced query operators.

64) What is the workflow execution host in the new workflow infrastructure in SharePoint 2013?
Windows Azure.

65) Are workflows are no longer compiled into managed assemblies?
No they are fully declarative.

66) What is meant by a fully declarative workflow?
The workflow is described (literally) in XAML and then executed interpretively at run time.

67) What is the Design Manager?
The Design Manager enables a step-by-step approach for creating design assets that you can use to brand sites.

68) What is the Snippet Gallery?
Allows a user to select a component, configure its properties and update the snippet, copy the HTML snippet that’s generated, and paste that HTML snippet into your HTML file.

69) What are Device channels?
Device channels define channels for one or more devices allowing finely-tuned control over how mobile users experience your site.

70) What is managed navigation?
Managed navigation is the taxonomy-based alternative to the traditional SharePoint navigation feature.
71) What are Catalogs?
Allow you to incorporate lists into your publishing sites.

72) At a high level, what is cross-site publishing?
Enables you to reuse content across multiple site collections.

73) What is the Machine Translation Service?
The Machine Translation Service is a new service application in SharePoint 2013 that provides automatic machine translation of files and sites.

74) What is PowerPoint Automation Services?
Allows conversion from the PowerPoint binary file format (.ppt) and the PowerPoint Open XML file format (.pptx) to other formats.

75) What are the supported source presentation formats?
Open XML File Format presentation format (.pptx) and PowerPoint 97รข€“2003 presentation (.ppt).

Thursday, 5 July 2012

How to Configure Excel Services in SharePoint 2010

In this post, I will show how to configure excel Services in SharePoint 2010.
Following are the steps to configure excel services

  1. Click Application Management
  2. Click Manage Service Applications
  3. Click Secure Store Services Applications
  4. Click on new and fill the necessary details as shown below

a. Target Application ID: SP2010ExcelServices

b. Display Name: SP2010ExcelServices

c. Contact Email:

d. Target Application Type: Group

e. Target Application URL: None and then click next.





5. Keep the default settings and click next




6. Fill the below details

a. Target Application Administrators: Domain\Administrator

b. Members: Domain\Domain Users and click ok.






7. Once the target application ID is created, Checked the checkbox next to SP2010ExcelServices and click on generate new key in the ribbon.


8. Enter the Pass Phrase


9. Once again checked the checkbox next to SP2010ExcelServices and click on set credentials in the ribbon.







10. Once again click Application Management, Manage Service Applications and then Excel Services Applications.

11. Click Global Settings, Scroll to the bottom of the page and in the Application ID field under external data, enter SP2010ExcelServices then click OK.

How to use SharePoint 2010 Chart web part with Excel Services

In this post, I will show how to use SharePoint 2010 chart web part with excel services to display various charts. Firstly we need to configure excel services on the SharePoint server.
To use excel services with chart web part, we need URL of the excel document and range of spreadsheet. Once we have these things, edit the page and insert chart web part to it. Click on Data & Appearance and then Connect Chart to Data.
Choose Excel services then screen with display and fill the excel workbook path and range of spreadsheet.
Excel web service URL should be already filled.
Excel workbook path: SiteURL/Shared%20Documents/Sales.xlsx
Range: Sheet1!$A$1:$B$6
Then click next.
Keep the default setting for remaining pages and then click finish.
Final output will be

How to use SPSecurity.Runwithelevatedprivileges Method in Sharepoint 2010

In this post, I will explain in which scenario we need to use SPSecurity.Runwithelevatedprivileges method in sharepoint customisation.
There are many times when we need our code to perform certain functions that current logged In user does not have permission to perform. The SPSecurity class contains Runwithelevatedprivileges method that allow to run code under full control prilvileges.
SPSecurity.RunWithElevatedPrivileges(delegate()
{
// Code
});
This delegate method run with elevated rights under the Application Pool identity which has site collection administrator privileges on all site collections.

Wednesday, 4 July 2012

History of SharePoint

Development of SharePoint has a long history and many pre products were created before actual product came to existence.

Pre-SharePoint
Before SharePoint 2003 arrived, in 1996 Microsoft launched a product called Microsoft Site Server for managing websites and the user's authentication/authorization. In 1998, Microsoft launched Site Server v 3.0 with following features:
• Indexing and Search
• Content Management
• Product Management
• Order Processing
• Site Personalization
• Ad Server

Site server was a low-cost product with good content management abilities but it lacked document management and taxonomical abilities.
In 1997, Microsoft came with Microsoft Office FrontPage, which had a HTML WYSIWYG editor, used to create and administrate websites. Microsoft launched the last version of FrontPage in 2003 and was having abilities to view code and design by supporting asp. NET.

Neither Site Server nor FrontPage provides the ability to integrate & collaborate different information such as videos, files, applications, and documents.
Earliest Versions of SharePoint
Two versions of SharePoint came out in 2001.
1. SharePoint Team Services (STS)
2. SharePoint Portal Server (SPS)

The SharePoint Team Services (STS) developed from the Microsoft FrontPage was considered a bottom’s-up technology that means creating websites were still left to end users. The websites created using STS supported a maximum of 75 users. STS was also known as Office webserver. SharePoint Team Services (STS) was intended as a departmental Intranet and used SQL Server as its backing store.

The SharePoint Portal Server (SPS) was developed from the Site Server, for site administrators. SPS is used to index and search files stored on STS.
There was still a clear disconnect between the STS and SPS. The move to integrate their functionality drove the development of SharePoint.
SharePoint 2003
Microsoft launched WSS 2.0 and SharePoint Server in 2003 separately.

Windows SharePoint service 2.0 was made freely available as a component with Microsoft windows server 2003. WSS 2.0 enables organizations to create websites and portals easily for information sharing and document collaboration.

SharePoint 2003 was considered the first integrated and comprehensive solution for sharing information, files, applications, and websites. It integrates the capabilities of the STS and SPS. It allows website & dashboard creation using easy user interface. SharePoint 2003 server is a licensed product. It provides all the features of WSS 2.0 and many additional features.

SharePoint 2003, stores the entire top-level site configuration and data in a single database. This limits the effective size that a site collection could grow; even backups and restores were time- consuming. The web parts (web parts are reusable components that display content on web pages) available were more compatible but they were very complex to create. Permissions were clumsy and difficult to maintain.

SharePoint 2007
Microsoft upgraded WSS 2.0 to WSS 3.0 by still keeping it as freely available.
Until now, end users started enjoying the experience of SharePoint and providing feedback with the demand of more and more new features. In 2007, Microsoft came up with the new product termed as “SharePoint 2007”. This product was in integration with the Microsoft base office user product called “Microsoft office,” so Microsoft termed this product as “MOSS 2007 [Microsoft Office SharePoint Portal Server 2007]. Moss 2007 integrates with windows server, SQL Server and the .Net Framework.
In the earlier versions of SharePoint, the primary site-editing tool was FrontPage that at least in theory could be used for other web creation projects as well. With SharePoint 2007, FrontPage was extensively updated and rebranded as Office SharePoint Designer. SharePoint Designer allowed easy customization of sites without needing to write any code. Microsoft Office SharePoint Designer 2007 is a new product for creating and customizing Microsoft SharePoint Web sites and building workflow-enabled applications. It provides the professional quality design tools that you need to create great-looking SharePoint pages that are compatible with a wide range of browsers.

SharePoint 2010
The hunger and desire to add more and more user-friendly features according to user needs continued and in April 2010, Microsoft came up with the latest version called “SharePoint 2010”. The technology WSS 3.0 is upgraded to “SharePoint Foundation Server”. Like WSS 3.0 Microsoft continued its practice to keep the technology SharePoint foundation server as free version. SharePoint latest versions 2010 centers its focus on the Sites, Communities, Content, Search, Insight, and Composite.

Office SharePoint Designer 2007 was upgraded to SharePoint Designer 2010. Microsoft designed SharePoint 2010 as a 64 bit Product. The two main reasons behind this are:
1. Improving the performance
2. Flexibility

Feel free to ping at yusuf.talk786@gmail.com, in case of any queries.

Why this Kolavari Di

"Why this SharePoint SharePoint SharePoint di"

ALL Developers, Architects, Administrators and SharePoint Users
I am appraising SharePoint –u-Web Application Platform-u
Future collaboration Platform-u

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Rhythm correct……
Why this SharePoint SharePoint SharePoint di
maintain please
Why this SharePoint..di

Microsoft la-u- solution for –u-creating Internet Site-u
Easy UI-u-Ribbon Toolbar-u-u-Publishing feature-u
Instant Mobile-u-Expand Reach-u- Customer retention-u
And Drive Revenue
For Any Domain

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Microsoft la-u- solution for –u-creating Intranet Site-u
Communities-u-Content-u-Insight-Search-u-and-u-Composite-u-Sites-u
DMS, CMS-u-RMS-u-Team Site, Template-u
Large Storage, Faster Search-u
With
Future bright

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Pa pa pa ppaan, pa pa pa ppaan, pa pa pa ppaan pa pa ppan
Ok NOW

Developers ready--Ready 1 2 3

.Net Customization

Wat what a coding in .Net

Only SharePoint...

Ok developers now tune change-u

SharePoint 2010 -u- Object Model-u
With SOA Architecture
Site Collection –u-Sub Site-u-Templates-u-MySite-u
List Library, Document Library, -u-web parts –u- solution, Features-u
O-Work-u-flow-u-u-with Dashboards, KPI`s-u
lovvu lovvu
Oh my lovvu
SharePoint showed Future-u

God, .net developers-u-losing control now-u
Tempted to learn SharePoint anyhow-u

This song is for .Net developers -u
Don’t have choice now-u

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

*Objective is to create more awareness about SharePoint.

Download SharePoint 2010 Interview Capsule

This book is free for Download for our dear users. Download a Free copy of SharePoint 2010 Interview Capsule ebook from

SharePoint2010 Interview capsule-wp