You are previewing Exam Ref 70-332: Advanced Solutions of Microsoft SharePoint Server 2013.
O'Reilly logo
Exam Ref 70-332: Advanced Solutions of Microsoft SharePoint Server 2013

Book Description

Prepare for Exam 70-332—and help demonstrate your real-world mastery of Microsoft SharePoint Server 2013. Designed for experienced IT Professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.

Focus on the expertise measured by these objectives:

  • Plan Business Continuity Management

  • Plan a SharePoint Environment

  • Upgrade and Migrate a SharePoint Environment

  • Create and Configure Service Applications

  • Manage SharePoint Solutions, BI, and Systems Integration

  • Table of Contents

    1. Dedication
    2. Special Upgrade Offer
    3. Introduction
      1. Microsoft certifications
      2. Acknowledgments
      3. Errata & book support
      4. We want to hear from you
      5. Stay in touch
    4. Preparing for the Exam
    5. 1. Plan business continuity management
      1. Objective 1.1: Plan for SQL high availability and disaster recovery
        1. Gathering requirements
          1. Choosing a version of SQL Server
          2. Understanding multi-subnet failover clustering
          3. Determining limitations
        2. Planning for SQL Server mirroring
          1. Determining mirroring requirements
          2. Setting up a database mirror
          3. Using permissions for database mirroring
        3. Planning for SQL Server clustering
        4. Planning for SQL Server AlwaysOn
          1. AlwaysOn High Availability Groups
          2. AlwaysOn Failover Cluster Instances
        5. Planning for SQL Server log shipping
          1. Database mirroring with log shipping
        6. Planning for storage redundancy
          1. Database mirroring for data redundancy
          2. Database clustering for data redundancy
          3. Backups for data redundancy
        7. Planning for login replication
        8. Objective summary
        9. Objective review
      2. Objective 1.2: Plan for SharePoint high availability
        1. Planning for service distribution
          1. Web Front End
          2. Search server
          3. Application server
        2. Planning for service instance configuration
        3. Planning for physical server distribution
          1. SAN
          2. RAID
        4. Planning for network redundancy
        5. Planning for SQL Server load balancing
          1. Linked servers
          2. Federated database servers
        6. Planning for SQL Server aliases
        7. Objective summary
        8. Objective review
      3. Objective 1.3: Plan backup and restore
        1. Establishing a SharePoint backup schedule
        2. Using Central Administration backup
        3. Establishing a SharePoint backup schedule
        4. Establishing a SQL Server backup schedule
        5. Planning a non-production environment content refresh
        6. Planning for farm configuration recovery
        7. Planning for service application recovery
        8. Planning for content recovery
          1. Recovering a database using Restore-SPSite
          2. Recovering a database via SQL Server
          3. Recovering a database using Central Administration
        9. Objective summary
        10. Objective review
      4. Chapter summary
      5. Answers
        1. Objective 1.1: Thought experiment
        2. Objective 1.1: Review
        3. Objective 1.2: Thought experiment
        4. Objective 1.2: Review
        5. Objective 1.3: Thought experiment
        6. Objective 1.3: Review
    6. 2. Plan a SharePoint environment
      1. Objective 2.1: Plan a social workload
        1. Planning communities
          1. Reputation settings
          2. Badges
        2. Planning My Sites
          1. My Site host
          2. Trusted My Site host locations
          3. Personal site collections (SkyDrive)
        3. Planning social permissions
          1. Audiences
          2. Social permissions
        4. Planning user profiles
        5. Planning activity feeds
        6. Planning connections
        7. Objective summary
        8. Objective review
      2. Objective 2.2: Plan and configure a search workload
        1. Planning and configuring search result relevancy
          1. Building a thesaurus
          2. Defining custom entity extractions
          3. Adding query suggestions
          4. Designating authoritative pages
        2. Planning and configuring index freshness
        3. Planning and configuring result sources
        4. Planning and configuring the end-user experience
          1. Query rules
          2. Display templates
          3. Result types
        5. Planning and configuring a search schema
        6. Analyzing search analytics reports
          1. Search analytics
          2. Usage analytics
        7. Objective summary
        8. Objective review
      3. Objective 2.3: Plan and configure Web Content Management (WCM)
        1. Planning and configuring channels
        2. Planning and configuring product catalogs and topic pages
          1. Product catalogs
            1. Creating site columns
            2. Managing site content types
            3. Managing Item Hierarchy in Term Store
            4. Adding Catalog Items
            5. Modifying Search Properties
            6. Using the Catalog
          2. Topic pages
        3. Planning and configuring content deployment
        4. Planning and configuring variations
        5. Objective summary
        6. Objective review
      4. Objective 2.4: Plan an Enterprise Content Management (ECM) workload
        1. Planning and configuring eDiscovery
        2. Planning and configuring record management
        3. Planning and configuring record disposition and retention
        4. Planning large document repositories
        5. Objective summary
        6. Objective review
      5. Chapter summary
      6. Answers
        1. Objective 2.1: Thought experiment
        2. Objective 2.1: Review
        3. Objective 2.2: Thought experiment
        4. Objective 2.2: Review
        5. Objective 2.3: Thought experiment
        6. Objective 2.3: Review
        7. Objective 2.4: Thought experiment
        8. Objective 2.4: Review
    7. 3. Upgrade and migrate a SharePoint environment
      1. Objective 3.1: Evaluate content and customizations
        1. Performing migration pre-check tasks
        2. Analyzing content database test results
        3. Configuring web application authentication for upgrades
        4. Resolving orphan objects
        5. Resolving missing files
          1. Using Windiff and comp
          2. Using the SharePoint Products Configuration Wizard for missing files
        6. Resolving configuration issues
        7. Objective summary
        8. Objective review
      2. Objective 3.2: Plan an upgrade process
        1. Planning removal of servers in rotation
          1. Using Psconfig
          2. Removing services
          3. Moving User Profile Synchronization
          4. Removing other servers
        2. Configuring parallel upgrades
        3. Configuring read-only access for content
        4. Configuring upgrade farms
        5. Measuring upgrade performance
        6. Planning an installation sequence
        7. Objective summary
        8. Objective review
      3. Objective 3.3: Upgrade site collection
        1. Performing a health check
        2. Analyzing and resolving health check results
        3. Planning and configuring available site collection modes
        4. Planning and configuring site collection upgrade availability
        5. Planning and configuring evaluation mode
        6. Planning and configuring site collection upgrade queues and throttling
        7. Objective summary
        8. Objective review
      4. Chapter summary
      5. Answers
        1. Objective 3.1: Thought experiment
        2. Objective 3.1: Review
        3. Objective 3.2: Thought experiment
        4. Objective 3.2: Review
        5. Objective 3.3: Thought experiment
        6. Objective 3.3: Review
    8. 4. Create and configure service applications
      1. Objective 4.1: Create and configure App Management
        1. Creating and configuring the App Store
        2. Creating and configuring subscriptions
        3. Configuring DNS entries
        4. Configuring wildcard certificates
        5. Objective summary
        6. Objective review
      2. Objective 4.2: Create and configure productivity services
        1. Creating and configuring Microsoft Excel Services
          1. Configuring global settings
            1. Security settings
            2. Load balancing settings
            3. Session management settings
            4. Memory usage settings
            5. Workbook cache settings
            6. External data settings
          2. Defining trusted file locations
            1. Location settings
            2. Session management settings
            3. Workbook settings
            4. Settings for calculation behavior
            5. External data settings
            6. Settings for user-defined functions
          3. Defining trusted data providers
          4. Setting up trusted data connection libraries
          5. Defining user-defined function assemblies
          6. Configuring data model settings
        2. Creating and configuring Microsoft Access Services
          1. Access Services 2010
          2. Access Services
            1. Making SQL Server 2012 available
            2. Starting the Access Services service
            3. Creating the Access Services service
            4. Configuring the application pool
            5. Creating a site collection
            6. Confirming the settings
        3. Creating and configuring Microsoft Visio Services
          1. Creating an unattended service account
          2. Creating the Visio Graphics Service service application
          3. Configuring Visio Graphics Service settings
            1. Global settings
            2. Trusted data providers
        4. Creating and configuring Microsoft Word Automation Services
          1. Creating the service application
          2. Modifying properties
          3. Configuring file conversions
        5. Creating and configuring Microsoft PowerPoint Conversion Services
        6. Creating and configuring Machine Translation Services
          1. Creating a Machine Translation Services service application
          2. Configuring the settings
          3. Running Machine Translation Services
        7. Objective summary
        8. Objective review
      3. Objective 4.3: Configure Service Application Federation
        1. Planning services to federate
        2. Performing a certificate exchange
        3. Managing trusts
        4. Managing service application permissions
        5. Publishing service applications
        6. Consuming service applications
        7. Objective summary
        8. Objective review
      4. Objective 4.4: Create and configure a Business Connectivity Service and Secure Store application
        1. Importing and configuring BCS models
        2. Configuring BCS model security
        3. Generating a Secure Store master key
        4. Managing the Secure Store master key
        5. Creating Secure Store target applications
        6. Managing Secure Store target application permissions
        7. Objective summary
        8. Objective review
      5. Chapter summary
      6. Answers
        1. Objective 4.1: Thought experiment
        2. Objective 4.1: Review
        3. Objective 4.2: Thought experiment
        4. Objective 4.2: Review
        5. Objective 4.3: Thought experiment
        6. Objective 4.3: Review
        7. Objective 4.4: Thought experiment
        8. Objective 4.4: Review
    9. 5. Manage SharePoint solutions, BI, and systems integration
      1. Objective 5.1: Manage SharePoint solutions and applications
        1. Managing sandboxed solution quotas
        2. Configuring Sandboxed Solution Management
        3. Deploying farm solutions
        4. Upgrading farm solutions
        5. Deploying apps
        6. Upgrading apps
        7. Objective summary
        8. Objective review
      2. Objective 5.2: Planning and configuring a BI infrastructure
        1. Planning and configuring PerformancePoint
          1. Configuring the unattended service account
          2. Configuring trusted data sources
          3. Configuring site collections to use PerformancePoint
        2. Planning and configuring Reporting Services
          1. Installing Reporting Services on SQL Server
          2. Configuring SharePoint for Reporting Services
          3. Provisioning subscriptions and alerts
          4. Configuring Reporting Services
            1. Configuring system settings
            2. Managing Jobs
            3. Managing Keys
            4. Configuring the Execution Account
            5. Configuring Email Settings
            6. Provisioning subscriptions and alerts
            7. Monitoring Resources
        3. Planning and configuring PowerPivot
          1. Running the Configuration tool
          2. Creating the PowerPivot service application
          3. Working with additional PowerPivot settings
        4. Planning and configuring Excel Services data modeling
        5. Planning and configuring Power View
        6. Objective summary
        7. Objective review
      3. Objective 5.3: Creating and configuring work management
        1. Configuring a connection to Microsoft Project Server
          1. Installing Project Server
          2. Starting the Project Server Application Service
          3. Creating the Project Server service application
          4. Creating a Project Server web app
        2. Configuring a connection to Exchange for eDiscovery and Resource Sharing
        3. Objective summary
        4. Objective review
      4. Chapter summary
      5. Answers
        1. Objective 5.1: Thought experiment
        2. Objective 5.1: Review
        3. Objective 5.2: Thought experiment
        4. Objective 5.2: Review
        5. Objective 5.3: Thought experiment
        6. Objective 5.3: Review
    10. A. About the Author
    11. Index
    12. About the Author
    13. Special Upgrade Offer
    14. Copyright