SharePoint Interview Questions 4

  1. 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
  2. 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.
  3. 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 on-line 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.,,, etc.). You can set up a site for your company that can be accessed by anyone without any user name and password. The internet is used for public presence and a primary marketing tool managed typically by web programmers and a system administrator. An intranet (or internal network), though hosted on a Web site, can only be accessed by people who are members of a specific 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. The intranet is commonly used as an internal tool for giving employees access to company information. Content is driven by business relevance, business rules and has increasingly become a common tool in larger organizations. An intranet is becoming more and more the preferred method for employees to interact with each other and the central departments in an organization, whether or not the organization has a Web presence.
  9. 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.
  10. 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.
  11. 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.
  12. 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.
  13. 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
  14. 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.
  15. 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.
  16. 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. But 3rd pary software can do this for you:
  17. Can SharePoint be linked to a SQL database?
    SharePoint 2007 Portal Server (MOSS2K7) allows connections to SQL based datasources via the Business Data Catalog (BDC). The BDC also allows connecting to data via Web Services. Or you can link lists directly qith sql queries in the list settings using the BDLC found here: .
  18. 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.
  19. 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.
  20. 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.