SharePoint Interview Questions II

Hi Readers, I have taken reference from google to collect SharePoint related interview questions from different places and write them in one place to make it easy for you all.

1.Describe the potential components for both a single server, and multiple servers, potentially several tiered farms:

A single-server SharePoint Server 2010 environment leverages a built-in SQL Server 2008 Express database. The problems with this environment is scalability, not being able to install the with built-in database on a domain controller, the database cannot be larger than 4 GB, and you cannot use User Profile Synchronization in a single server with built-in database installation.

Multiple tier farms would be a three-tier topology, considered one of the more efficient physical and logical layouts to supports scaling out or scaling up and provides better distribution of services across the member servers of the farm.

2. How will you use Web Parts or other solutions Created in SharePoint 2007 in SharePoint 2010?

In SharePoint 2010 the 12 hive is now replaced by 14 hive, So we will rewrite and recompile any code that refers to files and resources in “12″ hive. In addition to we must recompile custom code written for Windows SharePoint Services 3.0 and Office SharePoint Server 2007 that does not run on IIS.

3. When would you use claims, and when would you use classic?

Classic is more commonly seen in upgraded 2007 environments whereas claims are the recommended path for new deployments.

4. What is the difference between Classic mode authentication and Claims-based authentication?

As the name suggests, classic authentication supports NT authentication types like Kerberos, NTLM, Basic, Digest, and anonymous. Claims based authentication uses claims identities against a against a trusted identity provider.

5. What is the advantage in using Windows PowerShell over stsadm in SharePoint 2010 ?

Unlike stsadm, which accept and return text, Windows PowerShell is built on the Microsoft .NET Framework and accepts and returns .NET Framework objects. Windows PowerShell also gives you access to the file system on the computer and enables you to access other data stores, such as the registry and the digital signature certificate stores etc..

6. What are My Sites?

Specialized SharePoint sites personalized and targeted for each user.

7. What are content databases?

A content database can hold all the content for one or more site collections.

8. What is a site?

A site in SharePoint contains Web pages and related assets such as lists, all hosted within a site collection.

9. What is a site collection?

A site collection contains a top-level website and can contain one or more sub-sites web sites that have the same owner and share administration settings.

10. Differentiate zones?

Different logical paths (URLs meaning) of gaining access to the same SharePoint Web application

11. Importance of application pools?

They provide a way for multiple sites to run on the same server but still have their own worker processes and identity.

12.  Define Web Applications in SharePoint?

An IIS Web site created and used by SharePoint 2010. Saying an IIS virtual server is also an acceptable answer.

13. What are Terms and Term Sets?

A term is a word or a phrase that can be associated with an item.  A term set is a collection of related terms.

14. How many of types of Term Sets?

There are Local Term Sets and Global Term Sets, one created within the context of a site collection and the other created outside the context of a site collection, respectively.

15. What is a sandboxed solution?

Components that are deployed to run within the sandboxed process rather than running in the production Internet Information Services (IIS) worker process.

16. Why are sandboxed solutions used?

Primarily because they promote high layers of isolation. By default they run within a rights-restricted, isolated process based around Code Access Security (CAS). Isolation is possible to increase with activities like running the sandboxing service on only specific SharePoint 2010 servers.

17. What is a search scope?

A search scope defines a subset of information in the search index. Users can select a search scope when performing a search.

18. What is query logging in SharePoint 2010?

Collects information about user search queries and search results that users select on their computers to improve the relevancy of search results and to improve query suggestions.

19. Please describe what a Service Application is in SharePoint 2010.

Service applications in SharePoint 2010 are a set of services that can possibly be shared across Web applications. Some of these services may or may not be shared across the SharePoint 2010 farm.

1. Examples are mentioned below:
2. Access Services
3. Business Data Connectivity service
4. Excel Services Application
5. Managed Metadata service
6. Performance Point Service Application
7. Search service
8. Secure Store Service
9. State service
10. Usage and Health Data Collection service
11. User Profile service
12. Visio Graphics Service
13. Web Analytics service
14. Word Automation Services
15. Microsoft SharePoint Foundation Subscription Settings Service

20. What is Access Services?

Allows users to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an internet browser, the Access client, or a linked HTML page.

21. What is Visio Services?

Allows users to share and view Microsoft Visio Web drawings. The service also enables data-connected Microsoft Visio 2010 Web drawings to be refreshed and updated from various data sources.

22.  What is Performance Point Services?

Allows users to monitor and analyze a business by building dashboards, scorecards, and key performance indicators (KPIs).

23. What is the Secure Store Service (SSS)?

A secure database for storing credentials that are associated with application IDs

24. What is Excel Services?

Allows sharing, securing, managing, and using Excel 2010 workbooks in a SharePoint Server Web site or document library. Excel Services consists of the Excel Calculation Services (ECS), Microsoft Excel Web Access (EWA), and Excel Web Services (EWS) components.

25. what is the difference between SQL clustering and mirroring?

Clustering provides a failover scenario whereby one or more nodes can be swapped as active depending on whether a node goes down. In mirroring, transactions are sent directly from a

principal database and server to a mirror database to establish essentially a replica of the database.

26.what are the monitoring features that are present in SharePoint 2010.

Diagnostic logging captures data about the state of the system, whereas health and usage data collection uses specific timer jobs to perform monitoring tasks, collecting information about:

Performance Counter Fata

Event Log Data

Timer Service Data

Metrics For Site Collections and Sites

Search Usage Data

27. Explain how connections are managed with Service Applications.

A virtual entity is used that is referred to as a proxy, due to label in PowerShell.