SharePoint Interview Questions

• What is SharePoint?
we cannot define SharePoint in some sort of words ?, actually SharePoint is an application framework as much as it is an application as its own. And provide the following features to web developer and Organization. It is a web development Platform, out put of sharepoint is Web Application. That provide the following features.
1. Collaboration
2. Content magmt.
3. Business intelligence.
4. Enterprise search.
5. Highly integrated with Office
6. Workflow implementation on very depth level
7. Reporting.
8. And a lot more.

• What is the difference between SharePoint Portal Server and Windows SharePoint Services?
SharePoint Portal Server is the global portal offering features like global navigation and searching. Windows SharePoint Services is more content management based with document libraries and lists. You apply information to certain areas within your portal from Windows SharePoint Services or directly to portal areas.

• What is a web part zone?
Web part zones are what your web parts reside in and help categorize your web parts when designing a page. It is the container for the web parts that provide the layouts and place on the web part page. Actually a web part page contains the web part zone, and web part zone contains web parts.

• How is security managed in SharePoint?
Security can be handled at the machine, domain, or sharepoint level. Categorized as.
1. Site level
2. List level
3. Item level

• How are web parts developed?
Web parts are developed in Visual Studio .Net. VS.Net offers many web part and page templates and can also be downloaded from the Microsoft site. Through visual studio we use the .net framework ‘s API [Application Programming Interface] as well as Sharepoint and WSS API for creating the custom web part. We can deploy web part through feature, and can make wsp of feature. As well as by cab project as well.
• What is a SharePoint farm?
farm is a Server Machine. Which host sharepoint, it can be single server or can be Collection of Server that host sharepoint. In Farm s Single Web application is host by multiple server. Multiple machines running services for SharePoint. Otherwise known as Topology.
• What is a site definition?
It’s a methods for providing pre-packaged site and list content. Actually there are two things. And most probably common question for sharepoint technical prespective.
1. Site Template and
2. Site definitions

• What is a template?
A template is a pre-defined set of functions or settings that can be used over time. There are many templates within SharePoint, Site Templates, Document Templates, Document Library and List Templates.

• How do you install web parts?
Web Parts should be distributed as a .CAB (cabinet) file using the MSI Installer.

• What is the difference between a site and a web?
The pages in a Web site generally cover one or more topics and are interconnected through hyperlinks. Most Web sites have a home page as their starting point. While a Web is simply a blank site with SharePoint functionality built in; meaning you have to create the site from the ground up. Site in sharepoint is root site or we can say site collection which can contains web it is the master site which can host other site and web. But web is a single site that contains the functionality of web.

• What is the GAC?
Global Assembly Cache folder on the server hosting SharePoint. You place your assemblies there for web parts and services. Actually GAC is a location in C drive(may be other then c where your OS installed c:windows/assembly folder contains the dll files to make him shared so that we can add this dll’s reference to our any project.

• What is a DWP?
The file extension of a web part. Web part Definitions. DWP and .web part are the extension of Web part ‘s definition file which tell sharepoint to recognize that it is web part.

• What is CAML?
Stands for Collaborative Application Markup Language and is an XML-based language that is used in Microsoft Windows SharePoint Services to define sites and lists, including, for example, fields, views, or forms, but CAML is also used to define tables in the Windows SharePoint Services database during site provisioning. CAML is used only in Sharepoint Object Model.

• What is a document library?
A document library is where you upload your core documents. They consist of a row and column view with links to the documents. When the document is updated so is the link on your site. You can also track metadata on your documents. Metadata would consist of document properties.

• What is a meeting workspace?
A meeting workspace is a place to store information, attendees, and tasks related to a specific meeting.

• What is a document workspace?
Document workspaces consist of information surrounding a single or multiple documents.

• What is a web part?

Just like a user control, a web part contains UI and business logic through .net and Sharepoint API, and add on the SharePoint web part Page. To make the page more power full.
Web parts consist of xml queries to full SharePoint lists or document libraries. You can also develop your own web parts and web part pages.

• What is the difference between a document library and a form library?
Document libraries consist of your core documents. An example would be a word document, excel, powerpoint, visio, pdf, etc… Form libraries consist of XML forms. Both having the almost same features like versioning, filtering, sorting and workflow features. Mainly form library is use to store InfoPath farm.

• What are themes?
Themes provide a quick and easy way to change the appearance of your SharePoint site
• What is presence?
Allows users to see if other users are online and can send them instant messages. Just like a image which show online status.

• Can web parts be connected? if so, how?
Web Parts can be connected by Modifying the Shared Part and providing the connection with the correct fields to share.

• What is a personal view and what is a shared view?
Personal views are specific to a user while Shared View is common across all users. View on list or library. Just like view on sql table.

• What is an STP file?
The file extension that applies to site templates. When we save a list as a template or when we save a site as a template then in both the cases .stp file is created. This is called site or list template. Means extention of list or site template.

• What is an FWP file?
The file extension that applies to SharePoint sites that have been backed up.

• How does SharePoint support MS Outlook integration?
Via Web Parts available at the Microsoft Web Component Directory. Oh yeah and Active X Controls.

• How can you extend lists in SharePoint?
If you mean extend by adding columns of data and have specific data types for each column the answer is yes. You can also use Data Views in FrontPage 2003 to pull in XML data from other sites, lists or document libraries to make the information more presentable for users.

• Explain the document versioning in SharePoint document libraries
When versioning is enabled everytime the document is edited from the SharePoint site it creates a new version. You can restore or delete old versions of documents. Version numbers are incremented by the system itself.

• Where are web part resources contained?
The SharePoint file system, SQL, and the GAC folder. They are also referenced in the web.config folder.

• What are the different installation methods for deploying web parts? and what are the pros/cons?
The best way is via a CAB file using the MSI Installer.

• What is a ghosted/unghosted page?
Page that is created from a template oppsed to being created from scratch.

• How is site data stored?
Site data is stored in your content database that either resides in SQL Server 2000 or MSDE.

• Where is metadata for a web stored?
In the content databases stored in SQL.

• What is an audience and describe the use?
Audiences are a pre-defined set of users that you can apply information to. You can apply information to their personal sites as well for daily information or job tasks.

• What are the trust levels and what is the default trust associated with SharePoint?
SSL and the basic IIS security. SharePoint comes with Integrated Windows Authentication turned on.

• What are the two logging mechanisms for usage statistics?
By default creates log files in the \%windir%\system32\LogFiles\STS directory on the front-end Web server, although an alternate location can be specified. The STS directory contains a folder for each virtual server on the Web server, each named with a GUID that identifies the respective virtual server. Each virtual server folder contains subfolders for each day, which in turn contain the daily usage log for each virtual server. In addition to containing information per virtual server, the Windows SharePoint Services logs are also useful because they associate users with page hits and with time stamps. what functionality does owssup.dll provide for client side activities?

• What is STSAdm and what can it be used for?
STSADMIN is a tool that can do many things from a command prompt like manage users, create new sites and add files to the file system. It is the Command line utility resides on 12 hive Bin folder through which we can perform many admin task.

• Can WSS search subside?
Not without the new CorasWorks Search Web Part.

• Can you register alerts for users?
Not unless you are logged in as that user.

• Are PDFs searchable?
Out of the box only the metadata collected in the upload form is search able. Unless you download and install the Adobe iFilter.
• Describe a large deployment
Many front-end web server with a SQL cluster with the possibility of multiple international locations.

• How can you synchronize custom Active Directory attributes to SharePoint?
Via the Profile Importer.

• If it is anticipated that our organization would need to store 1 terabyte of documents, what is the recommended configuration and storage requirement?
Multiple front-end web servers with content databases across the server farm. The amount of web-servers can depend on how many users you have and what the typical size of a document is.

• Explain how you would deploy SharePoint on an extranet
Usually servers that are accessible from external sources are housed in DMZ’s. Depending on the requirements and the workflow for publishing content you could go with Multiple Servers hosting the same information. One server would reside inside with the SQL Cluster while the external server resides in the DMZ simply calling data. Security would be handled by the same or different active directory domain clusters as well increasing security.

• What is the BKM for maximum number of virtual servers configured for SharePoint on a single box?
I believe it’s 15.

• what are the migration strategies for moving sites around?
You could use the SharePoint Portal Server backup and restore tool as well as the STSADMIN and GUI STSAMIN tools. We have migrated database from the SQL Level and have simply reconnected the front end.can also use import and export system admin command on STSADM.exe utility.

About Krishana Kumar

Krishana Kumar is SharePoint Architect/Trainer having Architecture experience with high volumes at Enterprise level and global scale - creation of highly scalable solutions with global user base and geographically distributed architectural components. Good knowledge of SharePoint best practices and governance models. I hold Two Master degree in Computer Science with over 11 years of experience working on Microsoft Technologies specially SharePoint, Project, .NET and other Information Worker Technologies. Having good exposer in Client side scripting Angular.js, backbone and Node. I am currently responsible for SharePoint Infrastructure set up and leading teams in various medium and large scale projects, architecting, designing & installing SharePoint farms, developing custom components,, and providing advanced SharePoint administration and development training to teams and customers. I regularly speaks in various SharePoint User Groups and other Events. I have MCSA Windows Azure, MCSA Office 365, MCSE & MCSD SharePoint 2013, Microsoft Certified Developer (MCD) and holds MCPD, MCTIP and MCTS for SharePoint 2010, MCTS MOSS 2007 & WSS 3.0, MCPD, MCITP (EPM 2010 & 2007) and MCSD .NET.
This entry was posted in General Interest. Bookmark the permalink.

Leave a Reply

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