SharePoint 2007 Interview Questions for Administrator

Q. Can you personalize Shared Services for a single Web application?

Ans. You cannot assign or un-assign few services to a web application. If the web application is using a perticular SSP, it has to bear the burden of all the services configured in that SSP.

Q. How will you move or separate a Site Collection which stays in a shared WebApplication content database, into its own
separate database.

You can create a new Content database in the target webapplication (which will contain the new site collection). Then adjust the maximum number of sites allowed for the content database currently being used. Then use stsadm command to backup and restore the site colletcion. For Details see Move Site Collections into Separate Databases

Q. What are Security methods(Authentication methods) available in sharepoint 2007.

Ans :
Out of the box", SharePoint 2007 supports nine authentication methods. NTLM (short for NT Lan Manager, which is simply the Windows authentication that everyone is familiar with) and Kerberos (also a Windows "standard" authentication) are offered during installation.

Q.How Does SharePoint work?

The browser sends a DAV packet to IIS asking to perform a document check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the proprietary INVOKE command. Because of the existence of this command, the packet is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB to access the WSS, perform the operation and send the results back to the user in the form of XML.

Q. What is the difference between a site and a web?

A site in sharePoint is a site collection. It is an object of SPsite class in sharepoint. While a Web is simply a blank site within that site collection. Web is a Part of SPweb class, thus represents a site within a site collection.

Q. How will you backup and restore entire farm ?

There are various methods to backup and restore SharePoint entire farm in SharePoint. Two main methods that you can use to back up and restore are:

* Using SharePoint Central Administration Web site - This tool enables you to perform backups and restorations from the user interface. When you use this method, you can back up the server farm, Web applications, and any or all of the content databases in your server farm. You can use the Stsadm command-line tool to view backup and recovery history and to view backup and recovery job status.

* Stsadm command-line tool - Stsadm command-line tool offers a faster and more flexible command-line-based approach to farm backup and recovery. This method for backing up and restoring data does not require SQL Server 2000 tools or SQL Server 2005 tools. However, to perform this method of backup and recovery, you must be a member of the administrators group on a computer on which SharePoint Server or WSS 3.0 is installed.

Other methods to Backup are :

* Backup Farm by using SQL server Tools - You can perform Full,
Differential and Transaction baclups from SQL server studio.

* Third Party Tools - You can also use other Backup and Restore tools such as DocAve for taking daily backups.

Q. When to use Diffrent Site Collections?

An Individual Site collection offers following :

For the Users:

Dedicated Recycle bins
Dedicated usage Reports
Distributed administration (site collection administrators)
Dedicated search scopes, keywords, and best-bets
Custom feature deployments
Dedicated language translation maintenance
Dedicated galleries for web parts, master pages, content types, site columns, site templates, and list templates
Dedicated shared libraries, such as site collection images and site collection styles
Dedicated real estate (Self Containment)

For the IT Administrators:

Site quota templates
Distributed administration
Site locking
Database maintenance options
Backup / Restore abilities
Content Deployments
InfoPath forms services global template targeting


  1. This comment has been removed by a blog administrator.

  2. very nice post .please keep it up, i'm getting a lot from this..

  3. This comment has been removed by a blog administrator.



This is a personal weblog. The opinions expressed here represent my own and not those of my employer or anyone else. Should you have any questions or concerns please e-mail me at .

Copyright (c) 2010 @ All rights are reserved.Do Not Copy.

@ Learning