SharePoint Free Modal Tests for exam preparation

Thank you very much for taking test

Test your caliber

1. What are the Correct statements about Configuration Database in SharePoint 2007.
Every Web Application has its own Configuration DB	A Farm can have only a single config DB
All the servers in a same farm are registered in the same Config DB	A Config DB is created after running the Configuration Wizard

2. Select the correct SQL Server Database versions which can be used for SharePoint Installation.
SQL Server 2008	SQL Server 2005
SQL Server 2000 with SP1	SQL Server 2000 with SP3a

3. Select the correct software configuration combination which can be used to install SharePoint 2007.
.NET 2.0 with Windows XP	.NET 2.0 , Windows Server 2003 Enterprise (SP1), IIS 6.0
.NET 2.0 , Windows Server 2003 , IIS 5.0	.NET 2.0 , Windows Server 2003 Standard (SP1), IIS 6.0

4. Select the correct activities happening while doing the SharePoint Installation.
IIS modification happens during running the Configuration Wizard	IIS modification happens during installing the SharePoint Server
A Web Application is created to host Central Administration while running the Configuration Wizard	A Config DB is created for the SharePoint Farm while running the Configuration Wizard

5. Choose the correct options regarding SharePoint Installation.
Selecting Basic & Stand Alone mode allows to install SharePoint Server with SQL Server Express Edition	Web Front End also install the Shared Services on the machine
We can not choose Web Front End mode while installing SharePoint for a Server until we have a Complete installation on one server in the farm	Complete Installation allows to add/remove servers from the farm

6. Adding a server to provide only Excel Services to an existing SharePoint Farm,what kind of installation we need to perform on the Server.
Basic	StandAlone
Web Front End	Complete

7. To add a server to an existing SharePoint Farm which serves only as web front End machine, what kind of installation we can perform.
Basic	StandAlone
Web Front End	Complete

8. Following Databases are created after the successful completion of the configuring wizard in SharePoint.
Cofig DB for the SharePoint Farm	SSP Content DB

9. Select correct statements regarding the changes in IIS during the installation and configuration of SharePoint 2007.
No changes were made to IIS during the installation of SharePoint Server 2007	The Central Administration Web site was created using the OfficeServerApplicationPool application pool

10. Name the two application pool accounts which are created after successful completion of configuration Wizard of SharePoint 2007.
SharePoint Central Administration 3.0	SharePointServerApplication Pool

11. Choose the correct statements about Variations used in SharePoint 2007.
Variation changes the content into the specified language while copying into the target site.	For content to be pushed from source to target, it must share a content type

12. Select the correct combination for the available features and the SharePoint Server License Type.
Standard - Excel Service	Enterprise - Excel Service

13. Name the three stages of Quiescing in SharePoint 2007.
Normal	Dequiesced

14. What are the correct statement with the Feature Installation/Activation in SharePoint.
Feature can only be Installed through STSADM commands	Feature can be Installed through Central Administration

15. Choose the Correct steps required to deploy a feature in SharePoint.
Create a Folder in C.\Program Files\Common Files\microsoft shared\Web Server Extensions\12\TEMPLATE\FEATURES	Use Central Administration to Install the Feature

16. What is the Database which get created when we install WSS keeping all the defaults while installing.
SQL Server 2000 Compact Edition	SQL Server 2005 Embedded Edition
SQL Server 2000 Embedded Edition	SQL Server 2005 Compact Edition

17. What kind of Site Template we need to select for the site collection on the Destination Server Farm to receive the initial deployment job while using Content Deployment Feature in SharePoint 2007.
Publishing Template	Team Site
Blank	Any Template can be used

18. Select the Information Management Policy which is not available in SharePoint 2007 by default.
Labels	Auditing
Archiving	Barcode

19. Select the wrong STSADM commands related to Solution Deployment in SharePoint 2007.
stsadm -o addsolution -filename SampleSolution.wsp	stsadm -o deploysolution -name SampleSolution.wsp
stsadm -o retractsolution -name SampleSolution.wsp	stsadm -o removesolution -name SampleSolution.wsp

20. When we take the Content DB associated with a web application to Offline status what effect it has on the sites in SharePoint 2007.
User can not browse any site collection created in the content dB	No New further site collection can be created in this content dB
No new sub sites can be created in the site collections already created in this content db	No modification can be made in the site collections associated with the content db and they become read only