Microsoft 70-332: Advanced Solutions of SharePoint Server...

Learn upgrade options, considerations, and preparation for SharePoint Server, starting with an introduction to SharePoint 2013, what's new, what's deprecated, and an overview of deployments and components.

Discover what's new in SharePoint 2013, including request management, the machine translation service, and default claims authentication, with mobile view and continuous crawl.

Identify deprecated features in SharePoint 2013, including the discontinued visual upgrade, removed templates, and analytics moving to the search service via PowerShell topology management, with SkyDrive Pro replacing office workspace.

Explore an overview of SharePoint additions, examine SharePoint Online, and configure hybrid deployments that integrate on site SharePoint with SharePoint Online.

Explore the SharePoint editions: foundation as a free core with limited features, standard with service applications and development features, and enterprise with licensing based on server and client access licenses.

SharePoint Online integrates with Active Directory using ADFS, reducing costs and delivering ROI under a Microsoft-managed SLA, while limiting customization and not all on-site services.

A SharePoint hybrid deployment mixes on-site and online environments, enabling single sign-on and running on-premises service applications while using business connectivity services to push data to the online implementation.

Explore the components that make up SharePoint, including the SharePoint farm, web applications, service applications, site collections, and sites.

Explore the SharePoint farm as the root node of the hierarchical model, covering all servers, components, and services, and browse to levels like central administration on the web application.

Explore how web applications act as boundaries for site collections and service applications hosted in IIS, and how a web app can host content databases and service-application databases via WCF.

Explore how site collections in a single web application use one content database, with sites contained within the collection, establishing a security boundary and preventing cross-database spans.

Explore how SharePoint runs on Windows Server and SQL Server as a .NET web application, using the SPFarm namespace. Use PowerShell for configuration and administration, with browser and web services.

Explore the hardware and software requirements for SharePoint, review database fundamentals, and examine the physical design of SharePoint, as well as design considerations, including sequel server requirements.

Configure SharePoint hardware by server role, using 4+ core processors, 12+ GB RAM, and 80+ GB drive space. Ensure 64-bit Windows Server and plan for specs with multiple service applications.

Identify software requirements for SharePoint deployment: Windows Server 2008 R2 SP1 or 2012, .NET Framework 4.5, and SQL Server 2008 R2 SP1 or 2012, plus role-specific needs.

SharePoint stores data in SQL Server; recovery models matter: full and bulk-logged require transaction log backups to prevent growth, while simple recovery truncates logs and lacks point in time recovery.

Map the logical to the physical SharePoint design by planning functional requirements and configuring Excel services, Power Pivot, Performance Point for dashboards, and active directory, alternate access mapping, and SSL.

Identify that a site collection uses one content database, a web application can have many content databases, and top-level object is SharePoint farm; SharePoint Online lacks some enterprise features.

Explore what's new and deprecated in SharePoint 2013, the foundation, standard, and enterprise editions, and how SharePoint Online, hybrid deployments, and on-premises farms with web applications and site collections relate.

Discover SharePoint continuity by examining high availability based on server roles, explore high availability techniques, and cover SharePoint backup and recovery.

Explore how availability depends on SharePoint roles and review techniques to ensure high availability across different server roles.

Understand how high availability varies by server role, with database mirroring, clustering, log shipping, and availability groups, and use network load balancing, request management, and multiple service-application instances for redundancy.

Explore clustering services, mirroring, and log shipping for SharePoint, including two-node active-active or active-passive setups. Learn about shared storage, witness, content databases, warm standby, and manual failover with client redirection.

Compare mirroring, clustering, and log shipping; mirroring and clustering offer automatic failover—mirroring for databases, clustering for the whole server—while log shipping lacks automatic failover and requires client redirection.

Explore always on availability groups in SQL Server 2012, enabling multiple read-only replicas for enterprise editions with application layer transparency and no shared storage.

Configure network load balancing in Windows, using either hardware or software, to distribute requests across multiple web front ends, boosting performance and providing redundancy if a front end fails.

Explore backup and recovery for SharePoint, focusing on item-level recovery and the fundamentals of SharePoint backup.

Define recovery point and recovery time objectives to shape SharePoint backups, and use the two-level recycle bin in Central Admin for user and site recovery within 30 and 45 days.

Discover SharePoint versioning in lists and libraries to restore previous items via major and minor versions. Export and import list objects with permissions using PowerShell or central administration.

Learn how to back up a SharePoint farm using central administration or PowerShell, configure granular and incremental backups, and perform point-in-time restores with transaction log backups.

Discover item-level backup and restore in SharePoint, and how versioning captures changes for accidental deletions. Examine major and minor versions, storage implications, and library settings for managing revisions.

Learn how version history and the recycle bin let users restore documents themselves, with a second-stage bin for site collection admins and a 45-day recovery window.

Learn to perform farm backups and restores in SharePoint, with full and granular options for content databases, web applications, service applications, search databases, and site collections.

Explore backup and restore in SharePoint server, covering farm and site collection backups, content database recovery, and list export with versioning, recycle bin, and PowerShell scheduling.

export the list from central administration to restore data without a full site restore, optionally including security permissions; for limited space, back up the service application for the excel service.

Explore high availability strategies for SharePoint server roles and the backup and restore options using recycle bin, versioning, item-level recovery, and central administration with PowerShell.

Learn how SharePoint service applications are provided, explore the architecture of server app service applications, and examine data storage, installation, and security across a farm.

Explore an introduction to service applications, identify the different terms used for service applications, and examine the service application workflow and instances.

Explore how SharePoint service applications replace the shared service provider, offering greater granularity, scalable deployment across separate web applications, and delegation of management.

Explore terms and components of SharePoint service applications, including service instances, endpoints, WCF, IIS, PowerShell usage, and the service application proxy for cross-farm publishing.

Explain how a service application processes browser requests through the web front end and software load balancer, routing to the correct service instance with BDC examples.

Plan your service applications before installation by isolating Excel services, data services, and business connectivity services for performance. Use shared application pools to avoid idle timeout and improve overall performance.

Manage and configure service applications via central administration or power shell, create new service instances, and explore web service applications, proxies, and cross-farm options.

Learn how to manage and create service applications in SharePoint, configure health data collection, scale out a service application, and set up separate management data services with dedicated application pools.

Learn to manage and create service applications in SharePoint, scale out the search service application with multiple instances, and understand the managed metadata service, taxonomy, and service application proxies.

In SharePoint, Excel services cannot be configured cross-farm, while other service applications can; place Excel in its own application pool, with the rest sharing a pool.

Explore the service applications within SharePoint's service application architecture, detailing components and edition-based variants that extend SharePoint functionality. Configure service applications with separate application pools built on Windows Communication Foundation.

Explore performance point in SharePoint 2013, use Excel Services as BI presentation layer, integrate SQL Server Reporting Services, and deploy dot net charts to present business intelligence in SharePoint sites.

Explore performance point and Excel services to enable business intelligence in SharePoint, covering configuring Excel services, Visio Services, Reporting Services, Power Pivot, and dot net charts.

Learn how performance point integrates with SharePoint to create dashboards and KPIs, connect multiple data sources, and operate as a service application within central administration.

Explore how Excel services in SharePoint evolved into its own service application, enabling browser-based viewing of Excel workbooks, including named ranges, charts, and Power Pivot, via trusted locations.

Discover how to install and configure Excel services as a SharePoint enterprise service, using central admin or PowerShell, with trusted file locations, data providers, and data connection libraries.

Explore Visio services in SharePoint to publish and automatically update diagrams from data sources such as databases and Active Directory, with deployment planning and authentication options.

Discover dot net charts in SharePoint 2010 and 2013, displayed in web parts and powered by the .NET runtime, offering charts with different types and colors to visualize data metrics.

Explore the evolution of SQL Server Reporting Services from native to integrated mode with SharePoint, and learn how alerts enable data driven notifications and centralized management.

Explore how to deploy SQL Server Reporting Services in native or SharePoint integrated mode, configure single, two, or multi-tier topologies, and enable Power View reports with storyboarding and PowerPoint exports.

Power Pivot creates tabular data models that run in Excel or deploy to Analysis Services in tabular mode, integrates with reporting services, and supports partitions and row-level and column-level permissions.

Implement business intelligence in SharePoint 2013 by configuring the Excel services service application, defining unattended service accounts, managing trusted file locations, and setting up data connections libraries and providers.

Configure user defined function assemblies for Excel services using .NET or DSL, enabling workbook access to custom code; set up a business intelligence site collection and data connections library.

Configure Excel services to trust a data connection library in central administration and explore enterprise BI features like Power View and Power Pivot in SharePoint.

Troubleshoot Excel services errors by adding the location of the spreadsheet to Trusted Locations, then use performance point to present dashboards and key performance indicators.

Explore how SharePoint 2013 serves as the BI presentation layer, integrating analysis services, reporting services, Excel services, Power View, performance point, and Visio services for dynamic dashboards and reports.

Explore social computing in SharePoint by examining user profiles in SharePoint 2013, managing user profiles, analyzing my sites, and understanding audiences.

Explore an introduction to SharePoint user profiles, learn about importing profiles from various sources, configure the user profile service application, manage profile properties, and work with SharePoint Online.

Explore how SharePoint populates and customizes user profiles with user profile service, pulling data from Active Directory, profile data services, or SQL Server to enable targeted content and social computing.

Use user profiles to populate my sites and support audiences, social tagging, and personalization. Index profiles to improve search results and connect users with similar projects or groups.

Configure the user profile service to import attributes from Active Directory as the authoritative source, map custom attributes, define import sources and methods, and set incremental synchronization for search.

Configure the user profile service by creating a constrained Active Directory service account with delegated replication permissions, then set up Active Directory import and define full and incremental synchronization schedules.

Examine default SharePoint user profile properties, their data types such as numeric, yes/no, and date/time, and learn how policies and privacy settings govern overrides by users or the farm administrator.

Sync Active Directory to the SharePoint Online user profile using the Office 365 directory synchronization tool on a dedicated computer, with one-way updates from Active Directory to the profile.

Examine my sites, configure social feature permissions, and tailor site audiences in SharePoint Online. Discuss how audiences interact with my sites within SharePoint Online.

Explore how my sites personalize user experiences with private or shared content, profiles, activity feeds, tagging, and a personalization search across centralized storage.

Configure my sites by creating the site collection with the my site host template and defining the my site URL, using a dedicated web application and a separate content database.

Learn how social feature permissions control personal profiles and following, including configurable profile edits in the User Profile service application, with delegation, locking down, and user or feature-level controls.

Create and use audiences to target SharePoint content by department-based rules drawn from user profiles, configured in the user profile service application, central admin, or PowerShell.

Define and enforce who can create my sites and use personal and social features via the user profile service, managed in central administration with farm or service privacy settings.

Explore the limitations of my sites online and how audiences use Active Directory directory services manager attribute, groups, and online profile properties to tailor content with search center and permissions.

Explore the SharePoint 2013 community site template built on the team site, introducing pages, lists, and web parts, and learn how the portal displays community sites with membership and permissions.

Explore social computing in SharePoint via the user profile service, connect to Active Directory, and map attributes to keep user profiles synchronized and up to date.

Explore how SharePoint social computing synchronizes user profiles, maps properties like job title, and builds business audiences such as managers through scheduled compilation.

Add a new address attribute for user profiles and map it to the Active Directory property. Configure synchronization and compile audiences to target content, while leveraging my sites.

Create a web application to host the my sites site collection, then configure the user profile service to use that collection and enable self-service site creation.

Explore social computing in SharePoint by configuring the user profile service, linking a my site host, enabling self-service site creation, and building audiences from profile rules to target content.

Explain how SharePoint audiences, built into the user profile service, target content to users via rules, with my sites relying on audiences rather than Active Directory or Excel Services.

Explore user profiles, social computing in SharePoint, and importing profiles from Active Directory and other data sources. Learn my site, audience permissions, and search features across SharePoint Online and on-premises.

Explore SharePoint search fundamentals, including an introduction to the search service application and SharePoint, and learn how to configure and manage the search service application.

Explore the different search components in SharePoint Server, including the Krol component, content processing, analytics processing, indexing component, query processing component, and search administration.

explore how the crawl service gathers data and metadata from sources, uses iFilter and protocol handlers to read content, then passes it to content processing and stores results in databases.

Activate content processing to parse documents, map properties, run linguistics processing, and write link data to the link database, with configurable content types and custom extractors for organization-specific terms.

The crawl extracts data and metadata, processes content, analyzes information, and builds a search index to help queries locate information across site collections, libraries, and file stores.

Explore crawling and indexing, query processing with stemming and hyphenation, and security trimming, and how topology and crawl rules shape scalable search results.

Explore content sources and Krol rules, and apply search center best practices for configuring search service query rules, result types, and display templates.

Configure content sources and crawl rules to govern what the search service extracts. Use protocol handlers for common formats and support full, incremental, and continuous crawling via the search center.

Utilize your method data to proactively manage crawling and monitor analytics to iteratively refine search results, and move documents to document libraries while configuring authoritative pages for better relevance.

Define and apply SharePoint 2013 query rules by setting conditions, actions, and publishing options with start or stop dates, and manage result types with properties and display templates.

Configure search web parts in the search center, define content types, use basic or advanced modes, create refinement and customized result pages, and analyze usage reports to tune searches.

Configure and verify a SharePoint search service application, create content sources such as an Excel share, and schedule full and incremental crawls to keep results current.

Review crawl logs to see the last 24 hours of successes and errors, ensure the crawl service has full read access, and configure rules for path exclusion and incremental crawls.

Explore crawling and indexing in SharePoint by examining supported file types, protocol filters, and incremental crawls, and configure result sources and query rules to improve search for user profiles.

Explore configuring the SharePoint search service, creating content sources, and applying crawl and query rules while reviewing crawl health reports and rate analytics for improved search via a document library.

Explore how the crawl component traverses items and passes data to the content processor for document parsing and property mapping, bridging crawl and index in SharePoint search.

Explore the SharePoint 2013 search service architecture, from content sources and data extraction to content processing, indexing, and query processing, plus crawl rules and display templates.

Explore content management in sharepoint and learn how to manage documents and files. Examine content types and the managed metadata service to organize and categorize content.

Explore document and file management, including custom columns and their differences. Learn to introduce, create, and manage content types, understand content type inheritance, and overview e-discovery.

Explore SharePoint document and file management across web content, records, and document management, using check-out, check-in, versioning, content approval, content types, and retention and auditing policies.

Define site columns in SharePoint, created at the site or site collection, and learn how they enforce data types and consistency. Compare predefined and custom columns.

Create and manage reusable content types across a SharePoint site collection, using inheritance to propagate columns, templates, and workflows for consistent taxonomy and organization-wide metadata.

Explore InfoPath forms for structured data in SharePoint, publish and activate forms in the service, and leverage shredded storage to reduce disk I/O, network usage, and space.

The e-discovery center centralizes preservation, search, and export of content across SharePoint farms and Exchange servers, enabling in-place holds on sites and mailboxes and query-based preservation.

Install Exchange Web Services Managed API on each SharePoint server (requires Exchange 2012; remove older APIs), then configure two-way server-to-server authentication and add users to the discovery management group.

Activate site collection policies to automatically delete, or close, after projects, supporting governance. Use records management via the records center or in-place, keeping records in their original location.

Explore the managed metadata service, define terms and term sets, publish data across the farm, and manage term groups within term sets for SharePoint 2013.

Explore managed metadata services and the control of feature and social permissions, including edit profile via the user profile service application, and delegated permissions from farm administrators to users.

Understand how term groups, term sets, and terms organize metadata and permissions in SharePoint, with roles for owners, managers, and contributors who control changes and security policies.

Publish data and metadata across a SharePoint farm with service, using the primary farm to publish service so other farms subscribe and replicate term sets, term groups, and content types.

Manage term groups and term sets in SharePoint by defining names, descriptions, owners, and contributors, and tagging terms with custom properties while granting appropriate permissions.

Learn how refinement in SharePoint 2013 narrows navigation with the refinement web part, refining a color column and managed metadata terms to guide users and support crawling as refiners.

Explore content management in SharePoint by creating and organizing site columns and document libraries, including employee evaluation fields like hire date and promotion date.

Create a new finance employee evaluation content type that inherits from document types, and associate the site column employee hire date. Enable content type management in the finance site library.

Configure content types in a SharePoint document library by using the finance employee evaluation type and create an accounts payable type inherited from it, with taxonomy and templates.

Create and inherit content types for employee evaluation across business units, enabling automatic updates. Publish taxonomy via managed metadata service to enforce cross-farm and cross-site collection consistency.

Enforce consistent sales district data across farms by using the managed metadata service and term store to publish site columns and content types, enabling cross site collection taxonomy.

Explore exam prep scenarios for SharePoint administration, focusing on replicating content types across farms with the managed metadata service and activating InfoPath forms for site collections.

Explore SharePoint content management, including content types, site columns, e-discovery, records center, and managed metadata, with foundation and enterprise features for versioning, check-in/out, and approvals.

Explore managing SharePoint development, the progression and tools available, discuss features, solutions, and sandbox solutions, configure sandbox solutions, and introduce SharePoint apps as a new development approach in SharePoint 2013.

Explore SharePoint development progression and the tools available, then examine SharePoint features and solutions and explain sandbox solutions and how to configure them.

Start in the browser to apply templates and customize text, backgrounds, scenes, photos, and workflows in SharePoint, then advance to SharePoint Designer and Visual Studio for extended features.

Learn how SharePoint features deploy web parts and assemblies across every web front end and farm, using PowerShell, with scope, visibility, activation and deactivation, and feature dependencies.

Explore SharePoint solutions and sandbox solutions, including farm deployment, features, and protected sandbox contexts. Configure quotas via PowerShell for site collections and manage user code service and sandbox processes.

Explore the basics of SharePoint applications, identify essential SharePoint app requirements, and learn how to configure SharePoint for apps.

Learn about SharePoint apps, introduced in 2013, separate from solutions and features, with on-site, Windows hosting, or provider hosting options, and setup—DNS zone, app management, app catalog, and subscription settings.

Configure SharePoint apps with a separate DNS and domain, plus a unique host header prefix and hash; then create the app catalog in Central Administration and deploy with licensing options.

Define app permissions and scopes (read-only, manage, full control) at site collection, site, list, or tenant, then monitor licenses and app activity from central administration.

Shows how to create and deploy a SharePoint 2013 feature to extend capabilities, including setting the feature ID, title, description, and scope, then installing it via PowerShell.

Activate and uninstall site collection and farm features in SharePoint by deploying feature and elements.xml files across all web front ends, using central admin or PowerShell.

Explore configuring farm solutions and deploying features across web fronts, then monitor their execution with the developer dashboard to diagnose performance and bottlenecks in SharePoint pages.

Deploy the solution to the farm with PowerShell. Ensure the feature is installed on all web front ends to prevent sporadic errors in a load-balanced farm.

Explore the SharePoint development progression from browser customizations to designer, Visual Studio, and farm or sandbox features, with deployment of web parts, assemblies, cab files, apps, and DNS zone configurations.

Explore SharePoint governance by examining governance concepts and applying planning, features, and policies to govern and oversee SharePoint deployments.

Explore governance and oversight within your organization and contrast policies with technology. Identify SharePoint technologies that enforce or support governance and oversight.

Define governance in SharePoint, outline architectural elements and roles, plan policies in the planning phase to guide design and access, aligning with Sarbanes-Oxley.

Governance planning begins at implementation, aligning information architecture with access controls, read, write, delete rights, metadata strategy, and applications, while defining branding, master pages, css, and permissions across sites.

Define governance policy, oversight, and standard operating procedures, then use SharePoint features to meet them. Let technology facilitate policy, not dictate it, and consider custom or third-party solutions for gaps.

Explore SharePoint governance features that manage storage, quotas, workflows, and policy-based oversight. Cover information governance tools like content approval, e-discovery, versioning, retention, and auditing.

Policies stem from governance and organizational responsibilities, not technology; SharePoint information governance features such as content approval, e-discovery, and content types support governance, while workflows alone do not.

Explore governance and oversight in SharePoint, outlining policies upfront and planning implementation with SharePoint technologies to ensure policy compliance without letting technology drive policy.