Interview Questions and Answers of SharePoint 2007 for Administrator

Q. Can you personalize Shared Services for a single Web

. 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.

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 How to Create or Move Site Collections into Separate Databases of SharePoint

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

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

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

Q. When to use
Diffrent Site Collections?

An Individual Site
collection offers following :

For the Users:

Dedicated Recycle
Dedicated usage Reports
Distributed administration (site collection
Dedicated search scopes, keywords, and best-bets
feature deployments
Dedicated language translation maintenance
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

For the IT Administrators:

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