Installing and Configuring a SP Environment Flashcards
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 SP1?
stsadm -o preupgradecheck
What edition(s) of SharePoint Server 2010 SP1 support searching of documents on Windows 7 desktops?
Standard Edition and Enterprise Edition
What are the four steps to create a data connection file in a data connection library for InfoPath Forms Services?
- Create a data connection library to store data connections.
- Create a form template.
- Add the intended data connection to the form template.
- Convert the data connection to a data connection file.
What are the two types of crawl schedules?
Full and Incremental Crawls
What tools or utilities can you use to detach a Microsoft SharePoint Server 2010 or SharePoint Server 2010 SP1 content database?
Either the SharePoint Central Administration Web site or the Dismount-SPContentDatabase cmdlet
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
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
If you distribute the crawl role to multiple servers, what functionality can overwrite the built-in load balancing of the crawls?
Host distribution rules
What utility do you use to remove a failed database server in a SharePoint 2010 SP1 server farm if the server cannot be restored from a backup?
Use Central Administration to remove the database server from the farm
What is the default daily point total for a sandboxed solution’s resource quota?
300 points
How do you ensure that audit logs do not consume large amounts of disk space?
Enable audit log trimming
What are the minimum permissions required on a SQL Server 2008 database server for an Active Directory account to create a SharePoint 2010 SP1 server farm?
The user account must be assigned the dbcreator and securityadmin server roles on the SQL Server 2008 database server
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
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?
BCS - Microsoft Business Connectivity Services
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
Which site locking option will allow users to access, add, modify, or delete content on the site?
the Not Locked option in the Site Lock Information section
Why would you partition a SharePoint index?
To improve Latency and Throughput
What is the threshold number of items that can be placed in an index?
10 million items
Which site locking option will prevent users from adding, updating, or deleting content on the site?
the Read-only (blocks additions, updates, and deletions) option in the Site Lock Information section
What edition(s) of SharePoint Server 2010 SP1 support phonetic name matching and nickname searches?
Standard Edition and Enterprise Edition
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.
Which upgrade method requires the server farm to be unavailable to users during the upgrade and takes more time to complete because it updates a single server at a time?
in-place upgrade
What solution can you install on a SharePoint 2010 SP1 server to provide you with centralized management of electronic forms for the entire organization?
InfoPath Forms Services
How can you have users search for all documents that contain a specific value in a custom property in the metadata?
Add a managed property to the Metadata property mappings in the Crawl Settings section
What do you need to install on your SharePoint server to allow users to search the contents of files stored in a SharePoint library if the file is not a common file type?
Install an iFilter for the file type
How often is the point total on a sandboxed solution’s resource quota reset?
Every day
What should you do to create, import, and manage term sets and the terms within them for your SharePoint Online instance?
Use the Term Store Management Tool
Where do you define the specific network file shares, Web folders, or SharePoint databases from which spreadsheets can be loaded by Excel Services in SharePoint 2010 SP1?
In Central Administration on the Excel Services Application Add Trusted File Location page, under Manage service applications > Excel Services Application > Trusted File Locations
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 SP1?
STSADM.EXE -o preupgradecheck command
What must be set for PerformancePoint services to connect to data sources as a set of domain credentials that are impersonated?
The unattended service account
To ensure administrators can use Central Administration in Spanish and English, what should you do?
Install the Spanish language pack for SharePoint Server 2010 SP1
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
If you have a SharePoint site behind a reverse proxy server like Microsoft ForeFront Threat Management Gateway 2010, what should you have configured for the SharePoint 2010 SP1 Web application?
Alternate Access Mapping (AAM)
What should you do to index the contents of a document that uses a proprietary format and is stored in a document library on a SharePoint 2010 SP1 server?
- Add the extension used by the document as a file type
2. Install an iFilter for the file type
When you run the STSADM.EXE -o preupgradecheck command, which two rules files are used to create the PreUpgradeCheck_YYYYMMDD-HHMMSS-SSS-random-number.htm report?
the WssPreUpgradeCheck.xml file and the OssPreUpgradeCheck.xml file
Which versions of Windows Server can you use to install SharePoint Server 2010 SP1?
64-bit edition of Windows Server 2008 Standard, Enterprise, Data Center, or Web Server with SP2
64-bit edition of Windows Server 2008 R2 Standard, Enterprise, Data Center or Web Server
What part of a User Profile service application can you use to enable organizations to target content, such as Web Parts, to users based on their job or task?
Audiences. There are two kinds of audiences: Global audiences, and Windows security groups and distribution lists
If you want to balance the load of servicing crawls across multiple farm servers, what should you add to the crawl servers?
Crawl components
What is the format for the name of the report that is created when you run the STSADM.EXE -o preupgradecheck command?
PreUpgradeCheck_YYYYMMDD-HHMMSS-SSS-random-number.htm, which includes the date and time of the report as well as a random number to differentiate possible duplicates run at the same time
If the SQL Server Reporting Services (SSRS) is installed on the same server as the SharePoint 2010 SP1 server, what are the possible service account configurations you can configure for the SharePoint 2010 SP1 server?
You can configure the SharePoint 2010 SP1 service account as a domain user account, Local System account, or Network Service account
To allow a SharePoint 2010 SP1 farm to consume the search application service application from a publishing SharePoint 2010 SP1 farm, what applications must the consuming farm be given permission to access?
Give the consuming farm permission to the Application Discovery and Load Balancing Service Application on the publishing farm.
Next, give the consuming farm permission to the published service applications that it will be consuming.
What edition(s) of SharePoint Server 2010 SP1 supports searching of billions of documents?
Enterprise Edition
After installing the Spanish language pack, what settings do you configure to allow users to administrator SharePoint 2010 SP1 in Spanish?
Site Action - Site Settings - Language Settings
Which upgrade method offers deep and informative error reporting and logging capabilities to give you better insight into the upgrade process?
in-place upgrade
What PowerShell cmdlet can you use to find the GUID of the content database?
the Get-SPContentDatabase cmdlet
What tool enables you to make the Visual Upgrade feature available during an in-place upgrade?
The psconfig command-line tool
What is a prerequisite for running Access Services for SharePoint Server 2010 SP1?
the installation of Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 (SSRS)
Where do you define the data providers that can be used when refreshing data connections for Excel Services in SharePoint?
The Trusted Data Providers page in Central Administration under Manage service applications > Excel Services Application > Manage Excel Services
Which upgrade method is the best to user if your hardware barely meets the requirements for upgrading to SharePoint 2010 SP1?
Database attach upgrade
Where do you set the maximum size of a chart, diagram, flowchart, or network diagram created on a SharePoint 2010 SP1 farm?
Edit the Maximum Web Drawing Size field on the Visio Graphics Service Settings page under Central Administration
Where are the .HTM, .TXT, and .XML versions of the report that is created by running the STSADM.EXE -o preupgradecheck command stored?
in the %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12\LOGS directory
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
During a database attach upgrade, the choice to update to the new user experience of SharePoint 2010 or retain the SharePoint 2007 user interface is accomplished by using which two command parameters?
The -Updateuserexperience parameter of the Mount-SPContentDatabase Windows PowerShell cmdlet
The -preserveolduserexperience parameter of the addcontentdatabaseStsadm operation
What method of deploying updates to a SharePoint 2010 SP1 farm reduces downtime?
In-place updates, with backward compatibility to reduce downtime
Which site locking option will prevent users from accessing content on the site?
the No access option in the Site Lock Information section
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
What cmdlet should you use to upload a data connection file?
Install-SPDataConnectionFile
What PowerShell cmdlet do you use to configure authentication and data connection settings for InfoPath Forms Services?
the Set-SPInfoPathFormServices PowerShell cmdlet
Where do you register managed code assemblies that can be used by spreadsheets in Excel Services for SharePoint?
The User Defined Function Assemblies page in Central Administration under Manage service applications > Excel Services Web Service Application > Manage Excel Services
What can you use to ensure URLs that contain a question mark are crawled?
configure a crawl rule
What ASP.NET 2.0 Web application allows users to use a Web browser to fill out business forms deployed online on a site hosted on a SharePoint 2010 SP1 server?
InfoPath Forms Services
What PowerShell cmdlet do you use to delete the content database from SQL Server?
the Remove-SPContentDatabase cmdlet
How do you ensure that audit logs are kept for a limited time?
Enable audit log trimming
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
What standard must an external site support to be included in a federated search from SharePoint 2010 SP1?
The OpenSearch standard
When moving a ULS logs stored in the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ LOGS directory to an alternate location, what must all servers in the farm have in common?
The same drive letter for the alternate location
What should you do to index the contents of PDF documents stored in a document library on a SharePoint 2010 SP1 server?
Add the PDF as a file type
Install an iFilter for PDF file type
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 SP1?
Visio Graphics Service
What tools, commands, or utilities can you use to create Alternate Access Mappings (AAM) in SharePoint 2010 SP1?
AAMs can be created via the Application Management section of your farm’s Central Administration site or with the New-SPAlternateURL PowerShell cmdlet.
What utility do you use to remove a failed Web server or application server in a SharePoint 2010 SP1 server farm?
Use Programs and Features in Control Panel to find SharePoint 2010 in the list of currently installed programs and click Uninstall
