Scenario Based Questions from Quiz Let

Question 1

You need to ensure that users can upload 100 MB files to a document library.
What would you do?

Answer 1

From Central Administration, modify the Web Application General Settings

Question 2

You need to add a Sharepoint solution at the farm level. Which cmdlet would you use?

Answer 2

add-spsolution

Question 3

You have a sharepoint 2010 server farm. You have two web applications named App1 & App2. You need to prevent App2 from using the Access Services service application. What should you do?

Answer 3

Modify the service connection settings for App2.

Question 4

You have a sharepoint 2010 server farm. You need to prevent users from creating site collections. What should you modify?

Answer 4

The Self-Service site collection management settings

Question 5

You have a sharepoint 2010 server farm. You have a web application. The zones for the web application are configured as:
Default http://webapp.contoso.com
Extranet http://extranet.contoso.com
You need to prevent all users from changing the document library settings for the extranet zone. You must achieve this goal without affecting access to the default zone. What should you do?

Answer 5

Create a custom permission policy that denies the manage lists permission. Apply the custom permission policy to the domain users in the extranet zone.

Question 6

You are the administrator of a sharepoint 2010 farm. You need to ensure that deleted documents are stored in the sharepoint recycle bin for 60 days. What should you do?

Answer 6

From Central Administration, modify the web application general settings. (Web Applications, Manage web applications, General Settings, General Settings, Recycle Bin, Delete items in the recycle bin after ___ days.)

Question 7

You are the administrator of a sharepoint 2010 farm. You have a web part that is packages as a sharepoint solution. You need to prevent a memory leak in the web part from causing excessive memory leaks at the farm level. What would you do?

Answer 7

Deploy the sharepoint solution to a site collection solution gallery.

Question 8

You are the administrator of a sharepoint 2010 farm. You use stsadm.exe to back up the farm every day. You need to restore a web application and all of its associated content. What should you do?

Answer 8

From Central Administration, run the restore from backup wizard.

Question 9

You are the administrator of a sharepoint 2010 farm. You need to automatically backup the server every day. What should you do?

Answer 9

From windows Task Scheduler, create a task that runs stsadm.exe.

Question 10

You are the administrator of a sharepoint 2010 farm. You need to prevent lists from displaying more than 2000 items at a time. What should you do?

Answer 10

From central administration, modify the resource throttling settings. (Central Administration, Application management, Manage Web Applications, General
Settings, Resource Throttling, List view threshold.)

Question 11

You are the administrator of a sharepoint 2010 farm. You need to back up a site collection by using a Microsoft SQL database snapshot. What should you do?

Answer 11

From the sharepoint 2010 management shell, run the backup-spsite cmdlet.

At the Windows PowerShell command prompt type the following command:
Backup-SPSite -Identity -Path [-Force] [-NoSiteLock] [-UseSqlSnapshot] [-Verbose]
If the database server is running an Enterprise Edition of Microsoft SQL Server, we recommend that you also use the UseSqlSnapshot parameter for more consistent backups. You can also export sites or lists from these snapshots.

Question 12

You are the administrator of a sharepoint 2010 farm. You need to view the query latencies of all searches performed on the sharepoint 2010 sites. What should you view?

Answer 12

Administrative Reports

Question 13

You are the administrator of a sharepoint 2010 farm. You need to log all of the changes made to a sites content type and columns. What should you do?

Answer 13

From site settings, modify the audit settings. (Site Actions, Site Settings, Site Collection Administration, Site Collection Audit Settings,
Lists, Libraries, and Sites, “Editing content types and columns.”)

Question 14

You are the administrator of a sharepoint 2010 farm. A database administrator installs and configures remote BLOB storage (RBS) on Server1. You need to ensure that all video files uploaded to the server farm that are more than 1GB are stored in the file. What should you do?

Answer 14

Install and activate RBS on server2

Question 15

From the web.config file of the web site, configure the BLOB cache settings.

Answer 15

You have a sharepoint 2010 server farm that contains a web server and a database server. You have a sharepoint web site that contains large multimedia files. The multimedia files are accessed frequently by users. You need to minimize the traffic between the web server and the database server. What should you do?

Question 16

You are the administrator of a sharepoint 2010 farm. You have two content databases named content_DB1 and content_DB2. You need to move a site collection from content_DB1 to content_DB2. What should you do?

Answer 16

From the sharepoint 2010 management shell, run the move-spsite cmdlet.

Question 17

You discover that the farm backup takes more than 6 hours to complete. You need to reduce the time it takes to fully back up the farm. What should you do?

Answer 17

From the default backup and restore settings, modify the number of backup threads.

(Central Administration, Backup and Restore, Configure backup settings, Number of backup threads)

Question 18

You are the administrator of a sharepoint 2010 farm. You configure a Microsoft excel workbook to connect to a database. All connections to the database must use a Microsoft SQL server named Excel1. You publish the workbook to a sharepoint site. You need to ensure that users can access the database via the published workbook. What should you configure?

Answer 18

Publish the secure store service application.

Question 19

You are the administrator of a sharepoint 2010 farm. A full crawl is scheduled every day. You have a web application that has several document libraries. Each library contains a column named division. You need to ensure that users can search for all documents that contain a specific value in the division columns. What should you create?

Answer 19

A managed property.

(Central Administration, Application Management, Manage Service Applications, Search Service Application, Metadata Properties, New Managed Property)

Question 20

2010 farm. The farm contains several servers, configured as shown in the following table:
Server1 ; Database role
Server2; Web, Crawl
Server3; Crawl
You discover that the average CPU utilization on server3 is 70%. You configure a server named server4 as a crawl server. After further analysis you find that the Average CPU utilization is still 70%. What can you do to reduce the CPU utilization on server3, what should you do?

Answer 20

Add a new crawl component.

Question 21

You have a Sharepoint 2007 server farm, with SP1 installed. All servers in the farm run the server 2003 SP2. You plan on performing an in-place upgrade to sharepoint 2010. You need to ensure that you can successfully run the sharepoint server 2010 pre-upgrade checker. What should you do?

Answer 21

Install windows sharepoint services 3.0 service pack 2 and sharepoint 2007 SP2 on all sharepoint servers.

Question 22

You have a sharepoint server farm that contains the servers shown in the following table.
Server1: Web, Query and Crawl
Server2: Database
You create a web application that uses port 80. This web application uses windows authentication and is accessed using http://server1
You need to ensure that users can access the web application by using the following URLs:
1. HTTP://server1 using windows authentication
2. HTTPS://server1.contoso.com and anonymous authentication
What should you add?

Answer 22

An internal URL to the Alternate Access Mappings settings.

Question 23

You are the administrator of a sharepoint 2010 farm. The farm contains the following servers.
Server1: Database
Server2: Web, Query
Server3: Crawl You need to ensure that users can perform searches if a single server fails. What should you do?

Answer 23

Add a new database server to the farm and configure database mirroring. Add a new sharepoint server 2010 server to the server farm and configure the server as a web server and as a query server.

Question 24

You have a deployment of a sharepoint 2007 server with SP2. The deployment includes the following; one Microsoft SQL server 2005 named server1 and one sharepoint server named server2. The servers run the 64bit edition of windows server 2003, with SP2. You need to ensure that you can perform an in-place upgrade to sharepoint 2010. What should you do?

Answer 24

On server2, upgrade to the 64bit edition of windows server 2008.

Question 25

You have a sharepoint server farm that uses several back end data sources. The backend data sources require authentication. You create a secure store service application. The farm does not have a
Performance Point service application. Security requirements in your organization prevent the use of Kerberos delegation. You plan to implement a new PerformancePoint service application. You need to ensure that all new PerformancePoint dashboards can successfully access the back end data source. How should you configure the PerformancePoint service application?

Answer 25

Configure the Unattended service account setting.

Question 26

You have an administrator approved infopath form template that was created by using Microsoft Infopath designer. You upload the form template to the infopath forms services. You need to make the form template available to a site collection. What should you do first?

Answer 26

From the form template’s context menu, select Activate to a Site Collection.

Question 27

You are the administrator of a sharepoint 2010 farm. You create a web application that supports only forms based authentication. You need to index the content of the web application. What should you do?

Answer 27

Create a new crawl rule.

Question 28

You create a new page. You need to prevent site members from modifying the page. You must achieve this goal without changing the permissions currently assigned to other pages. What should you do first?

Answer 28

Stop inheriting permissions on the page.

Question 29

ou are the administrator of a sharepoint 2010 farm. You populate the department attribute of all users in Active Directory. You have a web part page that contains a web part named SalesWP. You need to ensure that SalesWP only appears on the web part page for users in the Sales department. What should you do first?

Answer 29

From User Profile service application, create a new audience.

Question 30

You are the administrator of a sharepoint 2010 farm. You need to ensure that users can send e-mail messages to document libraries. What should you do?

Answer 30

From Central Administration, configure the incoming e-mail settings.

(Central Administration, System Settings, E-mail and Test Messages (SMS), Configure Incoming E-mail Settings.)

Question 31

You are the administrator of a sharepoint 2010 farm. You need to identify the average time required to load web pages in a web application. What should you do?

Answer 31

From the Central Administration home page, click Monitoring and click View Health Reports.

Question 32

From the Central Administration home page, click Monitoring and click View Health Reports. You have a Microsoft SQL 2008 server with a database that contains a table. The table can only be accessed by an active directory user account named user1. You need to ensure that the table can be used by an external content type. What should you do?

Answer 32

Modify the permissions for the Business Data Connectivity service application.

Question 33

You have a sharepoint 2010 server farm that contains one web application. You discover that several site owners use Microsoft sharepoint designer 2010 to customize the master pages of their site. You need to prevent site owners from modifying their master pages by using Sharepoint Designer. What should you do?

Answer 33

From Central Administration, modify the Sharepoint Designer settings.

Question 34

You are the administrator of a Sharepoint 2010 farm. You configure a user profile service application. You need to ensure that a group named Group1 can manage user profiles. What should you do?

Answer 34

Modify the administrators of the User Profiles services application.

Question 35

You are the administrator of a Sharepoint 2010 farm. You need to move the farm’s logging database to a different database server. What should you do?

Answer 35

From the Configure usage and health data collection page in Central Administration, modify the usage data and collection settings.

(Central Administration, Monitoring, configure usage and health data collection settings, Change DB server)

Question 36

You have a Sharepoint web application named portal. Portal is configured to use NTLM authentication. From Central Administration you configure Portal to use Kerberos authentication. You need to ensure that Kerberos can be used to authenticate Portal. What tool should you use?

Answer 36

Setspn.exe

Service Principal Name

Question 37

You are the administrator of a Sharepoint 2010 farm. You have a web application that is accessed by using https://portal.contoso.com. You need to add a new site collection to the web application. Users must be able to access the new site collection by using the URL HTTPS://hrweb.contoso.com. What should you do?

Answer 37

From the Sharepoint 2010 management shell, run the new-spsite cmdlet.

Get-Help for New-SPSite You cannot do this through a GUI.

Question 38

You are the administrator of a Sharepoint 2010 farm. You need to backup the contents of a custom list every day. The solution must minimize the size of the backup. What should you do?

Answer 38

Create a scheduled task that runs the export-spweb cmdlet.

Question 39

You are the administrator of a Sharepoint 2010 farm. You need to ensure that users can create a maximum of 300 alerts for a web application. What should you do?

Answer 39

Configure the web application general settings.

Question 40

You are the administrator of a Sharepoint 2010 farm. You need to identify if any service applications in the farm are using the farm service account. What should you review?

Answer 40

The health analyzer reports.

Question 41

You are the administrator of a Sharepoint 2010 farm. You deploy several Sharepoint user solutions to a site collection and estimate that the resource usage of the Sharepoint solutions is 600 points. You discover that all of the Sharepoint solutions stop working simultaneously. The next day the Sharepoint solutions automatically start working again. You need to prevent this issue from reoccurring. What should you do?

Answer 41

From the site collection quotas and locks settings, modify the user solution resource quota value.

Question 42

You are the administrator of a Sharepoint 2010 farm. A Sharepoint user solution is uploaded to several site collections. You need to prevent the Sharepoint user solution from running in one specific site collection. What should you do?

Answer 42

Modify the solution gallery at the site.

Question 43

You have a Sharepoint server farm that contains a publishing site. You need to ensure that when users click new page from the site actions menu, the (article Page) image on left template is used by default. What should you do?

Answer 43

From Site Settings, modify the Page layouts and site template settings.

(site actions, site settings, page layout and site template settings, change new page default settings)

Question 44

You are the administrator of a Sharepoint 2010 farm. You need to automatically back up the server farm every day. What should you do?

Answer 44

From Windows task scheduler, create a task that runs stsadm.exe.

Question 45

You have a sharepoint server 2010 farm that contains a web server and a database server. You have a web site that contains large multimedia files. The multimedia files are accessed frequently by a large number of users. You need to minimize the amount of traffic between the web server and the database server. What should you do?

Answer 45

From the web.config file of the web site, configure the BLOB cache settings.

Question 46

You create a new Sharepoint group named group1. You need to configure the permission level to site1 to meet the following requirements:

• Allow the members of group1 to add items
• Prevent the members of group1 from deleting items

What do you do?

Answer 46

Add a new permission level and assign the new permission level to group1.

Question 47

You have a Microsoft SQL server 2008 server named server1. You install Sharepoint server 2010 on a server named server2. Server 1 and Server2 are joined to the same active directory domain. You create a domain user account named admin1. On server2 you add admin1 to the local administrative group. You need to ensure that admin1 can create a server farm with the least amount of permission granted. What should you do?

Answer 47

On server1, assign the dbcreator and the security admin server roles to admin1.

Question 48

ou are the administrator of a Sharepoint 2010 farm. You have a web application that has one publishing site collection. Users report that they are unable to create team sites by using a web browser. You need to ensure that users can create team sites. What should you do from site settings?

Answer 48

Modify the page layouts and site template settings.

Question 49

controls the interaction between a web application and a service application.

Answer 49

Application connection