Installing and Configuring a SP Environment Flashcards

1
Q

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?

A

stsadm -o preupgradecheck

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What edition(s) of SharePoint Server 2010 SP1 support searching of documents on Windows 7 desktops?

A

Standard Edition and Enterprise Edition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the four steps to create a data connection file in a data connection library for InfoPath Forms Services?

A
  1. Create a data connection library to store data connections.
  2. Create a form template.
  3. Add the intended data connection to the form template.
  4. Convert the data connection to a data connection file.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the two types of crawl schedules?

A

Full and Incremental Crawls

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What tools or utilities can you use to detach a Microsoft SharePoint Server 2010 or SharePoint Server 2010 SP1 content database?

A

Either the SharePoint Central Administration Web site or the Dismount-SPContentDatabase cmdlet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How can you ensure an Active Directory group named Sales can manage the profiles, audiences, and permissions of a User Profile service application?

A

Make the Sales group administrators for the User Profile service application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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?

A

Mirror query components

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

If you distribute the crawl role to multiple servers, what functionality can overwrite the built-in load balancing of the crawls?

A

Host distribution rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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?

A

Use Central Administration to remove the database server from the farm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the default daily point total for a sandboxed solution’s resource quota?

A

300 points

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do you ensure that audit logs do not consume large amounts of disk space?

A

Enable audit log trimming

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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?

A

The user account must be assigned the dbcreator and securityadmin server roles on the SQL Server 2008 database server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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?

A

Configure a Federated Search

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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?

A

BCS - Microsoft Business Connectivity Services

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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?

A

Publish the managed metadata service application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which site locking option will allow users to access, add, modify, or delete content on the site?

A

the Not Locked option in the Site Lock Information section

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Why would you partition a SharePoint index?

A

To improve Latency and Throughput

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the threshold number of items that can be placed in an index?

A

10 million items

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which site locking option will prevent users from adding, updating, or deleting content on the site?

A

the Read-only (blocks additions, updates, and deletions) option in the Site Lock Information section

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What edition(s) of SharePoint Server 2010 SP1 support phonetic name matching and nickname searches?

A

Standard Edition and Enterprise Edition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What are three reasons for running a solution package in a sandbox?

A
  1. You want to run the solution packages in an isolated and restricted environment.
  2. You do not want the solution packages to affect stability, but have strict quotas set on the resources that the solution packages consume.
  3. You want the solution packages run under a strict code access security policy as protection against malicious code.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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?

A

in-place upgrade

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What solution can you install on a SharePoint 2010 SP1 server to provide you with centralized management of electronic forms for the entire organization?

A

InfoPath Forms Services

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

How can you have users search for all documents that contain a specific value in a custom property in the metadata?

A

Add a managed property to the Metadata property mappings in the Crawl Settings section

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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?

A

Install an iFilter for the file type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

How often is the point total on a sandboxed solution’s resource quota reset?

A

Every day

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What should you do to create, import, and manage term sets and the terms within them for your SharePoint Online instance?

A

Use the Term Store Management Tool

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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?

A

In Central Administration on the Excel Services Application Add Trusted File Location page, under Manage service applications > Excel Services Application > Trusted File Locations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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?

A

STSADM.EXE -o preupgradecheck command

30
Q

What must be set for PerformancePoint services to connect to data sources as a set of domain credentials that are impersonated?

A

The unattended service account

31
Q

To ensure administrators can use Central Administration in Spanish and English, what should you do?

A

Install the Spanish language pack for SharePoint Server 2010 SP1

32
Q

Where is the report that is created the stsadm -o preupgradecheck command stored?

A

The report file is stored in the %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12\LOGS directory

33
Q

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?

A

Alternate Access Mapping (AAM)

34
Q

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?

A
  1. Add the extension used by the document as a file type

2. Install an iFilter for the file type

35
Q

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?

A

the WssPreUpgradeCheck.xml file and the OssPreUpgradeCheck.xml file

36
Q

Which versions of Windows Server can you use to install SharePoint Server 2010 SP1?

A

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

37
Q

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?

A

Audiences. There are two kinds of audiences: Global audiences, and Windows security groups and distribution lists

38
Q

If you want to balance the load of servicing crawls across multiple farm servers, what should you add to the crawl servers?

A

Crawl components

39
Q

What is the format for the name of the report that is created when you run the STSADM.EXE -o preupgradecheck command?

A

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

40
Q

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?

A

You can configure the SharePoint 2010 SP1 service account as a domain user account, Local System account, or Network Service account

41
Q

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?

A

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.

42
Q

What edition(s) of SharePoint Server 2010 SP1 supports searching of billions of documents?

A

Enterprise Edition

43
Q

After installing the Spanish language pack, what settings do you configure to allow users to administrator SharePoint 2010 SP1 in Spanish?

A

Site Action - Site Settings - Language Settings

44
Q

Which upgrade method offers deep and informative error reporting and logging capabilities to give you better insight into the upgrade process?

A

in-place upgrade

45
Q

What PowerShell cmdlet can you use to find the GUID of the content database?

A

the Get-SPContentDatabase cmdlet

46
Q

What tool enables you to make the Visual Upgrade feature available during an in-place upgrade?

A

The psconfig command-line tool

47
Q

What is a prerequisite for running Access Services for SharePoint Server 2010 SP1?

A

the installation of Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 (SSRS)

48
Q

Where do you define the data providers that can be used when refreshing data connections for Excel Services in SharePoint?

A

The Trusted Data Providers page in Central Administration under Manage service applications > Excel Services Application > Manage Excel Services

49
Q

Which upgrade method is the best to user if your hardware barely meets the requirements for upgrading to SharePoint 2010 SP1?

A

Database attach upgrade

50
Q

Where do you set the maximum size of a chart, diagram, flowchart, or network diagram created on a SharePoint 2010 SP1 farm?

A

Edit the Maximum Web Drawing Size field on the Visio Graphics Service Settings page under Central Administration

51
Q

Where are the .HTM, .TXT, and .XML versions of the report that is created by running the STSADM.EXE -o preupgradecheck command stored?

A

in the %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12\LOGS directory

52
Q

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?

A

Either Windows Server 2008 R2 or a 64-bit version of Windows Server 2008

53
Q

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?

A

The -Updateuserexperience parameter of the Mount-SPContentDatabase Windows PowerShell cmdlet

The -preserveolduserexperience parameter of the addcontentdatabaseStsadm operation

54
Q

What method of deploying updates to a SharePoint 2010 SP1 farm reduces downtime?

A

In-place updates, with backward compatibility to reduce downtime

55
Q

Which site locking option will prevent users from accessing content on the site?

A

the No access option in the Site Lock Information section

56
Q

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?

A

Enable the Allow embedded SQL authentication setting from the Configure InfoPath Form Services screen in Central Administration

57
Q

What cmdlet should you use to upload a data connection file?

A

Install-SPDataConnectionFile

58
Q

What PowerShell cmdlet do you use to configure authentication and data connection settings for InfoPath Forms Services?

A

the Set-SPInfoPathFormServices PowerShell cmdlet

59
Q

Where do you register managed code assemblies that can be used by spreadsheets in Excel Services for SharePoint?

A

The User Defined Function Assemblies page in Central Administration under Manage service applications > Excel Services Web Service Application > Manage Excel Services

60
Q

What can you use to ensure URLs that contain a question mark are crawled?

A

configure a crawl rule

61
Q

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?

A

InfoPath Forms Services

62
Q

What PowerShell cmdlet do you use to delete the content database from SQL Server?

A

the Remove-SPContentDatabase cmdlet

63
Q

How do you ensure that audit logs are kept for a limited time?

A

Enable audit log trimming

64
Q

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?

A

preserveolduserexperience

65
Q

What standard must an external site support to be included in a federated search from SharePoint 2010 SP1?

A

The OpenSearch standard

66
Q

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?

A

The same drive letter for the alternate location

67
Q

What should you do to index the contents of PDF documents stored in a document library on a SharePoint 2010 SP1 server?

A

Add the PDF as a file type

Install an iFilter for PDF file type

68
Q

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?

A

Visio Graphics Service

69
Q

What tools, commands, or utilities can you use to create Alternate Access Mappings (AAM) in SharePoint 2010 SP1?

A

AAMs can be created via the Application Management section of your farm’s Central Administration site or with the New-SPAlternateURL PowerShell cmdlet.

70
Q

What utility do you use to remove a failed Web server or application server in a SharePoint 2010 SP1 server farm?

A

Use Programs and Features in Control Panel to find SharePoint 2010 in the list of currently installed programs and click Uninstall