Introduction

The Microsoft certification program contains three primary series: Technology, Professional, and Architect. The Technology Series certifications are intended to allow candidates to target specific technologies and are the basis for obtaining the Professional Series and Architect Series of certifications. The certifications contained within the Technology Series consist of one to three exams, focusing on a specific technology and do not include job-role skills. By contrast, the Professional Series of certifications focus on a job role and are not necessarily focused on a single technology but rather a comprehensive set of skills for performing the job role being tested. The Architect Series of certifications offered by Microsoft are premier certifications that consist of passing a review board of previously certified architects. To apply for the Architect Series of certifications, you must have a minimum of 10 years of industry experience.

When obtaining a Technology Series certification, you are recognized as a Microsoft Certified Technology Specialist (MCTS) on the specific technology or technologies on which you have been tested. The Professional Series certifications include Microsoft Certified IT Professional (MCITP) and Microsoft Certified Professional Developer (MCPD). Passing the review board for an Architect Series certification will allow you to become a Microsoft Certified Architect (MCA).

MCTS: Microsoft SharePoint 2010 Configuration Study Guide (70-667) will help you organize and focus your studies and your skill sets so that you will be completely prepared to pass the Microsoft SharePoint Server 2010, Configuring (70-667) certification exam.

The Microsoft Certified Professional Program

Since the beginning of its certification program, Microsoft has certified more than 2 million people. As the computer network industry continues to increase in both size and complexity, this number is sure to grow—and the need for proven ability will also increase. Certifications can help companies verify the skills of prospective employees and contractors.

Microsoft has developed its Microsoft Certified Professional (MCP) program to give you credentials that verify your ability to work with Microsoft products effectively and professionally. Several levels of certification are available based on specific suites of exams. Microsoft has recently created a new generation of certification programs:

Microsoft Technology Associate (MTA) The MTA is Microsoft’s new certification for those new to the field of IT. These exams focus on the fundamental skills and technologies an IT professional should be familiar with.

Microsoft Office Specialist (MOS) The MOS is for power users who use Microsoft Office and Windows Vista.

Microsoft Certified Technology Specialist (MCTS) The MCTS can be considered the entry-level certification for the new generation of Microsoft certifications. The MCTS certification program targets specific technologies instead of specific job roles. You must take and pass one to three exams.

Microsoft Certified IT Professional (MCITP) The MCITP certification is a Professional Series certification that tests network and systems administrators on job roles, rather than only on a specific technology. The MCITP generally consists of one to three exams, in addition to obtaining an MCTS-level certification.

Microsoft Certified Professional Developer (MCPD) The MCPD certification is a Professional Series certification for application developers. Similar to the MCITP, the MCPD is focused on a job role rather than on a single technology. The MCPD generally consists of one to three exams, in addition to obtaining an MCTS-level certification.

How Do You Become Certified on Microsoft SharePoint 2010?

In the past, students have been able to acquire detailed exam information—even most of the exam questions—from online “brain dumps” and third-party “cram” books or software products. For that matter, many candidates who were “good students” and able to pass tests by memorizing information from textbooks passed Microsoft certification exams while having little or no practical experience in managing Windows systems. They sadly gave birth to the phrase paper MCSE. Those days are gone forever.

Microsoft has taken strong steps to protect the security and integrity of its new certification tracks. Now prospective candidates must complete a course of study that develops detailed knowledge about a wide range of topics. It supplies them with the true skills needed, derived from working with the technology being tested. Although no test maps to a set of skills with 100 percent fidelity, Microsoft is working to make its exam content and format measure, as closely as computer-administered exams can, the true abilities of the people taking the exams.

To that end, the new generation of Microsoft certification programs is heavily weighted toward hands-on skills and experience. It is recommended that candidates have troubleshooting skills acquired through hands-on experience and working knowledge.

Fortunately, if you are willing to dedicate the time and effort to learn the Microsoft technologies you want to master, you can prepare yourself well for the exams by using the proper tools. By working through this book, you can successfully meet the exam requirements to pass the SharePoint configuration exam.

This book is part of a complete series of Microsoft certification study guides, published by Sybex, that together cover the new certifications, as well as the core MCSA and MCSE operating system requirements. Please visit the Sybex website at www.sybex.com for complete program and product details.

MCTS Exam Requirements

Candidates for MCTS certification on Microsoft SharePoint 2010 for configuring must pass just a single exam. Other MCTS certifications may require up to three exams. For a more detailed description of the Microsoft certification programs, including a list of all the exams, visit the Microsoft Learning website at www.microsoft.com/learning/mcpexams/default.mspx.

The Microsoft SharePoint 2010, Configuring Exam

The Microsoft SharePoint 2010, Configuring exam covers concepts and skills related to installing, configuring, and managing SharePoint server farms, site collections, and interoperations with other Microsoft technologies. It emphasizes the following elements of design and administration:

• Configuring Microsoft SharePoint Server 2010 Portal
• Managing search
• Configuring content management
• Configuring business forms
• Managing business intelligence
• Managing administration
• Deploying and upgrading Microsoft SharePoint Server 2010

This exam is quite specific regarding SharePoint Server 2010 requirements and operational settings, and it can be particular about how administrative and configuration tasks are performed within SharePoint. It also focuses on fundamental concepts of SharePoint’s operation and its interoperability with other Microsoft Office suite products, particularly other Office 2010 applications as well as other external resources.

Types of Exam Questions

In an effort to both refine the testing process and protect the quality of its certifications, Microsoft has focused its current certification exams on real experience and hands-on proficiency. There is a greater emphasis on your past working environments and responsibilities and less emphasis on how well you can memorize. In fact, Microsoft says that certification candidates should have hands-on experience before attempting to pass any certification exams.

Exam questions may be in a variety of formats: depending on which exam you take,you’ll see multiple-choice questions, select-and-place questions, and prioritize-a-list questions. Simulations and case study–based formats are included as well. You may also find yourself taking what’s called an adaptive format exam. Let’s take a look at the types of exam questions and examine the adaptive testing technique so you’ll be prepared for all the possibilities.

Multiple-Choice Questions

Multiple-choice questions come in two main forms. One is a straightforward question followed by several possible answers, of which one or more is correct. The other type of multiple-choice question is more complex and based on a specific scenario. The scenario may focus on several areas or objectives.

Select-and-Place Questions

Select-and-place exam questions involve graphical elements that you must manipulate to successfully answer the question. For example, you might see a diagram of a computer network. A typical diagram will show computers and other components next to boxes that contain the text Place here. The labels for the boxes represent various computer roles on a network, such as a print server and a file server. Based on information given for each computer, you are asked to select each label and place it in the correct box. You need to place all the labels correctly. No credit is given for the question if you correctly label only some of the boxes.

In another select-and-place problem, you might be asked to put a series of steps in order by dragging items from boxes on the left to boxes on the right and placing them in the correct order. One other type requires that you drag an item from the left and place it under an item in a column on the right.

Simulations

Simulations are the kinds of questions that most closely represent actual situations and test the skills you use while working with Microsoft software interfaces. These exam questions include a mock interface on which you are asked to perform certain actions according to a given scenario.

Because of the number of possible errors that can be made on simulations, be sure to consider the following recommendations from Microsoft:

• Do not change any simulation settings that don’t pertain to the solution directly.
• When related information has not been provided, assume that the default settings are used.
• Make sure your entries are spelled correctly.
• Close all the simulation application windows after completing the set of tasks in the simulation.

The best way to prepare for simulation questions is to spend time working with the graphical interface of the product on which you will be tested.

Case Study–Based Questions

Case study–based questions first appeared in the MCSD program. These questions present a scenario with a range of requirements. Based on the information provided, you answer a series of multiple-choice and select-and-place questions. The interface for case study–based questions has a number of tabs, each of which contains information about the scenario. Currently, this type of question appears only in most of the Design exams.

Tips for Taking the SharePoint 2010 Configuration Exam

Here are some general tips for achieving success on your certification exam:

• Arrive early at the exam center so that you can relax and review your study materials. During this final review, you can look over tables and lists of exam-related information.
• Read the questions carefully. Don’t be tempted to jump to an early conclusion. Make sure you know exactly what the question is asking.
• Answer all questions. If you are unsure about a question, then mark the question for review, and return to the question at a later time.
• On simulations, do not change settings that are not directly related to the question. Also, assume default settings if the question does not specify or imply which settings are used.
• For questions you’re not sure about, use a process of elimination to get rid of the obviously incorrect answers first. Often there are one or two you can dismiss immediately, assuming you know the subject for which you are being tested. This improves your odds of selecting the correct answer when you need to make an educated guess.

Exam Registration

You can take the Microsoft exams at any of more than 1,000 Authorized Prometric Testing Centers (APTCs). To locate a Prometric center near you, go to www.prometric.com. Outside the United States and Canada, contact your local Prometric.

Find out the number of the exam you want to take, and then register with the Prometric center nearest to you. At this point, you will be asked for advance payment for the exam. The exams are $125 each, and you must take them within one year of payment. You can schedule exams up to six weeks in advance or as late as one working day prior to the date of the exam. (The latter is generally but not universally true, so don’t count on it.) You can cancel or reschedule your exam if you contact the center at least two working days prior to the exam. Same-day registration is available in some locations, subject to space availability. Where same-day registration is available, you must register a minimum of two hours before test time.

When you schedule the exam, you will be provided with instructions regarding appointment and cancellation procedures, ID requirements, and information about the testing center location. In addition, you will receive a registration and payment confirmation letter from Prometric.

Microsoft requires certification candidates to accept the terms of a nondisclosure agreement before taking certification exams.

Who Should Read This Book

I suppose it goes without saying that the primary audience of this book is anyone who intends on taking the Microsoft 70-667 certification exam: Microsoft SharePoint 2010, Configuration. Of course, this could include people from several different backgrounds and could include people who aren’t actually planning on taking the test:

• People who are currently administering Microsoft Office SharePoint Server 2007 (MOSS 2007) for an organization that is planning or at least considering upgrading to Microsoft SharePoint Server 2010 should read this book, not only with the idea of becoming certified but also to learn about the many differences between the 2007 and 2010 versions of this application.
• People who are currently administering SharePoint Server 2010 but who either think they need to know more or want to solidify their qualifications in managing this technology by earning the 70-667 certification should read this book.
• People who are interested in information and content management, multiteam collaboration in an enterprise environment, and large-scale project organization and tracking managed using a multipurpose, web browser–based interface and think SharePoint may be the answer to their dreams or at least their questions should read this book.

Installing, configuring, and managing a SharePoint Server 2010 environment aren’t easy tasks. In fact, despite that I have worked as an experienced SharePoint site administrator and I use words for a living, I have difficulty describing exactly what SharePoint Server 2010 is and what it does. I suppose that’s because the range of activities and purposes served by SharePoint is really that vast and that varied. For that reason, if you are involved in administering SharePoint 2010, expect to be in the near future, or aspire to those roles, it’s important to have resources that pull together all of the vital sources of information and organize them in a way that makes them accessible and easier to assimilate.

Although there are a number of fine books on the market on SharePoint Server 2010 administration and development, none specifically addresses SharePoint from the point of view of the 70-667 exam. That makes the focus of this book unique. If you plan to take this certification exam, no other book will present the required information to you in the way you need it mapped out. Other books might contain some or all of the required subject matter, but they will make you work quite a bit harder to cull the gems you’re looking for as you’re studying. Here, the gems are gathered together in one place, so all you have to do is open the book.

Like most people who work in a technical field, I tend to think and write in an organized and linear manner. Each chapter in this book builds on the last, so skipping around in the book won’t be very helpful, at least not until you’ve gone through it at least once from cover to cover. Alternately, you can skip around from chapter to chapter and follow only the steps of the individual chapters.

What’s in the Book?

What makes a Sybex study guide the book of choice for hundreds of thousands of MCPs? We take into account not only what you need to know to pass the exam but also what you need to know to take what you’ve learned and apply it in the real world. Each book contains the following:

Objective-by-Objective Coverage of the Topics You Need to Know Each chapter lists the objectives covered in that chapter.

Assessment Test Directly following this introduction is an assessment test that you should take. It is designed to help you determine how much you already know about SharePoint Server 2010. Each question is tied to a topic discussed in the book. Using the results of the assessment test, you can figure out the areas where you need to focus your study. Of course, we do recommend you read the entire book.

Exam Essentials To highlight what you learn, you’ll find a list of exam essentials at the end of each chapter. The “Exam Essentials” section briefly highlights the topics that need your particular attention as you prepare for the exam.

Glossary Throughout each chapter, you will be introduced to important terms and concepts that you will need to know for the exam. At the end of the book, a detailed glossary defines these terms, as well as other general terms you should know.

Review Questions, Complete with Detailed Explanations Each chapter is followed by a set of review questions that test what you learned in the chapter. The questions are written with the exam in mind, meaning they are designed to have the same look and feel as what you’ll see on the exam. Question types are multiple choice. You’ll find other question types such as exhibits and select-and-place on the actual exam.

Hands-on Exercises In each chapter, you’ll find exercises designed to give you the important hands-on experience that is critical for your exam preparation. The exercises support the topics of the chapter, and they walk you through the steps necessary to perform a particular function.

Real-World Scenarios Because reading a book isn’t enough for you to learn how to apply these topics in your everyday duties, we have provided real-world scenarios in special sidebars. These explain when and why a particular solution would make sense in a working environment you’d actually encounter.

Interactive CD Every Sybex study guide comes with a CD complete with additional questions, flashcards for use with an interactive device, a Windows simulation program, and the book in electronic format. Details are in the following section.

What’s on the CD?

With this new member of our best-selling Study Guide series, we are including quite an array of training resources. The CD offers numerous simulations, bonus exams, and flashcards to help you study for the exam. We have also included the complete contents of the study guide in electronic form. The CD’s resources are described here:

The Sybex E-book for MCTS: Microsoft SharePoint 2010 Configuration Study Guide (70-667) Many people like the convenience of being able to carry their whole study guide on a CD. They also like being able to search the text via computer to find specific information quickly and easily. For these reasons, the entire contents of this study guide are supplied on the CD in PDF. We’ve also included Adobe Acrobat Reader, which provides the interface for the PDF contents as well as the search capabilities.

The Sybex Test Engine This is a collection of multiple-choice questions that will help you prepare for your exam. There are four sets of questions:

• Two bonus exams designed to simulate the actual live exam.
• All the questions from the study guide, presented in a test engine for your review. You can review questions by chapter or by objective, or you can take a random test.
• The assessment test.

Sybex Flashcards The flashcard-style of question offers an effective way to quickly and efficiently test your understanding of the fundamental concepts covered in the exam. The Sybex flashcards set consists of approximately 100 questions presented in a special engine developed specifically for this study guide series.

Contacts and Resources

To find out more about Microsoft Education and Certification materials and programs, to register with Prometric, or to obtain other useful certification information and additional study resources, check the following resources:

Microsoft Learning Home Page

www.microsoft.com/learning

This website provides information about the MCP program and exams. You can also order the latest Microsoft Roadmap to Education and Certification.

Microsoft TechNet Technical Information Network

www.microsoft.com/technet

800-344-2121

Use this website or phone number to contact support professionals and system administrators. Outside the United States and Canada, contact your local Microsoft subsidiary for information.

Prometric

www.prometric.com

800-755-3936

Contact Prometric to register to take an MCP exam at any of more than 800 Prometric Testing Centers around the world.

What Else You Will Need

You will need to practice using SharePoint Server 2010 for Internet Sites, Enterprise. Fortunately, you can download a trial version of this product that will allow you to use it free for 180 days. You will need to run SharePoint Server 2010 on either 64-bit Windows Server 2008 or 64-bit Windows Server 2008 R2 on 64-bit computer hardware. There are no versions of SharePoint 2010 that support 32-bit software or hardware. Although not absolutely necessary, it will be extremely helpful for you to have access to the Microsoft Office 2010 suite. Here is where you’ll need to go to download the various software packages:

Windows Server 2008 R2 Trial Version

www.microsoft.com/windowsserver2008/en/us/trial-software.aspx

SharePoint Server 2010 Trial Version

http://technet.microsoft.com/en-us/evalcenter/ee388573.aspx

Microsoft Office 2010

http://office.microsoft.com/en-us/try/

Hardware and Software Requirements

You should verify that your computer meets the minimum requirements for installing the required software packages. Each download site contains the relevant information you’ll need. In addition, Chapter 2, “Planning and Deploying a SharePoint 2010 Installation and Upgrade,” contains detailed information about the hardware and software requirements, so it is highly recommended that you carefully review this entire chapter before installing the required software packages onto your computer.

The exercises in Chapter 2 will also guide you through the step-by-step process of installing SharePoint Server 2010 as a stand-alone server deployment. SharePoint can be deployed on a single server computer or on a server farm in a datacenter. Although the book’s content includes material relevant to managing SharePoint in a server farm environment, it’s unlikely you’ll have a datacenter tucked away in a back closet of your house or apartment, so the practical focus of installing and setting up SharePoint addresses using a single computer.

This book was written using the trial versions of SharePoint Server 2010, Windows Server 2008 R2, and Office 2010 installed on a virtual machine in VMware Workstation 7 on a Windows 7 Professional 64-bit host computer. I also ran a virtual domain controller on Windows Server 2008 R2 and a virtual client Windows 7 machine.

The virtual machine was configured to use the following settings:

• Memory: 512 MB
• Hard disk: (SCSI 0:0) 40 GB (though I never used more than 7 GB of hard drive space)
• Virtual processors: 1
• Ethernet: Bridged
• USB controller: Present

As you can see, I set the resources to be rather modest, and during the writing of this book, I primarily had only the single virtual machine running. The virtual network was bridged to my home LAN so that SharePoint could have access to multiple virtual and actual host computers and to the Internet. The host Windows 7 Professional computer’s resources at the time of this writing were as follows:

• Memory: 12 GB
• Two hard disks: (IDE) 75 GB for the OS and (IDE) 300 GB for the virtual environment and storage
• Processor: Dual-core Intel Xeon CPU 2.60 GHz

If you have the resources to afford a more powerful computer on which to run SharePoint 2010, I recommend it, particularly if you plan on also using a more extensive virtual network than the one I employed.

How to Contact the Author

You never write a book alone. Sure, I’m the only author of this text, but there is a team of people who don’t have their names on the cover who worked hard to make sure the book in your hands is the best it possibly can be. Every editor involved has taken a great deal of time and energy and provided me with invaluable feedback about how I could make the book better. That said, the one resource I don’t have access to while writing is the reader. I can know what you think only after the book is available on the bookstore shelves and online.

I’d still like to hear what you think (be nice), and I do read and respond to my emails. You can reach me by writing to [email protected], and you can learn more about my work on my website at www.wiredwriter.net.

As I mentioned, the folks at Sybex work hard to keep you supplied with the latest tools and information you need for your work. Please check the website at www.sybex.com, where we’ll post additional content and updates that supplement this book if the need arises. Enter MCTS: Microsoft SharePoint 2010 Configuration Study Guide in the Search box (or type the book’s ISBN, which is 9780470627013), and click Go to reach the book’s updates page.

Remember, studying for this exam is something you want to do, and you are learning about a subject you are really interested in. With that in mind, don’t make it all work. Have fun. Play with the technology. See how far you can take the exercises, modify them, try different combinations of settings, and figure out all the different ways that SharePoint works and what it does. Really get to know it inside and out as you are working through the chapters, and by the time you schedule and take the exam, you’ll be ready. Good luck.

Assessment Test

1. You are a SharePoint administrator of a Microsoft Office SharePoint Server 2007 (MOSS 2007) environment, and you have been tasked by your CIO to investigate the feasibility of upgrading to SharePoint 2010. As part of your feasibility study, you are exploring new and upgraded features of the SharePoint platform. What do you discover? (Choose all that apply.)

A. Remote BLOB Storage is used for server farms to provide high storage capacity by allowing BLOB customized pages stored on Windows Server 2008 and Windows Server 2008 R2 to be housed in a separate file system outside the Windows Server system.

B. SharePoint Server 2010 comes equipped with a large number of diagnostic and performance monitoring tools, including Developer dashboard and Usage database.

C. Windows PowerShell Administration v2.0 is currently available for use as the de facto command-line interface and scripting language in SharePoint Server 2010.

D. List controls can be used to manage the number of queries sent to lists to improve performance, particularly lists containing a large number of items.

2. You are a SharePoint administrator of a Microsoft Office SharePoint Server 2007 (MOSS 2007) environment, and you have been tasked by your CIO to investigate the feasibility of upgrading to SharePoint 2010. As part of your feasibility study, you are exploring new and upgraded features of the SharePoint platform. What do you discover? (Choose all that apply.)

A. Backup and restore functions in SharePoint Server 2010 have been completely transferred to Windows PowerShell to allow new granularity in the process.

B. In Excel Services, the new unattended service account allows one-time access to Excel Services data to low-security users.

C. Enterprise search now exclusively uses FAST Search to accelerate search functions in large, enterprise environments.

D. Trusted locations are provided by default in SharePoint Server 2010.

3. Which of the following are valid service applications in SharePoint Server 2010? (Choose all that apply.)

A. Access Services

B. Business Community Services (BCS)

C. Excel Services

D. Visio Services

4. What are some of the factors that determine whether you deploy SharePoint Server 2010 on a single farm or on multiple farms? (Choose all that apply.)

A. The requirement to use the Visual Upgrade feature

B. The need for multiple dedicated services farms to satisfy use requirements

C. Funding that is dedicated for special purposes requiring more than one farm

D. Using multiple server farms to enhance performance

5. If you plan to use the SharePoint Directory Management Services and Active Directory as part of an advanced incoming email feature setup, one required task is to create an organizational unit (OU) and delegate create, delete, and manage user accounts to Central Administration. Of the following options, which are generally true about this task? (Choose all that apply.)

A. You will need to work on a computer that is a domain controller.

B. You will need to start the task in the DNS Manager.

C. You can use Directory Management Services on either a server farm or a remote server farm.

D. You will finish the task in the Delegation of Control Wizard.

6. You are the SharePoint administrator for your organization, and you are about to perform post-installation tasks for your server farm. You are describing how to set up usage data collection to your staff as part of that process. Of the following, what is true about configuring usage data collection? (Choose all that apply.)

A. You can configure usage data collection for a single event type using WindowsPowerShell.

B. You can change the database used by usage data collection using Windows PowerShell.

C. You must be a member of the Farm Administrators group to configure usage datacollection using Windows PowerShell.

D. You must be a member of the SQL Server Administrators group to configure usage data collection using Windows PowerShell.

7. You are the SharePoint administrator for your organization, and you’ve been tasked with configuring your local SharePoint server farm environment to be able to consume application resources on other server farms within the organization managed by other administrators. To do this, you must perform various tasks to allow trust certificates to be exchanged between server farms. Of the following options, what is true about these tasks?

A. You can use either Central Administration or Windows PowerShell to perform the related tasks.

B. You can only use Central Administration to perform the related tasks.

C. You can only use Windows PowerShell to perform the related tasks.

D. You must perform separate tasks in both Central Administration and WindowsPowerShell.

8. There are a wide variety of tasks that you must perform as a SharePoint administrator, using Windows PowerShell when configuring service applications, yet for each of these PowerShell-related activities, you require the same set of credentials. Of the following, which are the required credentials? (Choose all that apply.)

A. You must be a member of the SharePoint_Shell_Access group.

B. You must be a member of the SharePoint Farm Administrators group.

C. You must be a member of the WSS_ADMIN_WPG local group on the computercontaining SharePoint 2010.

D. You must be a member of the processadmin group for the SQL Server databasecontaining the application service data.

9. You are a SharePoint administrator for your organization, and you are currently deploying enterprise search in SharePoint. You have created a search service application and have performed your first full crawl of the configured content sources, but the crawl hasn’t functioned they way you had hoped. On the Search Administration page for the selected Search service application, you open the Administration Reports page and start reviewing the various documents present. On any specific document, what actions can you perform? (Choose all that apply.)

A. You can filter the results by date range, with 12 hours being the default range.

B. You can filter the results by application type.

C. You can filter the results by search service application.

D. You can filter the results by content source.

10. You are a SharePoint administrator for your organization, and you have recently deployed enterprise search in SharePoint. You have been tasked by the CIO with gathering statistics on websites searched by SharePoint users. You visit the Web Analytics page in Search Administration for the default Search service application. On this page, what reports can you view? (Choose all that apply.)

A. Top Browsers

B. Top Destinations

C. Top Queries

D. Top Visitors

11. You are a SharePoint administrator for your company, and you need to add a content database to a SQL Server instance in order to move a site collection that is running out of room on its current database to a new database. You know you have more than one option to use to create the new content database. Of the following, which are valid options? (Choose all that apply.)

A. Central Administration

B. Windows PowerShell

C. SQL Server Management Studio

D. The Stsadm.exe command-line tool

12. You are a SharePoint administrator for your company, and you need to add a content database to a SQL Server instance in order to move a site collection that is running out of room on its current database to a new database. You know you have more than one type of authentication method that can be configured when connecting to the SQL service when creating the database. Of the following, which are valid authentication options? (Choose all that apply.)

A. Basic authentication

B. SQL authentication

C. Trusted authentication

D. Windows authentication

13. You are a SharePoint administrator for your organization. You are discussing the procedures for creating and configuring a User Profile service application with your staff. You are presenting the general characteristics of the application. Of the following choices, which ones are personalization settings that can be managed in this application? (Choose all that apply.)

A. Audiences

B. Defining Managed Paths

C. My Site settings

D. Profile synchronization settings

14. You are a SharePoint administrator for your organization. You are discussing the procedures for creating and configuring a User Profile service application with your staff. You are discussing circumstances that may inhibit the creation and use of a User Profile service application. Of the following options, which must be present in order for you to create the application? (Choose all that apply.)

A. You must be running the Standard or Enterprise version of SharePoint Server 2010 in a full server farm.

B. At least one managed path must exist.

C. You must have an application pool that is used by My Sites.

D. You must be running an instance of Managed Metadata Services.

15. You are a SharePoint administrator for your organization. You have just upgraded your MOSS 2007 environment to SharePoint Server 2010. Now you need to upgrade the authentication systems on your web applications to claims-based authentication from the MOSS 2007 web application default authentication. What default authentication system does MOSS 2007 use?

A. Active Directory Federation Services

B. Forms-based

C. Secure Store Service

D. Windows Challenge/Response NTLM

16. You are a SharePoint administrator for your organization. You have just upgraded your MOSS 2007 environment to SharePoint Server 2010. Now you need to upgrade the authentication systems on your web applications to claims-based authentication from the MOSS 2007 web application default authentication. What is the procedure to perform this task?

A. Open Central Administration and in Quick Launch click Security. Under General Security, click Specify Authentication Providers. On the subsequent page, update the authentication type to the one you want in SharePoint 2010.

B. Open Windows PowerShell as an administrator, type in a script that will perform the authentication upgrade, and then press Enter.

C. You must perform the authentication upgrade in MOSS 2007 before upgrading to SharePoint by selecting Upgrade, Authentication Providers, and then Upgrade to SharePoint 2010 default authentication.

D. You must perform the authentication upgrade during the upgrade from MOSS 2007 to SharePoint 2010 by selecting the Upgrade Authentication For Web Applications option in the upgrade wizard.

17. You are a SharePoint administrator for your company, and you are preparing to deploy business intelligence (BI) in your environment. You and your staff are doing a high-level review of the components that contribute to BI. Of the following, which services are used to provide data to BI dashboards? (Choose all that apply.)

A. Excel Services

B. Managed Metadata Services

C. PerformancePoint Services

D. Visio Graphics Services

18. You are a SharePoint administrator for your company, and you are preparing to deploy business intelligence (BI) in your environment. You are reviewing the requirements for installing and managing PerformancePoint Services in SharePoint. Of the following, which are valid prerequisite steps? (Choose all that apply.)

A. You will need to manually create the PerformancePoint Service application in Central Administration.

B. Once the PerformancePoint Service is created, you must start the service.

C. You must configure the unattended service account for PerformancePoint Services to allow access to Performance Point Services data sources.

D. PerformancePoint Site Collection Features must be turned on.

19. You are a SharePoint administrator for your company, and you have just been tasked with configuring content deployment settings for your environment. You have already configured the content deployment settings as well as paths, jobs, and Quick Deploy. Now you are interested in configuring job history and reports. Of the following, what do you find is true about configuring and running content deployment job histories and reports? (Choose all that apply.)

A. Every time a content deployment job runs, a report on the job status and details is generated and logged as a record for that job.

B. To view the status of the deployment of specific content, you must specify the location of the content by URL.

C. If a content deployment job has failed, you cannot open the Content Deployment Report page.

D. To view a job history or job report for a content deployment job, you must select the desired job and click View History for that job in the job’s menu.

20. You are a SharePoint administrator for your company, and you are in the process of enabling document converters on a web application in your environment. Document converters allow SharePoint users to convert one document format type to another either through a user interface or through an automated process such as a custom workflow. As you are going through the process of enabling document conversion, you are offered several conversion settings.Of the following, which are valid conversion settings? (Choose all that apply.)

A. From InfoPath Form to Web Page

B. From Word Document to Web Page

C. From Word Document to Macros

D. From XML to Web Page

21. You are a SharePoint administrator for your company, and you have been tasked with planning a sandbox solution for deployment. You are conducting a high-level review of SharePoint sandboxes, including the steps that must be performed by a farm administrator. Of the following, which steps are considered valid for preparing sandbox deployment? (Choose all that apply.)

A. The farm administrator must enable and start the sandboxing service on each server that will run the sandbox solution.

B. The farm administrator must activate and validate the sandbox solution.

C. The farm administrator must apply a load-balancing scheme to all sandbox solutions if load balancing is a requirement.

D. The farm administrator must set resource quotas that cannot be exceeded by all the combined site collections in the solution if resource quotas are a requirement.

22. You are a SharePoint administrator for your company, and you have been tasked with planning a sandbox solution for deployment. You are conducting a high-level review of SharePoint sandboxes, including sandbox isolation management and resources that an isolated sandbox environment is unable to access. Of the following, what are the resources an isolated sandbox cannot access? (Choose all that apply.)

A. Cannot access resources on a different site collection within the sandbox

B. Cannot access a database

C. Cannot access the manifest.xml file

D. Cannot access resources on the local server

23. You are a SharePoint administrator for your company, and you are planning the backup and recovery strategy for your server farm. You are developing your initial plan for the backup directory or folder where you will back up your server farm. What is the recommended procedure for backing up the farm to a folder?

A. Back up the farm to a folder on the local computer.

B. Back up the farm to a folder on the network.

C. Back up the farm to a folder on the local computer and then transfer the backup to a remote location on the network.

D. Back up the farm to a remote location on the network and then transfer the backup to a folder on the local computer.

24. You are a SharePoint administrator for your company, and you are planning the backup and recovery strategy for your server farm. You are developing your backup and recovery strategy. Backing up the entire farm regularly is a necessary task, but not all necessary elements are backed up during this process. Of the following, what is not backed up when you backup the farm? (Choose all that apply.)

A. Business Data Connectivity service external content definitions

B. Business Data Connectivity data sources

C. Binary Large Object stores when using the FILESTREAM store provider

D. Certificates required to establish trust relationships

25. You are a SharePoint administrator for your company, and you are currently managing the monitoring and analysis tools in SharePoint. You are currently configuring Diagnostic Logging using Windows PowerShell. Of the following, which PowerShell cmdlet should you use?

A. SPDiagLog

B. SPDiagnosticLog

C. SPLogLevel

D. SPLogSet

26. You are a SharePoint administrator for your company, and you are currently managing the monitoring and analysis tools in SharePoint. You are currently configuring Usage and Health Data Collection using Central Administration. Of the following, what is true about configuring this utility?

A. You can configure this data collection tool to apply to a web application, a single server, a collection of servers, or the server farm.

B. You can configure this data collection tool to apply to a single server, a collection of servers, or the server farm.

C. You can configure this data collection tool to apply to a group of three servers or more including the entire server farm.

D. You can configure this data collection tool to apply to the entire server farm only.

27. You are a SharePoint administrator for your organization, and you are in the process of optimizing SharePoint performance. You want to optimize BLOB cache settings by modifying a particular file for a web application. What is the name of this file?

A. blob.config

B. blob.cache

C. web.config

D. web.cache

28. You are a SharePoint administrator for your organization, and you are in the process of optimizing SharePoint performance. You want to optimize access to BLOB storage by configuring a disk-based BLOB cache. Of the following, what is the correct tool to useto accomplish this task?

A. Central Administration

B. The main page of the relevant site collection

C. Internet Information Services (IIS) Manager

D. Windows PowerShell

29. You are on the staff of a SharePoint administrator for your company, and you are learning Windows PowerShell basics as applied to the SharePoint environment. As part of your education, you have found out that there are three other main types of commands in PowerShell besides cmdlets. Of the following, what are those commands? (Choose three.)

A. Applications

B. Functions

C. Scripts

D. Variables

30. You are on the staff of a SharePoint administrator for your company, and you are learning Windows PowerShell basics as applied to the SharePoint environment. You are trying to learn cmdlet basics. At its most fundamental level, how is a cmdlet structured?

A. A cmdlet is a verb-noun pair such as Get-Fred or Set-Item.

B. A cmdlet is a noun-verb pair such as Fred-Get or Item-Set.

C. A cmdlet is a verb/noun pair such as Get/Fred or Set/Item.

D. A cmdlet is a noun/verb pair such as Fred/Get or Item/Set.

Answers to Assessment Test

1. B, C, D. For option A, Remote BLOB Storage is used for server farms to provide high storage capacity by allowing BLOBs from the all_docs table and customized pages in a database to be housed in a file system outside the SQL Server database, reducing the amount of storage required on the SQL Server itself. For more information, see Chapter 1, “What’s New in Microsoft SharePoint 2010.”

2. B, D. For option A, backup and restore can be performed either using the Central Administration website or using Windows PowerShell. For option C, FAST Search is an optional download, while enterprise search is available by default in SharePoint Server 2010. For more information, see Chapter 1, “What’s New in Microsoft SharePoint 2010.”

3. A, C, D. Business Community Services (BCS) is incorrect. The correct name is Business Connectivity Services (BCS). All other answers are valid services. For more information, see Chapter 2, “Planning and Deploying a SharePoint 2010 Installation and Upgrade.”

4. B, C, D. Option A is bogus because the use of Visual Upgrade has nothing to do with server farm planning. All other options are correct. See Chapter 2, “Installing and Deploying SharePoint 2007,” for more information.

5. A, C, D. You start the task in Active Directory Users and Computers, not the DNS Manager. See Chapter 3, “Configuring SharePoint Farm Environments,” for more information.

6. A, B. Options C and D are bogus. See Chapter 3, “Configuring SharePoint Farm Environments,” for more information.

7. C. The tasks related to importing and exporting trust certificates must be performed using Windows PowerShell. For more information, see Chapter 4, “Configuring Service Applications.”

8. A, C. Only membership in the SharePoint_Shell_Access and the WSS_ADMIN_WPG local groups is required to perform the application service configuration tasks in Windows PowerShell. For more information, see Chapter 4, “Configuring Service Applications.”

9. A, B, D. Since you are performing this action within a single search service application, you cannot filter the results based on other applications that exist outside of the one you are currently using. For more information, see Chapter 5, “Configuring Indexing and Search.”

10. A, B, D. There is no Top Queries option, but you can choose Number Of Queries and view that report. See Chapter 5, “Configuring Indexing and Search,” for more information.

11. A, B. You can either use Central Administration or use Windows PowerShell. Options C and D are not valid options. See Chapter 6, “Managing Operational Settings,” for more information.

12. B, D. The only options available for you to select for authentication types are SQL authentication and Windows authentication. See Chapter 6, “Managing Operational Settings,” for more information.

13. A, C, D. Defining managed paths is done in web application management, not in the User Profile service application. See Chapter 7, “Managing User Accounts and Roles,” for more information.

14. A, C, D. Although you must be running either the Standard or Enterprise version of SharePoint Server 2010, it does not have to be running in a full server farm. This is a requirement only when you perform other tasks such as profile synchronization. See Chapter 7, “Managing User Accounts and Roles,” for more information.

15. B. MOSS 2007 web applications were generally configured to use forms-based authentication or web SSO authentication. See Chapter 8, “Managing Authentication Providers,” for more information.

16. B. You must use Windows PowerShell to run a specific script after MOSS 2007 has been upgraded to SharePoint Server 2010. No other option is available. See Chapter 8, “Managing Authentication Providers,” for more information.

17. A, C, D. The services that primarily provide and manage BI information include Excel, PerformancePoint, and Visio. Managed Metadata Services is a hierarchical collection of managed terms that can be defined and then used as attributes for SharePoint items. See Chapter 9, “Managing Web Applications and Host Sites,” for more information.

18. B, C, D. The PerformancePoint service application can be created in Central Administration, but you can also use the Farm Configuration Wizard to create the service right after your initial SharePoint deployment is finished. See Chapter 9, “Managing Web Applications and Host Sites,” for more information.

19. A, B, D. If a content deployment job fails, you must click Failed in the Status column for the job to open the Content Deployment Report page. See Chapter 10, “Managing Site Collections,” for more information.

20. A, B, D. Instead of From Word Document to Macros, the answer should read From Word Document with Macros to Web Page in order to be correct. See Chapter 10, “Managing Site Collections,” for more information.

21. A, C, D. The site collection administrator can activate and validate the sandboxed solution as well as upload the solution to the site collection’s solution gallery. See Chapter 11, “Deploying and Managing SharePoint Solutions,” for more information.

22. A, B. The sandbox must be able to connect to the local server and access the manifest.xml file, which contains the configuration information defining the sandbox environment. For more information, see Chapter 11, “Deploying and Managing SharePoint Solutions.”

23. C. The recommended procedure is to first back up the farm to a folder on the local machine and then transfer the backup to a remote location on the network. For more information, see Chapter 12, “Backing Up and Restoring SharePoint.”

24. B, D. Although the SharePoint farm backup process backs up the Business Data Connectivity (BDC) service external content type definitions, it doesn’t back up the actual data source. Backing up the farm does not back up any certificates used to create trust relationships. SharePoint backs up the remote Binary Large Object stores, also called BLOB stores, only if you use the FILESTREAM remote BLOB store provider to move data in remote BLOB stores. For more information, see Chapter 12, “Backing Up and Restoring SharePoint.”

25. C. Use the SPLogLevel cmdlet and appropriate parameters to configure Diagnostic Logging in Windows PowerShell. The other cmdlets are bogus. For more information, see Chapter 13, “Monitoring the SharePoint Environment.”

26. D. Any Usage and Health Data Collection tool settings you make are applied to the entire farm and cannot specify a smaller group of servers. For more information, see Chapter 13, “Monitoring the SharePoint Environment.”

27. C. To configure the BLOB cache, you must locate and modify the web.config file in order to optimize access to BLOB storage for disk-based BLOB cache or a web application. For more information, see Chapter 14, “Optimizing SharePoint.”

28. C. Use the Internet Information Services (IIS) Manager to locate and access the necessary file to specify a directory for the cache. For more information, see Chapter 14, “Optimizing SharePoint.”

29. A, B, C. Valid PowerShell commands include applications, such as executables; functions, which are commands written in the PowerShell language; and scripts, which are text files with a .ps1 extension containing PowerShell commands. Although variables can be part of a function or a script, they are not commands. For more information, see Chapter 15, “Working with Windows PowerShell.”

30. A. A cmdlet is a verb-noun pair separated by a hyphen. In English, it might be expressed as Get-Fred or Bring-Donuts. For more information, see Chapter 15, “Working with Windows PowerShell.”