Sharepoint Interview Questions

Download as pdf or txt
Download as pdf or txt
You are on page 1of 9

Q What is Sharepoint?

Ans: Portal Collaboration Software.

Q What is the difference between SharePoint Portal Server and Windows SharePoint
Services?Ans: 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 andlists. You apply information to certain areas within your
portal from windows sharepoint Services or directly to portal areas.

Q What is a document library?


Ans: A document library is where you upload your core documents. They consist of a row
and columnview with links to the documents. When the document is updated so is the link
on your site. Youcan also track metadata on your documents. Metadata would consist of
document properties.

Q What is a meeting workspace?


Ans: A meeting workspace is a place to store information, attendees, and tasks related to
a specificmeeting.

Q What is a document workspace?


Ans: Document workspaces consist of information surrounding a single or multiple
documents.

Q What is the difference between a document library and a form library?


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

Q What is a web part zone?


Ans: Web part zones are what your web parts reside in and help categorize your web
parts when designing a page.

Q How is security managed in SharePoint?


Ans: Security can be handled at the machine,domain, or sharepoint level.

Q How are web parts developed?


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

Q What is a site definition?


Ans: It’s a methods for providing prepackaged site and list content.
Q What is a template?
A template is a pre-defined set of functions or settings that can be used over time. There
are manytemplates within SharePoint,Site Templates, Document Templates, Document
Library and ListTemplates.

Q How do you install web parts?


Ans: Web Parts should be distributed as a .CAB (cabinet) file using the MSI Installer.

Q What is CAML?
Ans: CAML stands for Collaborative Application Markup Language and is an XML-based
languagethat is used in Microsoft Windows SharePoint Services to define sites and lists,
including, for Eg, fields, views, or forms, but CAML is also used to define tables in the
Windows SharePoint Servies database during site provisioning.

Q What is a DWP?
Ans: The file extension of a web part.

Q What is the GAC?


Ans: Global Assembly Cache folder on the server hosting SharePoint. You place your
assemblies there for web parts and services to share them.

Q What are the differences between web part page gallery, site gallery,Virtual server
galleryand online gallery?
Ans: Web Part Page Gallery is the default gallery that comes installed with SharePoint.
Site Gallery isspecific to one site. Virtual Server gallery is specific to that virtual server
and online gallery aredownloadable web parts from Microsoft.

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


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

Q What is Microsoft Windows SharePoint Services? How is it related to Microsoft


OfficeSharePoint Server 2007?
Ans: Windows SharePoint Services is the solution that enables you to create Web site for
information sharing and document collaboration. Windows SharePoint Services — a key
piece of theinformation worker infrastructure delivered in Microsoft Windows Server 2003
— providesadditional functionality to the Microsoft Office system and other desktop
applications, and itserves as a platform for application development.Office SharePoint
Server 2007 builds on top of Windows SharePoint Services 3.0 to provideadditional
capabilities including collaboration, portal, search,Enterprise content
management,business process and forms, and business intelligence.

Q. Who is Office SharePoint server 2007 designed for?


Ans: Office SharePoint Server 2007 can be used by information workers, IT administrators,
and application developers.

Q. What are the main benefits of Office SharePoint Server 2007?


Ans: 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 oftheir 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
acrossorganizational boundaries using InfoPath Forms Services–driven solutions.

* Information workers can find information and people efficiently and easily through
thefacilitated information-sharing functionality and simplified content publishing. In
addition, accessto back-end data is achieved easily through a browser, and views into this
data can bepersonalized.

* 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
BusinessApplications, that combine powerful developer functionality with the flexibility
and ease ofdeployment of Office SharePoint Server 2007. Through the use of out-of-the-
box applicationservices, developers can build richer applications with less code.

Q. What is the difference between Microsoft Office SharePoint Server 2007 for
Internet sites and Microsoft Office SharePoint Server 2007?
Ans: Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office
SharePoint Server2007 have identical feature functionality. While the feature
functionality is similar, the usagerights are different.If you are creating an Internet, or
Extranet, facing website, it is recommended that you useMicrosoft 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 forInternet 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.

Q.What suites of the 2007 Microsoft Office system work with Office SharePoint Server
2007?
Ans: Office Outlook 2007 provides bidirectional offline Synchronization with SharePoint
documentlibraries, discussion groups, contacts, calendars, and
tasks.vabnix.page.tlMicrosoft Office Groove 2007, included as part of Microsoft Office
Enterprise 2007, will enablebidirectional offline synchronization with SharePoint
document libraries.Features such as the document panel and the ability to publish to
Excel Services will only beenabled 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).

Q. How do I invite users to join a Windows SharePoint Services Site? Is the site secure?
Ans: SharePoint-based Web sites can be password-protected to restrict access to
registered users, whoare invited to join via e-mail. In addition, the site administrator can
restrict certain members' rolesby assigning different permission levels to view post and
edit.

Q Can I post any kind of document?


Ans: You can post documents in many formats, including .pdf, .htm and .doc. In addition,
if you areusing Microsoft Office XP, you can save documents directly to your Windows
SharePointServices site.

Q Can I create custom templates?


Ans: Yes you can. You can have templates for business plans, doctor's office, lawyer's
office etc.

Q. How can I make My site public?


Ans: 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 yourbusiness card, e-mail or any other marketing material. The URL for your Web site
will be:http:// yoursitename.wss.bcentral.comHence, please take special care to name
your site.These Web sites are ideal for information and knowledge intensive sites and/or
sites where youneed to have shared Web workspace.Remember: Under each parent Web
site, you can create up to 10 sub-sites each with uniquepermissions, settings and security
rights.

Q. How do the sub sites work?


Ans: 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 BThe URLs for each will be, for example:*
http://yoursitename.wss.bcentral.com/finance*
http://yoursitename.wss.bcentral.com/marketingYou can keep track of permissions for
each team separately so that access is restricted whilevabnix.page.tlmaintaining global
access to the parent site.

Q.How do I make my site non-restricted?


Ans: If you want your site to have anonymous access enabled (i.e., you want to treat it
like any site onthe Internet that does not ask you to provide a user name and password to
see the content of thesite), 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** NothingDefault condition is nothing; your site has restricted
access.
The default conditions allow you to create a secure site for your Web site.

Q. Can I ask users outside of my organization to participate in my Windows


SharePointServices site?
Ans: 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.

Q. Are there any restrictions or requirements for accessing the Windows SharePoint
Services?Ans: No. There are no system or bandwidth limitations for international trial
users. Additionallylanguage packs have been installed which allow users to set up sub-
webs in languages other thanEnglish. These include: Arabic, Danish, Dutch, Finnish,
French, German, Hebrew, Italian,Japanese, Polish, Portuguese (Brazilian), Spanish and
Swedish.

Q. Are there any browser recommendations?


Ans: Yes. Microsoft recommends using the following browsers for viewing and editing
WindowsSharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2,
MicrosoftInternet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape
Navigator
6.2 or later.vabnix.page.
Q.What security levels are assigned to users?
Ans: Security levels are assigned by the administrator who is adding the user. There are
four levels bydefault 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.

Q.What is the difference between an Internet and an intranet site?


Ans: 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 anyonewithout any user name and password.An intranet (or internal
network), though hosted on the Web, can only be accessed by people whoare 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.

Q. What is a workspace?
Ans: A site or workspace is when you want a new place for collaborating on Web pages,
lists anddocument libraries. For example, you might create a site to manage a new team
or project,collaborate on a document or prepare for a meeting.

Q.How customizable is the user-to-user access?


Ans: User permissions apply to an entire Web, not to documents themselves. However,
you can haveadditional sub webs that can optionally have their own permissions. Each
user can be given any offour default roles. Additional roles can be defined by the
administrator.

Q.Can each user have access to their own calendar?


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

Q. What types of files can I upload / post to the site?


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

Q.Can SharePoint be linked to an external data source?


Ans: 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 datasource.

Q. Can SharePoint be linked to a SQL database?


Ans: This is possible via a custom application, but it not natively supported by SharePoint
or SQLServer.

Q.Can I customize my Windows SharePoint Services site?


Ans: 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 personalviews; change logos; connect Web Parts and
more.To fully customize your site, you can use Microsoft FrontPage 2003. Specifically, you
can useFrontPage themes and shared borders, and also use FrontPage to create photo
galleries and top tenlists, utilize standard usage reports, and integrate automatic Web
content.

Q. Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of


MicrosoftWindows?Ans: Windows SharePoint Services 3.0, Office SharePoint Server 2007,
Office Forms Server 2007, andOffice SharePoint Server 2007 for Search will support 64-bit
versions of Windows Server 2003.

Q. What are the features that the portal components of Office SharePoint Server 2007
include?Ans: The portal components of Office SharePoint Server 2007 include features
that are especially useful for designing, deploying, and managing enterprise intranet
portals, corporate Internet Websites, and divisional portal sites. The portal components
make it easier to connect to people withinthe organization who have the right skills,
knowledge, and project experience.

Q.What are the advanced features of MOSS 2007?


Ans: * 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

Q.What are the features of the new Content management in Office SharePoint 2007?
Ans: The new and enhanced content management features in Office SharePoint Server
2007 fall within three areas:

* Document management
* Records management.
* Web content managementOffice SharePoint Server 2007 builds on the core document
management functionality providedby 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 enhancedauthoring, business document
processing, Web content management and publishing, recordsmanagement, policy
management, and support for multilingual publishing.

Q.Does a SharePoint Web site include search functionality?


Ans: Yes. SharePoint Team Services provides a powerful text-based search feature that
helps you finddocuments and information fast.

Q.What are the benefits of Microsoft Office SharePoint Server 2007?


Ans: * 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 acrossdisparate systems.* Connect people
with information and expertise.* Accelerate shared business processes across
organizational boundaries.* Share business data without divulging sensitive information.*
Enable people to make better-informed decisions by presenting business-critical
information inone central location.* Provide a single, integrated platform to manage
intranet, extranet, and Internet applicationsacross the enterprise.

Q.Will SharePoint Portal Server and Team Services ever merge?


Ans: The products will come together because they are both developed by the Office
team.

Q.What does partial trust mean the Web Part developer?


Ans: If an assembly is installed into the BIN directory, the code must be ensured that
provides errorhandling in the event that required permissions are not available.
Otherwise, unhandled securityexceptions may cause the Web Part to fail and may affect
page rendering on the page where theWeb Part appears.

Q.How can I raise the trust level for assemblies installed in the BIN directory?
Ans: 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.

1.Option Pros Cons Increase the trust level for the entire virtual server.
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.

2.Create a custom policy file for your assemblies. For more information, see "How do I
create acustom policy file?" Recommended approach.This option is most secure.An
assembly can operate with a unique policy that meets the minimum permission
requirementsfor the assembly.By creating a custom security policy, you can ensure the
destination server can run your WebParts.

3.Requires the most configuration of all three options.Install your assemblies in the
GACEasy to implement.This grants Full trust to your assembly without affecting the trust
level of assemblies installed inthe BIN directory.This option is less secure.Assemblies
installed in the GAC are available to all virtual servers and applications on a serverrunning
Windows SharePoint Services. This could represent a potential security risk as
itpotentially grants a higher level of permission to your assembly across a larger scope
thannecessaryIn a development environment, you must reset IIS every time you recompile
assemblies.Licensing issues may arise due to the global availability of your assembly.

Q. Does SharePoint work with NFS?Yes and no.


Ans: It can crawl documents on an NFS volume, but the sharepoint database or logs
cannotbe stored there.

Q.How is SharePoint Portal Server different from the Site Server?


Ans: 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 ondashboards (pages). SS doesn't have anything as advanced as
that. The biggest difference wouldbe SPS document management features which also
integrate with web folders and MS Office. 

You might also like