70-667 Sharepoint
What are three reasons for running a solution package in a sandbox?
You want to run the solution packages in an isolated and restricted environment. You do not want the solution packages to affect stability, but have strict quotas set on the resources that the solution packages consume. You want the solution packages run under a strict code access security policy as protection against malicious code. Objective: Installing and Configuring a SharePoint Environment
What entity analyzes the metadata associated with an item and makes routing decisions based on the metadata?
a content organizer rule Objective: Deploying and Managing Applications
What happens when you delete a custom permission level from the Site Permissions page?
any users or groups that are leveraging this permission level for access will be removed from the Site Permissions PageObjective: Managing a SharePoint Environment
If you distribute the crawl role to multiple servers, what functionality can overwrite the built-in load balancing of the crawls?
host distribution rules Objective: Installing and Configuring a SharePoint Environment
Which feature prevents anonymous users from gaining access to certain areas of a sub-site under a Publishing Portal site template?
lockdown mode Objective: Managing a SharePoint Environment
What parameter would you use with the Psconfig command line tool to switch to the new user interface of SharePoint 2010 if the Visual Upgrade option is not available?
preserveolduserexperience Objective: Installing and Configuring a SharePoint Environment
What command do you use to create a report on the status of your environment and SharePoint sites before you upgrade to Microsoft SharePoint Server 2010?
stsadm o preupgradecheck Objective: Installing and Configuring a SharePoint Environment
What cmdlet can add a service application connection from a service application connection group?
the Add-SPServiceApplicationProxyGroupMember cmdlet Objective: Deploying and Managing Applications
What cmdlet would you use in a script to run a scheduled task to back up the contents of a SharePoint site every day at 02:00AM?
the Backup-SPSite cmdlet Objective: Maintaining a SharePoint Environment
What feature assigns a four- to twelve-character identifier to a document or document set?
the Document ID feature Objective: Deploying and Managing Applications
Which permission level allows a user to create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites?
the Full Control permission level Objective: Managing a SharePoint Environment
What PowerShell cmdlet can you use to find the GUID of the content database?
the Get-SPContentDatabase cmdlet Objective: Installing and Configuring a SharePoint Environment
What command should you run on your SharePoint 2007 farm to evaluate the current state of the farm and see if can be upgraded to SharePoint 2010?
the STSADM.EXE -o preupgradecheck command Objective: Installing and Configuring a SharePoint Environment
What PowerShell cmdlet do you use to configure authentication and data connection settings for InfoPath Forms Services?
the Set-SPInfoPathFormServices PowerShell cmdlet Objective: Installing and Configuring a SharePoint Environment
What feature in SharePoint 2010 performs infrastructure tasks for the SharePoint Services Timer v4 service (SPTimerv4), such as clearing the timer job history and recycling the timer service:, and tasks for Web applications, such as sending e-mail alerts?
timer jobs Objective: Deploying and Managing Applications
How can you avoid manually changing the passwords of managed accounts when the domain password policy expires the password?
use Central Administration to modify the managed accounts settings for the managed account and select the Enable automatic password change checkbox Objective: Managing a SharePoint Environment
What are the two default administrative reports that can be used to diagnose where the costly portion of a query is being executed?
• SharePoint Backend Query Latency report • Query Latency report Objective: Managing a SharePoint Environment
What should you do to index the contents of PDF documents stored in a document library on a SharePoint 2010 server?
1. Add the PDF as a file type 2. Install an iFilter for PDF file type Objective: Installing and Configuring a SharePoint Environment
What are the three access restrictions that can be configured on an Anonymous Policy for Web applications?
1. None - Anonymous users have same permissions as authenticated users 2. Deny Write - Anonymous users can read all content within the site collection, site, or item in a Web application, depending on the restriction 3. Deny All - Blocks anonymous users from the Web application Objective: Managing a SharePoint Environment
What are two ways to create a content deployment path?
1. Use the New-SPContentDeploymentJob cmdlet 2. Click the Configure content development path and jobs in the General Application Settings section of the Central Administration Web site Objective: Deploying and Managing Applications
What happens when you extend a Web application?
A separate Web site is created in Internet Information Services (IIS) manager to serve the same content, but it will have a different URL and authentication type Objective: Managing a SharePoint Environment
What tools, commands, or utilities can you use to create Alternate Access Mappings (AAM) in SharePoint 2010?
AAMs can be created via the Application Management section of your farm's Central Administration site or with the New-SPApplication PowerShell cmdlet. Objective: Installing and Configuring a SharePoint Environment
Which cmdlet uploads a SharePoint solution package to the farm?
Add-SPSolution cmdlet Objective: Deploying and Managing Applications
What must you add to a DNS server when you create a host header for a Web application?
An A record for the name of the host header Objective: Deploying and Managing Applications
Where in Central Administration can you specify the location of the trace log files?
Central Administration > Monitoring > Reporting > Configure Administrative Reports Objective: Managing a SharePoint Environment
How can you prevent users from creating any new site collections in a content database, but still allow them to view content in the content database?
Change the content database status to Offline in Central Administration Objective: Deploying and Managing Applications
What are the three ways that a farm administrator can change the storage limits to a site collection?
Change the storage limit on the quota template that the site collection is using • Designate a new quota template that has a higher storage limit to the site collection • Change the storage limit for the site collection manually Objective: Deploying and Managing Applications
How can you specify a message for users to receive when they attempt to run a blocked solution?
Click the Manage user solutions link under System Settings in Central Administration to add a message for a blocked solution Objective: Deploying and Managing Applications
How can you track whether users edit items, check out items, delete items, or restore items?
Configure Site collection audit settings from Site Collection Administration Objective: Deploying and Managing Applications
What must you configure to allow users to search content on the SharePoint 2010 server and the Bing.com search engine with the same keywords, and have the results return on a single results page?
Configure a federated search Objective: Installing and Configuring a SharePoint Environment
What SharePoint 2010 feature uses an advanced routing engine and administrator-defined routing rules to route documents from a drop library to a specific location, based on document metadata, and can apply metadata automatically to a document based on its location?
Content Organizer Feature Objective: Deploying and Managing Applications
Which site permission can assign to a group that will allow members to view, add, update, and delete list items and documents?
Contribute Objective: Managing a SharePoint Environment
What is the unique GUID that is assigned to each user conversation with SharePoint?
Correlation ID Objective: Managing a SharePoint Environment
If you want to balance the load of servicing crawls across multiple farm servers, what should you add to the crawl servers?
Crawl components Objective: Installing and Configuring a SharePoint Environment
How would you assign users the ability to add items to lists or document libraries, and to discard or check in a document that is checked out to another user, but no other permissions?
Create a custom permission level Objective: Managing a SharePoint Environment
How can you apply a permission level that is similar to the Contribute permission level, but does not allow users to delete items?
Create a new permission level based on the Contribute permission and remove the Delete Items permission from the custom definition Objective: Managing a SharePoint Environment
Which site permission can assign to a group that will allow members to view, add, update, delete, approve, and customize list items and documents?
Design Objective: Managing a SharePoint Environment
What version(s) of Windows Server would be required to upgrade a deployment of Microsoft Office SharePoint Server 2007 Service Pack 2 (SP2) on a 64-bit version Windows Server 2003?
Either Windows Server 2008 R2 or a 64-bit version of Windows Server 2008 Objective: Installing and Configuring a SharePoint Environment
What tools or utilities can you use to remove a Microsoft SharePoint Server 2010 content database?
Either the SharePoint Central Administration Web site or the Dismount-SPContentDatabase cmdlet Objective: Installing and Configuring a SharePoint Environment
What setting on the SharePoint Designer Settings Pageallows site owners and designers to customize master pages and Pagelayouts using SharePoint Designer?
Enable Customizing Master Pages and PageLayouts setting Objective: Deploying and Managing Applications
How do you prevent user profiles from being shared between different site collections?
Enable multi-tenant support Objective: Deploying and Managing Applications
What setting on the Configure InfoPath Form Services Web Service Proxy screen in Central Administration should you enable to allow forms to connect to a SQL Server with credentials in a connection string?
Enable the Allow embedded SQL authentication setting from the Configure InfoPath Form Services screen in Central Administration Objective: Installing and Configuring a SharePoint Environment
What edition(s) of SharePoint Server 2010 supports searching of billions of documents?
Enterprise Edition Objective: Installing and Configuring a SharePoint Environment
How often is the point total on a sandboxed solution's resource quota reset?
Every day Objective: Installing and Configuring a SharePoint Environment
What are two methods to back up a service application, such as the Excel Services application or the Visio Services application?
Execute the Backup-SPFarm cmdlet or use the Backup and Restore section on the Central Administration home page. Objective: Maintaining a SharePoint Environment
How can you restore the contents of a deleted list without restoring the entire contents of the site collection?
Export the list using Central Administration and restore the list by using the Import-SPWeb cmdlet Objective: Maintaining a SharePoint Environment
How many Alternate Access Mappings (AAM) can you create for each SharePoint 2010 Web application?
Five per URL Objective: Installing and Configuring a SharePoint Environment
What are two ways that you can activate an administrator-approved form template so users can use it?
From the Central Administration Web site, navigate to the Manage Form Templates page, choose the form template, and then click Activate to a Site Collection Use the Enable-SPInfoPathFormTemplate Windows PowerShell cmdlet Objective: Deploying and Managing Applications
Where can you set the maximum number of alerts for a Web application?
In the General Settings of the Web application Objective: Deploying and Managing Applications
Which upgrade method is designed to allow for failed upgrades or upgrades with errors to be restarted at the point of failure?
In-place upgrade Objective: Installing and Configuring a SharePoint Environment
What setting on a quota template, how can you modify settings to reduce the frequency of e-mails concerning maximum usage of points?
Increase the number of points for the Send warning e-mail when usage per day reaches: setting. Objective: Deploying and Managing Applications
What solution can you install on a SharePoint 2010 server to provide you with centralized management of electronic forms for the entire organization?
InfoPath Forms Services Objective: Installing and Configuring a SharePoint Environment
To ensure administrators can use Central Administration in Spanish and English, what should you do?
Install the Spanish language pack for SharePoint Server 2010. Objective: Installing and Configuring a SharePoint Environment
Which cmdlet activates the solution in a site collection?
Install-SPSolution Objective: Deploying and Managing Applications
Which cmdlet deploys the solution package to the farm after it has been uploaded?
Install-SPSolution cmdlet Objective: Deploying and Managing Applications
How can you ensure an Active Directory group named Sales can manage the profiles, audiences, and permissions of a User Profile service application?
Make the Sales group administrators for the User Profile service application Objective: Installing and Configuring a SharePoint Environment
After you configure incoming e-mail messages, what permissions allow users to configure e-mail enabled lists and document libraries?
Manage Lists permissions Objective: Managing a SharePoint Environment
If Microsoft SQL Server is installed on the same machine as SharePoint Server 2010, what service application would you need to configure in order to connect to external data?
Microsoft Business Connectivity Services (BCS) Objective: Installing and Configuring a SharePoint Environment
What strategy should you use to automate the backup of your SharePoint farm?
Microsoft recommends that you create a backup script by using Windows PowerShell, and then use Windows Task Scheduler to run the backup script on a regular basis Objective: Maintaining a SharePoint Environment
If you want to balance the load of servicing queries across multiple farm servers, what should be added to an index partition and associated with the query-servicing servers?
Mirror query components Objective: Installing and Configuring a SharePoint Environment
How do you apply a cache profile all authenticated users when they access a site in a site collection?
Modify the Site Collection output cache from Site Settings. Objective: Managing a SharePoint Environment
What SharePoint 2010 feature allows for site collections within a single Web application to be grouped, and for each group's user experiences, profile stores, search indices, and other resources to be isolated from one another, while still using the shared resources of the overall farm?
Multi-tenancy Objective: Deploying and Managing Applications
What PowerShell cmdlet will create a site collection?
New-SPSite Objective: Deploying and Managing Applications
How would you enable anonymous access for the default zone?
On the Web application in Central Administration, click Authentication Providers, choose the default zone, and click Enable anonymous access Objective: Managing a SharePoint Environment
How many times per User Profile service application can the My Site Host site template be used?
Once Objective: Deploying and Managing Applications
What tool enables you to make the Visual Upgrade feature available during an in-place upgrade?
Psconfig command-line tool Objective: Installing and Configuring a SharePoint Environment
What should you do to ensure that a User Profile service application on one farm can be used on another farm in a different forest?
Publish the User Profile service application and create a two-way trust between the domains. Objective: Installing and Configuring a SharePoint Environment
What should you do to ensure that a managed metadata service application on one farm can be used on another farm in a separate forest?
Publish the managed metadata service application Objective: Installing and Configuring a SharePoint Environment
What are the three process required to enable sandbox solutions?
SPUSHostService.exe, SPUSHostService.exe, and SPUCWorkerProcessProxy.exe Objective: Deploying and Managing Applications
Where can you see alerts from health checks that are implemented through Health Rules?
SharePoint Health Analyzer Objective: Maintaining a SharePoint Environment
After installing the Spanish language pack, where do you allow users to administrator SharePoint 2010 in Spanish?
Site Actions > Site Settings > Language Settings Objective: Installing and Configuring a SharePoint Environment
Who can restore items from the second-stage Recycle Bin?
Site collection administrators Objective: Managing a SharePoint Environment
What does the Maximum Upload Size setting on the Web Application general settings do?
Specifies the maximum size to allow for a single upload to any site Objective: Deploying and Managing Applications
What edition(s) of SharePoint Server 2010 support phonetic name matching and nickname searches?
Standard Edition and Enterprise Edition Objective: Installing and Configuring a SharePoint Environment
Besides a SharePoint backup, what tool can you use to back up a SharePoint farm?
System Center Data Protection Manager (DPM) 2010 Objective: Maintaining a SharePoint Environment
Which site locking option will prevent users from adding content, but will allow users to delete content on the site?
The Adding content prevented option in in the Site Lock Information section Objective: Installing and Configuring a SharePoint Environment
What PowerShell cmdlet can you use to deploy a solution package to a Web application?
The Install-SPSolution cmdlet Objective: Deploying and Managing Applications
Which permission level is not assigned, but is the result of customizing permissions for a securable object?
The Limited Access permission level Objective: Managing a SharePoint Environment
What setting limits the number of items that a database operation can involve at one time?
The List View Threshold setting from the Resource Throttling settings in Central Administration Objective: Managing a SharePoint Environment
What template must be used for the My Site host site collection's site?
The My Site Host site template Objective: Deploying and Managing Applications
Which site locking option will prevent users from accessing content on the site?
The No access option in in the Site Lock Information section Objective: Installing and Configuring a SharePoint Environment
What cmdlet can remove a service application connection from a service application connection group?
The Remove-SPServiceApplicationProxyGroupMember cmdlet Objective: Deploying and Managing Applications
What PowerShell cmdlet would you use to restore specific Web applications and their content databases from a backup?
The Restore-SPFarm cmdlet Objective: Maintaining a SharePoint Environment
What cmdlet can you use to specify the location of the trace log files?
The Set-SPDiagnosticConfig cmdlet Objective: Managing a SharePoint Environment
What cmdlet is used to log usage data into a separate logging database in Microsoft SharePoint Server 2010?
The Set-SPUsageApplication cmdlet Objective: Maintaining a SharePoint Environment
What cmdlet would you use to specify the events that you want to collect in the usage data collection log?
The Set-SPUsageDefinition cmdlet Objective: Managing a SharePoint Environment
What SQL database role membership is required for a user to administrate SharePoint 2010 with Windows PowerShell?
The SharePoint_Shell_Access role Objective: Deploying and Managing Applications
What is a prerequisite for running Access Services for SharePoint Server 2010?
The installation of Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 (SSRS) Objective: Installing and Configuring a SharePoint Environment
Where is the report that is created the stsadm o preupgradecheck command stored?
The report file is stored in the %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12 \LOGS directory Objective: Installing and Configuring a SharePoint Environment
What are the minimum permissions required on a SQL Server 2008 database server for an Active Directory account to create a SharePoint 2010 server farm?
The user account must be assigned the dbcreator and securityadmin server roles on the SQL Server 2008 database server Objective: Installing and Configuring a SharePoint Environment
What is a cross-scope activation dependency?
This dependency occurs when a Feature at a particular scope has a dependency on another Feature at a different scope. Objective: Deploying and Managing Applications
Why would you partition a SharePoint index?
To improve latency and throughput Objective: Installing and Configuring a SharePoint Environment
How do you enable system-generated warning notifications about upcoming password change events for managed accounts?
Use Central Administration to modify the managed accounts settings for the managed account. Enable Enable automatic password change and enable Start notifying by e-mail. Objective: Managing a SharePoint Environment
What utility do you use to remove a failed database server in a SharePoint 2010 server farm if the server cannot be restored from a backup?
Use Central Administration to remove the database server from the farm Objective: Installing and Configuring a SharePoint Environment
What utility do you use to remove a failed Web server or application server in a SharePoint 2010 server farm?
Use Control Panel to remove the database server from the farm Objective: Installing and Configuring a SharePoint Environment
How do you reduce utilization on a single Web server by equally passing requests for Web services among multiple Web services?
Use load balancing Objective: Installing and Configuring a SharePoint Environment
How can you configure a content database on a SQL Server 2008 R2 to be read-only?
Use the Microsoft SQL Management Studio or use the ALTER DATABASE statement. Objective: Deploying and Managing Applications
Who can restore items from the first-stage Recycle Bin?
Users or site collection administrators Objective: Managing a SharePoint Environment
If you want users to be able to create and share charts, drawings, flowcharts, and network diagrams and link them to trusted data sources, what application service should be configured in SharePoint Server 2010?
Visio Graphics Service Objective: Installing and Configuring a SharePoint Environment
What service in SharePoint 2010 runs timer jobs?
Windows SharePoint Services Timer v4 (SPTimerv4) service Objective: Deploying and Managing Applications
