70-332: Core Solutions of Microsoft SharePoint Server 2013

1. 70-332: Core Solutions of Microsoft SharePoint Server 2013 Exam Cram Becky Bertram

2. Session Evaluations • Schedule and evaluate each session you attend via our mobile app that can be used across devices at http://spsaturday. azurewebsites.net • You will be able to evaluate sessions added to your “My Sessions” 25 minutes before the scheduled end time • Evaluations are stored anonymously and your feedback is appreciated • The app will be the only method available to submit session evaluations for the event and we hope you find it intuitive and convenient

3. Becky Bertram • Owner, Savvy Technical Solutions • Microsoft SharePoint Server MVP • Microsoft Certified Trainer • MCSD, MCPD, MCITP, MCTS,MCTA • Co-author of Wrox SharePoint Six-in-One • http://blog.beckybertram.com • @beckybertram

4. Certification Overview

5. Microsoft Next Gen Certification • Microsoft Certified Solutions Expert (MCSE) • You can’t be a “stand-alone” MCSE. • You’re in an MCSE in a specialty, such as • Server Infrastructure • Desktop Infrastructure • Private Cloud • Data Platform • Business Intelligence • Messaging • Commuication • SharePoint • For each MCSE, you must pass 3 core exams: • 70-410: Installing and Configuring Windows Server 2012 • 70-411: Administering Windows Server 2012 • 70-412: Configuring Advanced Windows Server 2012 Services

6. MCSE: SharePoint • To become a SharePoint MCSE, you must pass two additional exams: • 70-331: Core Solutions of Microsoft SharePoint Server 2013 • 70-332: Advanced Solutions of Microsoft SharePoint Server 2013 • If you are already an MCITP for SharePoint, you can pass exam 70-417: Upgrading Your Skills to MCSA Windows Server 2012 • This exam covers the topics of the three core MCSE exams. • You’ll still need to pass the additional SharePoint 2013 exams to earn your MCSE: SharePoint. • You must be an existing MCITP to be eligible to take this exam.

7. It’s Tough! • Previously, the exams covered SharePoint-specific infrastructure questions. The exams didn’t cover basic server farm infrastructure topics such as DHCP, DNS, firewalls, Active Directory, OS settings, etc. • The Microsoft Certified Master certification was introduced with the last product cycle. Becoming a Master is HARD! You’re expected to know anything related to basic server infrastructure that could affect your SharePoint farm. • Since the last SharePoint exams didn’t cover these details, people coming into the MCM program felt unprepared. • The current exam objectives were written by current SharePoint MCMS (yes, the smartest folks in our field!) • The resulting exam covers many topics not necessarily directly related to SharePoint, but that could affect the performance of your SharePoint farm.

8. Taking the Exam

9. Register with Prometric • You must register for your exams through Prometric. • You can register online at www.prometric.com or you can call their customer service line. • Choose a testing center and an exam time. • Not all exams are available in every location. • “Second Shot” means you can retake the exam for free.

10. Interactive Exam The new SharePoint 2013 exams are more interactive than before. Not just multiple choice. More thoroughly tests your knowledge but can be a little intimidating because it feels like there are more opportunities for wrong answers. • Drag and drop servers into a server configuration • Drag and drop words into a fill-in-the-blank sentence • Arrange items in their correct order

11. Tips for Choosing Answers • For some exams, there will be right answers and wrong answers. • For other exams, all the answers will be right, but not in the circumstance described in the question. If more than one answer seems right, read the question closely. The answer usually lies in the question.

12. Read the Objectives The exam writing process goes like this: Your best (and free) way of studying is to read up on each objective. The exam questions are written directly from them! Objectives Exam Questions Courseware MS Learning Exam Cram Books

13. Study Materials Exam study guide at http://blog.beckybertram.com/Lists/Exam%2070332%20Study%20Guide/AllItems.aspx Exam Ref 70-331: Advanced Solutions of Microsoft SharePoint Server 2013 http://shop.oreilly.com/product/0790145377098.do Out in May

14. Plan Business Continuity Management

15. Plan for SQL high availability and disaster recovery This objective may include but is not limited to: • Plan for SQL Server mirroring • Plan for SQL Server clustering • Plan for SQL Server AlwaysOn • Plan for SQL Server Log Shipping • Plan for storage redundancy • Plan for login replication

16. SQL Server AlwaysOn The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to four sets of corresponding secondary databases. Optionally, secondary databases can be made available for read-only access and/or some backup operations.

17. AlwaysOn and SharePoint • Select or create a Windows Server failover cluster. • Install SQL Server 2012 on each cluster node. • Create and configure an availability group. • Install and configure SharePoint 2013. • Add the SharePoint databases to the availability group. • Test failover for the availability group.

18. Plan SharePoint High Availability This objective may include but is not limited to: • Plan for service distribution • Plan for service instance configuration • Plan for physical server distribution • Plan for network redundancy • Plan for server load balancing • Plan for SQL Server aliases

19. Plan Backup and Restore This objective may include but is not limited to: • Establish a SharePoint backup schedule • Establish a SQL Server backup schedule • Plan a non-production environment content refresh • Plan for farm configuration recovery • Plan for service application recovery • Plan for content recovery

20. Plan a SharePoint Environment

21. Plan a Social Workload This objective may include but is not limited to: • Plan for My Sites • Plan social permissions • Plan user profiles • Plan activity feeds • Plan connections

22. Plan and Configure a Search Workload This objective may include but is not limited to: • Plan and configure search result relevancy • Plan and configure index freshness • Plan and configure result sources • Plan and configure the end-user experience • Plan and configure a search schema • Analyze search analytics reports

23. Plan and Configure a Web Content Management (WCM) Workload This objective may include but is not limited to: • Plan and configure channels • Plan and configure product catalog and topic pages • Plan and configure Design Manager • Plan and configure content deployment • Plan and configure display templates • Plan and configure variations

24. Device Channels • Allows you to create a “channel” targeted to a particular mobile device, then assign a custom master page to it • To create a new channel, go to SharePoint Design Manager  Manage Device Channels. Add a new channel with its name and inclusion rules.

25. Product Catalog Pages • Way of creating a single page that displays content from multiple list items (much like Page Layouts worked previously). But instead of creating different pages with different URLs, the URLs are dynamically created and rules determine what shows up on the page. • To set up product catalog pages: • Make sure Cross-Site Collection Publishing feature is enabled • In the list settings for your catalog list, go to Catalog Settings page and check “Enable this library as a catalog”. Choose a field (or fields) that serve as a unique ID. Select the column in the list that’s bound to the term set used in your managed navigation.

26. Display Templates • Used to “skin” a Content Search Web Part (replacement for the Content Query Web Part) • You can set which Display Template to use in the CSWP. • You can create new Display Templates in SharePoint Design Manager.

27. Plan an Enterprise Content Management (ECM) Workload This objective may include but is not limited to: • Plan and configure eDiscovery • Plan and configure document routing • Plan and configure co-authoring • Plan and configure record disposition and retention • Plan large document repositories • Plan and configure software boundaries

28. eDiscovery • eDiscovery is how records managers and litigators discover content in electronic format. Typically, eDiscovery requires searching for documents, websites, and email messages spread across laptops, email servers, file servers, and other sources, and collecting and acting on content that meets the criteria for a legal case. • eDiscovery uses search service applications (SSAs) to crawl SharePoint farms. The most common configuration is to have a central search services farm that crawls multiple SharePoint farms. You can use this one search service to crawl all SharePoint content, or you can use it to crawl specific regions—for example, all SharePoint content in Europe. • To crawl a SharePoint farm, search first uses a service application proxy to connect to it. The eDiscovery Center uses the proxy connection to send preservations to SharePoint sites in other SharePoint farms.

29. Holds • SharePoint preserves content on the site level. When you preserve a site, its lists, libraries, and subsites are preserved. • If you preserve a root site collection, all documents, pages, lists, and subsites in that site collection are preserved. • To hold a site, create a Discovery Case in the eDiscovery Center. A case is a container for all of the queries, content, and preservations associated with specific litigation. After you create the case, create a Discovery Set to specify the site. • In-Place Hold works by retaining content where it lives at the time the discovery search is completed. When content items are edited or deleted, eDiscovery places a copy of the item in a specific document library, called the Preservation Hold Library, on the SharePoint site where the content was modified. • Only the search indexer and users with site collection admin permission or web app permission can access the Preservation Hold Library. Most users without these permissions do not see the library and do not know it exists or that the content is copied there.

30. Upgrade and Migrate a SharePoint Environment

31. Evaluate Content and Customizations This objective may include but is not limited to: • Perform migration pre-check tasks • Analyze content database test results • Configure web application authentication for upgrade • Resolve orphan objects • Resolve missing file system components • Resolve configuration conflict issues

32. Plan an Upgrade Process This objective may include but is not limited to: • Plan removal of servers in rotation • Configure a parallel upgrade • Configure read-only access for content • Configure upgrade farms • Measure upgrade performance • Plan an installation sequence

33. Upgrade Site Collection This objective may include but is not limited to: • Perform a health check • Analyze and resolve health check results • Plan and configure available site collection modes • Plan and configure site collection upgrade availability • Plan and configure EVAL mode • Plan and configure site collection upgrade throttling

34. Upgrade Evaluation Site Collection • Site collection administrators can request a preview of their site collection, called an upgrade evaluation site collection. It enables site collection administrators to see their site’s content in a new, separate copy of the site that is running on the SharePoint 2013. Unlike visual upgrade in SharePoint Server 2010, the upgrade evaluation site collection is a complete copy of the site collection. It is separate from the original and has its own URL. Actions that the site collection administrators perform in the upgrade evaluation site collection do not affect the original site. • Both the original site and the upgrade evaluation site are available for search • Timer jobs that run for all site collections also run on the upgrade evaluation sites

35. Site Collection Upgrade Throttling To make sure that site collection upgrades do not cause an outage on your farm, there are throttles built in at the web application, database, and content level. This means that even if 100 site collection administrators decide to upgrade their site collections at the same time, only some are run at the same time, and the rest are put into a queue to run later

36. Create and Configure Service Applications

37. Create and Configure App Management This objective may include but is not limited to: • Create and configure the App Store • Create and configure subscriptions • Configure marketplace connections • Configure DNS entries • Configure wildcard certificates

38. App DNS Configuration • You must configure a new name in DNS to host the apps. The domain name should not be a subdomain of the domain that hosts the SharePoint sites. For example, if the SharePoint sites are at Contoso.com, consider ContosoApps.com instead of App.Contoso.com as the domain name. When an app is provisioned, it provisions a unique DNS domain name (for example, Apps-12345678ABCDEF.ContosoApps.com, where 12345678ABCDEF is a unique identifier for the app). You need a wildcard Canonical Name (CNAME) entry for your DNS domain to support these unique names. • Depending on your configuration you might have to create a new forward lookup zone first, or you can start with a wildcard CNAME entry in the same zone as the SharePoint site domain • If you are using Secure Sockets Layer (SSL) for the SharePoint sites in your environment, or if you use any apps that use data external to the SharePoint sites, you should use SSL for your apps. To use SSL, you create an SSL certificate for your app domain (for example, ContosoApps.com). The domain should be added in the form of a wildcard (for example, *.ContosoApps.com). You need a wildcard certificate instead of individual certificates because each installed app has its own subdomain.

39. Create and Configure Productivity Services This objective may include but is not limited to: • Create and configure Microsoft Excel Services, Microsoft Access services, Microsoft Visio services, Microsoft Word Automation services, Microsoft PowerPoint Conversion services, and Translation Services

40. Configure Service Application Federation This objective may include but is not limited to: • Plan services to federate • Perform a certificate exchange • Manage trusts • Manage service application permissions • Publish service applications • Consume service applications

41. Create and Configure a Business Connectivity Service (BCS) and Secure Store Application This objective may include but is not limited to: • Import and configure BCS models • Configure BCS model security • Configure BCS for search • Generate a Secure Store master key • Manage Secure Store target application permissions • Create Secure Store target applications

42. Manage SharePoint Solutions, BI, and Systems Integration

43. Manage SharePoint Solutions and Applications This objective may include but is not limited to: • Manage sandbox solution quotas • Configure sandbox solution management • Deploy farm solutions • Upgrade farm solutions • Deploy Apps • Upgrade Apps

44. Upgrade Apps • Update is deployed the same way that the first version of the app is deployed. The update process ensures that the app's data is preserved if the update fails for any reason. • For an update, you use the same product ID in the app manifest that you used for the original version. The version number in the app manifest should be greater than the version number of the original app or the most recent update. • After you deploy your update to the public SharePoint app store or an organization's app catalog, an indication that an update is available appears next to the app's listing on the Site Contents page of every website where it is installed. Users can click a link to update the app. • If the update fails, a complete rollback occurs.

45. Plan and Configure a BI Infrastructure This objective may include but is not limited to: • Plan and configure Performance Point • Plan and configure Reporting Services • Plan and configure PowerPivot • Plan and configure Excel Services • Plan and configure PowerView • Plan and configure BI security

46. Create and Configure Work Management This objective may include but is not limited to: • Configure a connection to Exchange • Configure a connection to Microsoft Project Server • Manage trusts • Plan Exchange configuration for eDiscovery

47. Connection to Exchange • Configure server-to-server authentication for Exchange 2013 on a server running SharePoint Server 2013 (PowerShell) • Run a command to create Exchange 2013 as a trusted security token issuer in SharePoint 2013 • Run commands to grant the Exchange service principal full control permissions to SharePoint site subscription. • Configure server-to-server authentication for SharePoint 2013 on a server running Exchange 2013 (cmd) • Runa command to configure the SharePoint partner application. • Add users who need to perform an eDiscovery search using SharePoint 2013 to the Discovery Management role group in Exchange 2013

48. Questions

49. Housekeeping • Follow SharePoint Saturday St. Louis on Twitter @spsstlouisand hashtag #spsstl • Play “Sponsor Bingo” to register for your chance to win one of the many great giveaways at the end of the day • Schedule and evaluate each session you attend via our mobile app that can be used across devices at http://spsaturday. azurewebsites.net

50. Thanks to Our Sponsors! Raffle Silver Gold