SharePoint Interview Qestions

Sharepoint Portal Interview Questions what is SharePoint?
Portal Collaboration Software.
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 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?
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.
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.
how is security managed in SharePoint?
Security can be handled at the machine, domain, or sharepoint 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.
what is a site definition?
It’s a methods for providing prepackaged site and list content.
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.
vabnix.page.tl
how do you install web parts?
Web Parts should be distributed as a .CAB (cabinet) file using the MSI Installer.
what is CAML?
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.
what is a DWP?
The file extension of a web part.
what is the GAC?
Global Assembly Cache folder on the server hosting SharePoint. You place your assemblies there
for web parts and services.
what are the differences between web part page gallery, site gallery, virtual server gallery
and online gallery?
Web Part Page Gallery is the default gallery that comes installed with SharePoint. Site Gallery is
specific to one site. Virtual Server gallery is specific to that virtual server and online gallery are
downloadable web parts from Microsoft.
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.
What is Microsoft Windows SharePoint Services? How is it related to Microsoft Office
SharePoint Server 2007?
Windows SharePoint Services is the solution that enables you to create Web sites for information
sharing and document collaboration. Windows SharePoint Services — a key piece of the
information worker infrastructure delivered in Microsoft Windows Server 2003 — provides
additional functionality to the Microsoft Office system and other desktop applications, and it
serves as a platform for application development.
Office SharePoint Server 2007 builds on top of Windows SharePoint Services 3.0 to provide
additional capabilities including collaboration, portal, search, enterprise content management,
business process and forms, and business intelligence.
What is Microsoft SharePoint Portal Server?
SharePoint Portal Server is a portal server that connects people, teams, and knowledge across
business processes. SharePoint Portal Server integrates information from various systems into one
secure solution through single sign-on and enterprise application integration capabilities. It
provides flexible deployment and management tools, and facilitates end-to-end collaboration
through data aggregation, organization, and searching. SharePoint Portal Server also enables users
to quickly find relevant information through customization and personalization of portal content
and layout as well as through audience targeting.
What is Microsoft Windows Services?
Microsoft Windows Services is the engine that allows administrators to create Web sites for
information sharing and document collaboration. Windows SharePoint Services provides
additional functionality to the Microsoft Office System and other desktop applications, as well as
serving as a plat form for application development. SharePoint sites provide communities for team

vabnix.page.tl
collaboration, enabling users to work together on documents, tasks, and projects. The environment
for easy and flexible deployment, administration, and application development.
What is the relationship between Microsoft SharePoint Portal Server and Microsoft
Windows Services?
Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and
Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible
deployment and management tools. Windows SharePoint Services provides sites for team
collaboration, while Share Point Portal Server connects these sites, people, and business processes
—facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends
the capabilities of Windows SharePoint Services by providing organizational and management
tools for SharePoint sites, and by enabling teams to publish information to the entire organization.
Who is Office SharePoint Server 2007 designed for?
Office SharePoint Server 2007 can be used by information workers, IT administrators, and
application developers.
is designed
What are the main benefits of Office SharePoint Server 2007?
Office SharePoint Server 2007 provides a single integrated platform to manage intranet, extranet,
and Internet applications across the enterprise.
* Business users gain greater control over the storage, security, distribution, and management of
their electronic content, with tools that are easy to use and tightly integrated into familiar,
everyday applications.
* Organizations can accelerate shared business processes with customers and partners across
organizational boundaries using InfoPath Forms Services–driven solutions.
* Information workers can find information and people efficiently and easily through the
facilitated information-sharing functionality and simplified content publishing. In addition, access
to back-end data is achieved easily through a browser, and views into this data can be
personalized.
* Administrators have powerful tools at their fingertips that ease deployment, management, and
system administration, so they can spend more time on strategic tasks.
* Developers have a rich platform to build a new class of applications, called Office Business
Applications, that combine powerful developer functionality with the flexibility and ease of
deployment of Office SharePoint Server 2007. Through the use of out-of-the-box application
services, developers can build richer applications with less code.
What is the difference between Microsoft Office SharePoint Server 2007 for Internet sites
and Microsoft Office SharePoint Server 2007?
Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server
2007 have identical feature functionality. While the feature functionality is similar, the usage
rights are different.
If you are creating an Internet, or Extranet, facing website, it is recommended that you use
Microsoft Office SharePoint Server 2007 for Internet sites which does not require the purchase
client access licenses. Websites hosted using an “Internet sites” edition can only be used for
Internet facing websites and all content, information, and applications must be accessible to nonemployees.
Websites hosted using an “Internet sites” edition cannot be accessed by employees
creating, sharing, or collaborating on content which is solely for internal use only, such as an
Intranet Portal scenario. See the previous section on licensing for more information on the usage
scenarios.
What suites of the 2007 Microsoft Office system work with Office SharePoint Server 2007?
Office Outlook 2007 provides bidirectional offline synchronization with SharePoint document
libraries, discussion groups, contacts, calendars, and tasks.

vabnix.page.tl
Microsoft Office Groove 2007, included as part of Microsoft Office Enterprise 2007, will enable
bidirectional offline synchronization with SharePoint document libraries.
Features such as the document panel and the ability to publish to Excel Services will only be
enabled when using Microsoft Office Professional Plus 2007or Office Enterprise 2007.
Excel Services will only work with documents saved in the new Office Excel 2007 file format
(XLSX).
How do I invite users to join a Windows SharePoint Services Site? Is the site secure?
SharePoint-based Web sites can be password-protected to restrict access to registered users, who
are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles
by assigning different permission levels to view post and edit.
Can I post any kind of document?
You can post documents in many formats, including .pdf, .htm and .doc. In addition, if you are
using Microsoft Office XP, you can save documents directly to your Windows SharePoint
Services site.
Can I download information directly from a SharePoint site to a personal digital assistant
(PDA)?
No you cannot. However, you can exchange contact information lists with Microsoft Outlook.
How long does it take to set up the initial team Web site?
It only takes a few minutes to create a complete Web site. Preformatted forms let you and your
team members contribute to the site by filling out lists. Standard forms include announcements,
events, contacts, tasks, surveys, discussions and links.
Can I create custom templates?
Yes you can. You can have templates for business plans, doctor's office, lawyer's office etc.
How can I make my site public?
By default, all sites are created private.If you want your site to be a public Web site, enable
anonymous access for the entire site. Then you can give out your URL to anybody in your
business card, e-mail or any other marketing material. The URL for your Web site will be:
http:// yoursitename.wss.bcentral.com
Hence, please take special care to name your site.
These Web sites are ideal for information and knowledge intensive sites and/or sites where you
need to have shared Web workspace.
Remember: Under each parent Web site, you can create up to 10 sub-sites each with unique
permissions, settings and security rights
.
How do the sub sites work?
You can create a sub site for various categories. For example:
* Departments - finance, marketing, IT
* Products - electrical, mechanical, hydraulics
* Projects - Trey Research, Department of Transportation, FDA
* Team - Retention team, BPR team
* Clients - new clients, old clients
* Suppliers - Supplier 1, Supplier 2, Supplier 3
* Customers - Customer A, Customer B, Customer C
* Real estate - property A, property B
The URLs for each will be, for example:
* http://yoursitename.wss.bcentral.com/finance
* http://yoursitename.wss.bcentral.com/marketing
You can keep track of permissions for each team separately so that access is restricted while

vabnix.page.tl
maintaining global access to the parent site.
How do I make my site non-restricted?
If you want your site to have anonymous access enabled (i.e., you want to treat it like any site on
the Internet that does not ask you to provide a user name and password to see the content of the
site), follow these simple steps:
# Login as an administrator
# Click on site settings
# Click on Go to Site Administration
# Click on Manage anonymous access
# Choose one of the three conditions on what Anonymous users can access:
** Entire Web site
** Lists and libraries
** Nothing
Default condition is nothing; your site has restricted access. The default conditions allow you to
create a secure site for your Web site.
Can I get domain name for my Web site?
Unfortunately, no. At this point, we don't offer domain names for SharePoint sites. But very soon
we will be making this available for all our SharePoint site customers. Please keep checking this
page for further update on this. Meanwhile, we suggest you go ahead and set up your site and
create content for it.
What are picture libraries?
Picture libraries allow you to access a photo album and view it as a slide show or thumbnails or a
film strip. You can have separate folder for each event, category, etc
What are the advantages of a hosted SharePoint vs. one that is on an in-house server?
* No hardware investment, i.e. lower costs
* No software to download - ready to start from the word go
* No IT resources - Anyone who has used a Web program like Hotmail can use it
* Faster deployment
Can I ask users outside of my organization to participate in my Windows SharePoint
Services site?
Yes. You can manage this process using the Administration Site Settings. Simply add users via
their e-mail alias and assign permissions such as Reader or Contributor.
Are there any IT requirements or downloads required to set up my SharePoint site?
No. You do not need to download any code or plan for any IT support. Simply complete the online
signup process and provide us your current and correct email address. Once you have
successfully signed up and your site has been provisioned, we will send a confirmation to the
email address you provided.
I am located outside of the United States. Are there any restrictions or requirements for
accessing the Windows SharePoint Services?
No. There are no system or bandwidth limitations for international trial users. Additionally
language packs have been installed which allow users to set up sub-webs in languages other than
English. These include: Arabic, Danish, Dutch, Finnish, French, German, Hebrew, Italian,
Japanese, Polish, Portuguese (Brazilian), Spanish and Swedish.
Are there any browser recommendations?
Yes. Microsoft recommends using the following browsers for viewing and editing Windows
SharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2, Microsoft
Internet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape Navigator 6.2 or later.

vabnix.page.tl
What security levels are assigned to users?
Security levels are assigned by the administrator who is adding the user. There are four levels by
default and additional levels can be composed as necessary.
* Reader - Has read-only access to the Web site.
* Contributor - Can add content to existing document libraries and lists.
* Web Designer - Can create lists and document libraries and customize pages in the Web site.
* Administrator - Has full control of the Web site.
How secure are Windows SharePoint Services sites hosted by Microsoft?
Microsoft Windows SharePoint Services Technical security measures provide firewall protection,
intrusion detection, and web-publishing rules. The Microsoft operation center team tests and
deploys software updates in order to maintain the highest level of security and software reliability.
Software hot-fixes and service packs are tested and deployed based on their priority and level of
risk. Security related hot-fixes are rapidly deployed into the environment to address current
threats. A comprehensive software validation activity ensures software stability through regression
testing prior to deployment.
What is the difference between an Internet and an intranet site?
An internet site is a normal site that anyone on the internet can access (e.g., www.msn.com, www.
microsoft.com, etc.). You can set up a site for your company that can be accessed by anyone
without any user name and password.
An intranet (or internal network), though hosted on the Web, can only be accessed by people who
are members of the network. They need to have a login and password that was assigned to them
when they were added to the site by the site administrator.
What is a workspace?
A site or workspace is when you want a new place for collaborating on Web pages, lists and
document libraries. For example, you might create a site to manage a new team or project,
collaborate on a document or prepare for a meeting.
What are the various kinds of roles the users can have?
A user can be assigned one of the following roles
* Reader - Has read-only access to the Web site.
* Contributor - Can add content to existing document libraries and lists.
* Web Designer - Can create lists and document libraries and customize pages in the Web site.
* Administrator - Has full control of the Web site.
Can more than one person use the same login?
If the users sharing that login will have the same permissions and there is no fear of them sharing a
password, then yes. Otherwise, this is discouraged.
How customizable is the user-to-user access?
User permissions apply to an entire Web, not to documents themselves. However, you can have
additional sub webs that can optionally have their own permissions. Each user can be given any of
four default roles. Additional roles can be defined by the administrator.
Can each user have access to their own calendar?
Yes there are two ways to do this,
* by creating a calendar for each user, or
* by creating a calendar with a view for each user
How many files can I upload?
There is no restriction in place except that any storage consumed beyond that provided by the base
offering may have an additional monthly charge associated with them.

vabnix.page.tl
What types of files can I upload / post to the site?
The only files restricted are those ending with the following extensions: .asa, .asp, .ida, .idc, .idq.
Microsoft reserves the right to add additional file types to this listing at any time. Also, no content
that violates the terms of service may be uploaded or posted to the site.
Can SharePoint be linked to an external data source?
SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint
can be referenced as an external data source. SharePoint itself cannot reference an external data
source.
Can SharePoint be linked to a SQL database?
This is possible via a custom application, but it not natively supported by SharePoint or SQL
Server.
Can I customize my Windows SharePoint Services site?
YES! Windows SharePoint Services makes updating sites and their content from the browser
easier then ever.
SharePoint includes tools that let you create custom lists, calendars, page views, etc. You can
apply a theme; add List, Survey and Document Library Web Parts to a page; create personal
views; change logos; connect Web Parts and more.
To fully customize your site, you can use Microsoft FrontPage 2003. Specifically, you can use
FrontPage themes and shared borders, and also use FrontPage to create photo galleries and top ten
lists, utilize standard usage reports, and integrate automatic Web content.
Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of Microsoft
Windows?
Windows SharePoint Services 3.0, Office SharePoint Server 2007, Office Forms Server 2007, and
Office SharePoint Server 2007 for Search will support 64-bit versions of Windows Server 2003.
How Office SharePoint Server 2007 can help you?
Office SharePoint Server 2007 can help us:
Manage content and streamline processes. Comprehensively manage and control unstructured
content like Microsoft Office documents, Web pages, Portable Document Format file (PDF) files,
and e-mail messages. Streamline business processes that are a drain on organizational
productivity.
Improve business insight. Monitor your business, enable better-informed decisions, and respond
proactively to business events.
Find and share information more simply. Find information and expertise wherever they are
located. Share knowledge and simplify working with others within and across organizational
boundaries.
Empower IT to make a strategic impact. Increase responsiveness of IT to business needs and
reduce the number of platforms that have to be maintained by supporting all the intranet, extranet,
and Web applications across the enterprise with one integrated platform.
Office SharePoint Server 2007 capabilities can help improve organizational effectiveness by
connecting people, processes, and information.
Office SharePoint Server 2007 provides these capabilities in an integrated server offering, so your
organization doesn't have to integrate fragmented technology solutions itself.
What are the features that the portal components of Office SharePoint Server 2007 include?
The portal components of Office SharePoint Server 2007 include features that are especially
useful for designing, deploying, and managing enterprise intranet portals, corporate Internet Web
sites, and divisional portal sites. The portal components make it easier to connect to people within
the organization who have the right skills, knowledge, and project experience.

vabnix.page.tl
What are the advanced features of MOSS 2007?
* User Interface (UI) and navigation enhancements
* Document management enhancements
* The new Workflow engine
* Office 2007 Integration
* New Web Parts
* New Site-type templates
* Enhancements to List technology
* Web Content Management
* Business Data Catalog
* Search enhancements
* Report Center
* Records Management
* Business Intelligence and Excel Server
* Forms Server and InfoPath
* The “Features” feature
* Alternate authentication providers and Forms-based authentication
What are the features of the new Content management in Office SharePoint 2007?
The new and enhanced content management features in Office SharePoint Server 2007 fall within
three areas:
* Document management
* Records management
* Web content management
Office SharePoint Server 2007 builds on the core document management functionality provided
by Windows SharePoint Services 3.0, including check in and check out, versioning, metadata, and
role-based granular access controls. Organizations can use this functionality to deliver enhanced
authoring, business document processing, Web content management and publishing, records
management, policy management, and support for multilingual publishing.
Does a SharePoint Web site include search functionality?
Yes. SharePoint Team Services provides a powerful text-based search feature that helps you find
documents and information fast.
Write the features of the search component of Office SharePoint Server 2007?
The search component of Office SharePoint Server 2007 has been significantly enhanced by this
release of SharePoint Products and Technologies. New features provide:
* A consistent and familiar search experience.
* Increased relevance of search results.
* New functions to search for people and expertise.
* Ability to index and search data in line-of-business applications and
* Improved manageability and extensibility.
What are the benefits of Microsoft Office SharePoint Server 2007?
* Provide a simple, familiar, and consistent user experience.
* Boost employee productivity by simplifying everyday business activities.
* Help meet regulatory requirements through comprehensive control over content.
* Effectively manage and repurpose content to gain increased business value.
* Simplify organization-wide access to both structured and unstructured information across
disparate systems.
* Connect people with information and expertise.
* Accelerate shared business processes across organizational boundaries.
* Share business data without divulging sensitive information.

vabnix.page.tl
* Enable people to make better-informed decisions by presenting business-critical information in
one central location.
* Provide a single, integrated platform to manage intranet, extranet, and Internet applications
across the enterprise.
Will SharePoint Portal Server and Team Services ever merge?
The products will come together because they are both developed by the Office team.
What does partial trust mean the Web Part developer?
If an assembly is installed into the BIN directory, the code must be ensured that provides error
handling in the event that required permissions are not available. Otherwise, unhandled security
exceptions may cause the Web Part to fail and may affect page rendering on the page where the
Web Part appears.
How can I raise the trust level for assemblies installed in the BIN directory?
Windows SharePoint Services can use any of the following three options from ASP.NET and the
CLR to provide assemblies installed in the BIN directory with sufficient permissions. The
following table outlines the implications and requirements for each option.
Option Pros Cons Increase the trust level for the entire virtual server. For more information, see
"Setting the trust level for a virtual server" Easy to implement. In a development environment,
increasing the trust level allows you to test an assembly with increased permissions while allowing
you to recompile assemblies directly into the BIN directory without resetting IIS. This option is
least secure. This option affects all assemblies used by the virtual server.
There is no guarantee the destination server has the required trust level. Therefore, Web Parts may
not work once installed on the destination server.
Create a custom policy file for your assemblies. For more information, see "How do I create a
custom policy file?" Recommended approach.
This option is most secure.
An assembly can operate with a unique policy that meets the minimum permission requirements
for the assembly.
By creating a custom security policy, you can ensure the destination server can run your Web
Parts.
Requires the most configuration of all three options.
Install your assemblies in the GAC
Easy to implement.
This grants Full trust to your assembly without affecting the trust level of assemblies installed in
the BIN directory.
This option is less secure.
Assemblies installed in the GAC are available to all virtual servers and applications on a server
running Windows SharePoint Services. This could represent a potential security risk as it
potentially grants a higher level of permission to your assembly across a larger scope than
necessary
In a development environment, you must reset IIS every time you recompile assemblies.
Licensing issues may arise due to the global availability of your assembly.
Does SharePoint work with NFS?
Yes and no. It can crawl documents on an NFS volume, but the sharepoint database or logs cannot
be stored there.
How is SharePoint Portal Server different from the Site Server?
Site Server has search capabilities but these are more advanced using SharePoint. SPS uses digital
dashboard technology which provides a nice interface for creating web parts and showing them on
dashboards (pages). SS doesn't have anything as advanced as that. The biggest difference would
be SPS document management features which also integrate with web folders and MS Office.

vabnix.page.tl
What would you like to see in the next version of SharePoint?
A few suggestions:
# SPS and STS on same machine
# Tree view of Categories and Folders
# General Discussion Web Part
# Personalization of Dashboards
# Role Customization
# Email to say WHY a document has been rejected for Approval
# More ways to customize the interface
# Backup and restore an individual Workspaces
# Filter for Visio
# Better way to track activity on SPS
Why Sharepoint is not a viable solution for enterprise wide deployments?
Document management does not scale beyond a single server, but scales great within a single
server. For example, a quad Xeon machine with 4GB of RAM works great for a document
management server that has about 900,000 - 1,000,000 document, but if you need to store
50,000,000 document and want to have them all in one single workspace then it does not scale at
all. If you need a scenario like this, you need to plan your deployment right and it should scale for
you, it just does not right out of the box.
If you are using your server as a portal and search server most for the most part it scales great.
You can have many different servers crawl content sources and have separate servers searching
and serving the content.
If you have <>
50,000 users, SPS should scale just fine for your needs with the proper planning.
What are the actual advantages of SharePoint Portal Services (SPS) over SharePoint Team
Services (STS)?
SharePoint Portal Services (SPS) has MUCH better document management. It has check-in,
check-out, versioning, approval, publishing, subscriptions, categories, etc. STS does not have
these features, or they are very scaled back. SharePoint team Services (SPS) has a better search
engine, and can crawl multiple content sources. STS cannot. STS is easier to manage and much
better for a team environment where there is not much Document Management going on. SPS is
better for an organization, or where Document Management is crucial.
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.