Table of Exercises

Exercise 1-1 Determine Your Readiness to Install SharePoint Server 2010in a Single-Server Deployment 9

Exercise 1-2 Explore Other New SharePoint Server 2010 Features 14

Exercise 2-1 Installing SharePoint Server 2010 Prerequisites 44

Exercise 2-2 Installing SharePoint Server 2010 on a Single Server with aBuilt-in Database 45

Exercise 2-3 Creating the First Site Collection in SharePoint Server 2010 47

Exercise 2-4 Creating a Web Application in a Single-Server Deployment 50

Exercise 3-1 Configuring Usage and Health Data Collection inCentral Administration 85

Exercise 3-2 Configuring Usage a Data Collection Using Windows PowerShell 87

Exercise 3-3 Configuring Usage Data Collection for a Single Event Type Using Windows PowerShell 87

Exercise 3-4 Configuring Usage Data Logging in a Different Database UsingWindows PowerShell 88

Exercise 3-5 Configuring Diagnostic Logging Using Central Administration 89

Exercise 3-6 Configuring Diagnostic Logging Using Windows PowerShell 91

Exercise 3-7 Installing the SMTP Service 93

Exercise 3-8 Configuring the SMTP Service 94

Exercise 3-9 Configuring Basic Incoming Email Services 96

Exercise 3-10 Configuring Outgoing Email in Central Administration 100

Exercise 3-11 Configuring Outgoing Email Using the Stsadm.exeCommand-Line Tool 101

Exercise 3-12 Configuring Outgoing Email for a Web Application inCentral Administration 102

Exercise 3-13 Configuring Outgoing Email for a Web Application Usingthe Stsadm.exe Command-Line Tool 102

Exercise 3-14 Creating a Mobile Account for the Server Farm inCentral Administration 103

Exercise 3-15 Creating a Mobile Account for the Server Farm UsingWindows PowerShell 105

Exercise 3-16 Using Central Administration to Configure a Mobile Accountto Receive Notices from a Web Application 105

Exercise 4-1 Using the Farm Configuration Wizard 123

Exercise 4-2 Stopping and Starting a Service in Central Administration 124

Exercise 4-3 Starting and Stopping a Service in Windows PowerShell 125

Exercise 4-4 Enabling or Disabling Declarative Workflows 126

Exercise 4-5 Enabling Nonauthenticated Users to Participate in Workflows 127

Exercise 4-6 Adding a Service Application Connection UsingCentral Administration 132

Exercise 4-7 Adding and Removing a Service Application ConnectionUsing Windows PowerShell 134

Exercise 4-8 Exporting Certificates Using Windows PowerShell 135

Exercise 4-9 Importing the Root Certificate and Creating a Trusted RootAuthority on the Consuming Farm 136

Exercise 4-10 Importing the Root and STS Certificates and Creating aTrusted Authority and Token Issuer 136

Exercise 4-11 Publishing a Service Application Using Central Administration 137

Exercise 4-12 Publishing a Service Application Using Windows PowerShell 139

Exercise 4-13 Connecting to a Remote Service Application UsingCentral Administration 140

Exercise 4-14 Connecting to a Remote Service Application UsingWindows PowerShell 140

Exercise 4-15 Configuring Access Services in Central Administration 143

Exercise 4-16 Adding and Deleting an Access Service Application 144

Exercise 4-17 Configuring Excel Services in Central Administration 146

Exercise 4-18 Enabling User-Defined Functions for Trusted Site LocationsUsing Central Administration 148

Exercise 4-19 Managing Excel Services User-Defined Function Assemblies 148

Exercise 4-20 Enabling PerformancePoint Services for a Site Manually 150

Exercise 5-1 Configuring a Search Proxy Server 173

Exercise 5-2 Configuring the Search Timeout Settings 174

Exercise 5-3 Modifying the Search SSL Settings 175

Exercise 5-4 Reviewing and Managing the Search Administration Page 175

Exercise 5-5 Connecting the Search Service Application to a Web Application 177

Exercise 5-6 Creating a Content Source 177

Exercise 5-7 Creating a Crawl Rule 179

Exercise 5-8 Creating a Crawler Impact Rule 180

Exercise 5-9 Configuring Authoritative Web Pages 182

Exercise 5-10 Importing Federated Locations Search Connectors 183

Exercise 5-11 Manually Configuring Federated Locations Search Connectors 185

Exercise 5-12 Editing a Metadata Property Mapping 187

Exercise 5-13 Adding a Search Scope 188

Exercise 5-14 Adding a Search Scope Rule 189

Exercise 5-15 Configuring a Content Search Service Application 204

Exercise 5-16 Configuring a Query Search Service Application 205

Exercise 6-1 Creating a Managed Metadata Service Application 219

Exercise 6-2 Editing a Managed Metadata Service Application 221

Exercise 6-3 Publishing a Managed Metadata Service Application 221

Exercise 6-4 Creating a Connection to a Managed Metadata Service Application 223

Exercise 6-5 Updating a Managed Metadata Service Connection 224

Exercise 6-6 Creating Metadata Terms for a Library 226

Exercise 6-7 Adding a Term Store Administrator 228

Exercise 6-8 Adding a Content Database Using Central Administration 229

Exercise 6-9 Setting a Content Database to Read-Only 233

Exercise 6-9 Assigning an Administrator to an instance of the BusinessData Connectivity Service 239

Exercise 6-10 Setting Permissions on an External System 241

Exercise 6-11 Configuring an External System 242

Exercise 6-12 Configuring an Instance of an External System 243

Exercise 6-13 Importing a BDC Model or Resource File 244

Exercise 6-14 Exporting a BDC Model or Resource File 245

Exercise 6-15 Setting Permissions on a BDC Model 245

Exercise 6-16 Setting Permissions on an External Content Type 247

Exercise 6-17 Adding an Action to an External Content Type 247

Exercise 6-18 Creating or Editing a Profile Page for an External Content Type 249

Exercise 7-1 Creating a User Profile Service Application inCentral Administration 261

Exercise 7-2 Creating a User Profile Service Application UsingWindows PowerShell 263

Exercise 7-3 Defining a Managed Path 264

Exercise 7-4 Editing a User Profile Service Application 265

Exercise 7-5 Assigning an Administrator to a User Profile Service Applicationin Central Administration 266

Exercise 7-6 Assigning an Administrator to a User Profile Service ApplicationUsing Windows PowerShell 267

Exercise 7-7 Delegating Administration of User Profile Service FeaturesUsing Central Administration 269

Exercise 7-8 Creating a Custom User Profile Property 270

Exercise 7-9 Editing a Custom User Profile Property 272

Exercise 7-10 Creating a Custom Organization Profile Property 273

Exercise 7-11 Enabling Users or Groups to Use Personal and Social Features 281

Exercise 7-12 Disabling Social Tags and Note Boards for a User or Group 283

Exercise 7-13 Deleting All Tags and Notes for a User or URL 284

Exercise 7-14 Adding an Audience 285

Exercise 7-15 Editing an Audience 286

Exercise 7-17 Compiling an Audience 288

Exercise 7-18 Scheduling an Audience to Be Compiled 288

Exercise 8-1 Creating the Portal Site Web Application withKerberos Authentication 304

Exercise 8-2 Creating the Enterprise Wiki Using the CollaborationPortal Template 305

Exercise 8-3 Verifying Successful Kerberos Authentication 306

Exercise 8-4 Creating the Portal Site Web Application withClaims-Based Authentication 307

Exercise 8-5 Configuring Anonymous Access for a Claims-BasedWeb Application 308

Exercise 8-6 Configuring a Forms-Based Web Application to Usean LDAP Provider 309

Exercise 8-7 Customizing an Existing Permission Level 323

Exercise 8-8 Copying and Customizing an Existing Permission Level 324

Exercise 8-9 Creating a New Permission Level 325

Exercise 9-1 Creating a PerformancePoint Services Service Application inCentral Administration 344

Exercise 9-2 Configuring the Unattended Service Account forPerformancePoint Services 346

Exercise 9-3 Activating the SharePoint Publishing Infrastructure 347

Exercise 9-4 Enabling the PerformancePoint Service Site Feature 347

Exercise 9-5 Creating a Business Intelligence Center Site with a Template 348

Exercise 9-7 Enabling User-Defined Functions on a Trusted File Location 362

Exercise 9-8 Managing Excel Services User-Defined Function Assemblies 362

Exercise 9-9 Managing Excel Services Trusted Data Connection Libraries 363

Exercise 9-10 Managing Excel Services Trusted Data Providers 364

Exercise 9-11 Managing Excel Services Trusted Locations 365

Exercise 9-12 Adding an Application ID and Setting Permissions 368

Exercise 10-1 Viewing Site Collections in a Web Application UsingCentral Administration 379

Exercise 10-2 Creating a Site Collection Using Central Administration 380

Exercise 10-3 Deleting a Site Collection Using Central Administration 381

Exercise 10-4 Configuring a Connection to a Portal Site 383

Exercise 10-5 Creating a Documents Repository Connection 383

Exercise 10-6 Editing a Documents Repository Connection 384

Exercise 10-7 Creating and Changing Quota Template Settings 385

Exercise 10-8 Changing the Quote Template for a Site Collection 387

Exercise 10-9 Changing the Storage Limits for a Site Collection 387

Exercise 10-10 Creating a New Site Quota Template 389

Exercise 10-11 Creating a Site Collection Lock 390

Exercise 10-12 Configuring Automated Site Collection Deletion 391

Exercise 10-13 Setting Up My Sites 392

Exercise 10-14 Adding a Trusted My Site Host Location 393

Exercise 10-15 Adding a Link to Office 2010 Client Applications 395

Exercise 10-16 Creating a Wiki Using Central Administration 400

Exercise 10-17 Blocking File Types 402

Exercise 10-18 Configuring Content Deployment Settings 403

Exercise 10-19 Creating a New Content Deployment Path 405

Exercise 10-20 Creating a New Content Deployment Job 407

Exercise 10-21 Modifying Quick Deploy Job Settings 410

Exercise 10-22 Viewing Deployment of Specific Content 411

Exercise 10-23 Viewing the Current Content Deployment Job Report 412

Exercise 10-24 Viewing the Job History and Job Report for Content Deployment 412

Exercise 10-25 Enabling the Document Conversion Launcher or LoadBalancer Services 413

Exercise 10-26 Enabling Document Converters on a Web Application 414

Exercise 11-1 Enabling Sandboxed Solutions 431

Exercise 11-2 Configuring Sandbox Load Balancing 432

Exercise 11-3 Blocking a Sandbox Solution 432

Exercise 11-4 Configuring the State Service Using the Farm Configuration Wizard 434

Exercise 11-5 Activating Workflows in a Site Collection 437

Exercise 11-6 Associating a Workflow to a List or Document Library 438

Exercise 11-7 Associating a Workflow with a Site Content Type 439

Exercise 11-8 Starting an Instance of a Workflow for a Site 440

Exercise 11-9 Canceling a Workflow for a List or Library 441

Exercise 11-10 Viewing an Individual Workflow Report 443

Exercise 11-11 Enabling and Disabling Declarative Workflows 444

Exercise 11-12 Allowing Internal Nonauthenticated Users Access to a Workflow 446

Exercise 11-13 Disabling Automatic Cleanup in Workflow 447

Exercise 11-14 Downloading a Workflow Template 448

Exercise 11-15 Uploading a Workflow Template to a Site Collection 448

Exercise 11-16 Configuring Browser-Enabled User Form Templates 450

Exercise 11-17 Configuring InfoPath Forms Data Connection andAuthentication Settings 451

Exercise 11-18 Configuring InfoPath Forms Service Session State 452

Exercise 11-19 Uploading Administrator-Approved InfoPath Form Templates 452

Exercise 11-20 Activating a Form Template in Central Administration 454

Exercise 11-21 Deactivating a Form Template in Central Administration 455

Exercise 11-22 Quiescing a Form Template in Central Administration Priorto Deactivation 455

Exercise 11-23 Uploading a Data Connection File Using Central Administration 457

Exercise 11-24 Enabling InfoPath Forms Web Service Proxy 458

Exercise 11-25 Enabling Server-Specific Authentication 458

Exercise 12-1 Backing Up the Farm with Windows PowerShell 474

Exercise 12-2 Backing Up the Farm with Central Administration 474

Exercise 12-3 Backing Up the Farm Databases with SQL Server Tools 475

Exercise 12-4 Backing Up the Configuration Database withCentral Administration 477

Exercise 12-5 Backing Up the Content Database with Central Administration 480

Exercise 12-6 Backing Up the Content Database with SQL Server Tools 480

Exercise 12-7 Backing Up a Database to a Snapshot with SQL Server Tools 482

Exercise 12-8 Backing Up a Site Collection Using Central Administration 482

Exercise 12-9 Exporting a Site, List, or Library with Central Administration 483

Exercise 12-10 Restoring the SharePoint Farm with Central Administration 488

Exercise 12-11 Restoring a Web Application with Central Administration 493

Exercise 13-1 Configuring Diagnostic Logging 509

Exercise 13-2 Configuring Usage and Health Data Collection 511

Exercise 13-3 Editing Health Data Collection Timer Jobs 513

Exercise 13-4 Configuring Health Data Collection Rules 515

Exercise 13-5 Reviewing Administrative Reports 516

Exercise 13-6 Reviewing Health Reports in Central Administration 517

Exercise 13-7 Reviewing Timer Jobs in Central Administration 518

Exercise 13-8 Reviewing Web Analytics in Central Administration 518

Exercise 14-1 Consolidating Application Pools to Conserve Memory 532

Exercise 14-2 Minimizing the Use of the Repair Automatically Feature ofHealth Definition Rules 532

Exercise 14-3 Adjusting Resource Throttling for a Web Application 533

Exercise 14-4 Optimizing Content Database Usage 535

Exercise 14-5 Enabling and Adjusting IIS Compression 536

Exercise 14-6 Configuring BLOB Cache Settings 537

Exercise 14-7 Configuring Output Caching in Site Collection Administration 539

Exercise 14-8 Creating Object Cache User Accounts in Central Administration 540

Exercise 14-9 Configuring a Mobile Account in Central Administration forthe Server Farm 543

Exercise 14-10 Configuring a Mobile Account in Central Administration fora Web Application 544

Exercise 14-11 Configuring Mobile Views for a List 546

Exercise 14-12 Configuring a Cross-Firewall Access Zone for Mobile Accounts 547

Exercise 15-1 Using Generic Cmdlets and Commands 562

Exercise 15-2 Getting Help for SharePoint Cmdlets 565