By: Daniel Calbimonte | Updated: 2018-01-23 | Comments | Related: More > Professional Development Certifications
Problem
I took several SQL Server exams studying your Microsoft certification series and this time I want to take exam 70-339 certification. Can you help me?
Solution
Gladly. This time we will answer some questions about exam 70-339 and provide some materials to study.
FAQ
If I am a SQL Server DBA, do you recommend taking this exam?
Yes, many SQL Server DBAs must deal with some SharePoint tasks and some SharePoint administrators need to deal with SQL Server, because SharePoint stores information in SQL Server.
Also, when using Reporting Services, it is possible to install it in SharePoint Integrated mode instead of SSRS native mode as shown below.
Who should take this exam?
This exam is oriented to SharePoint Administrators, SharePoint Developers, DBAs, IT Administrators interested in the SharePoint platform.
Is this exam a requirement for any certification?
This exam is optional to get the MCSE Productivity Solutions Expert certification. Note that the MCSE: SharePoint Solution Expert was retired as of March 31, 2017.
Is the exam easy?
No. This exam is very difficult because you need to read a lot, have knowledge about Office, Office 365, PowerShell, SQL Server, Exchange, Project Server and other technologies to integrate with SharePoint.
What is the relationship between SharePoint Server 2016 and SQL Server?
To install SharePoint 2016, you need at least SQL Server 2014 to install it. A good SharePoint Administrator must have good knowledge of SQL Server. If you work with Reporting Services, it is a great idea to deploy the reports in SharePoint because it is a better way to share the report to the entire company using the portal.
Which books would you recommend for this exam?
These books will be useful:
- Exam Ref 70-339 Managing Microsoft SharePoint Server 2016
- SharePoint 2016 For Dummies
- SharePoint Online from Scratch: Office 365 SharePoint from basics to advanced
- SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform
- Microsoft SharePoint 2016 Step by Step
- Microsoft SharePoint 2016 Introduction Quick Reference Guide - Windows Version (Cheat Sheet of Instructions & Tips - Laminated Card)
- Deploying SharePoint 2016: Best Practices for Installing, Configuring, and Maintaining SharePoint Server 2016
- Building a SharePoint 2016 Home Lab: A How-To Reference on Simulating a Realistic SharePoint Testing Environment
- From IT Pro to Cloud Pro Microsoft Office 365 and SharePoint Online (IT Best Practices - Microsoft Press)
Are there some courses for this exam?
Yes, here are some useful courses.
- Microsoft SharePoint 2016: Authentication and Security
- Microsoft SharePoint 2016: Workload Optimization
- Microsoft SharePoint 2016: Productivity Solutions
- Microsoft SharePoint 2016: Infrastructure
- Course 20339-1A Planning and Administering SharePoint 2016
- Course 20339-2A: Advanced Technologies of SharePoint 2016
- Course 55199A: SharePoint 2016 End User Training
- Course 55193A: Introduction to SharePoint 2016 for Collaboration and Document Management
- Course 55217A: SharePoint 2016 Power User
- Udemy SharePoint courses
- MVA SharePoint Courses
- Pluralsight SharePoint
- Managing Microsoft SharePoint Server 2016: 70-339
Are there some practice tests?
Yes, the following exams are available:
- 70-339: Managing Microsoft SharePoint Server 2016 Microsoft Official Practice Test
- Microsoft (70-339): Managing Microsoft SharePoint Server 2016
Do you have some links to study, for this exam?
Yes, these links will be useful:
Design SharePoint infrastructure
- Design information architecture
- Design an intersite navigational taxonomy.
- SharePoint Content Types, Site Columns or Columns
- Add an enterprise keywords column to a list or library
- Implement Synonyms / Thesaurus in SharePoint Online
- SharePoint 2013 : Promoted Search Results
- Overview of crawled and managed properties in SharePoint Server
- Durable Links in SharePoint Server 2016 IT Preview
- What is a document library?
- Plan for information management policy in SharePoint Server 2013
- What's new in SharePoint eDiscovery and compliance
- What the sensitive information types in SharePoint Server 2016 look for
- Create and manage terms in a term set
- Set Open Document Format (ODF) as the default file template for a library
- Use a mobile device to work with SharePoint Online sites
- Create Web Application In Sharepoint Server 2016
- Design a logical architecture
- Software boundaries and limits for SharePoint Server 2016
- Plan for administrative and service accounts in SharePoint Server
- Database types and descriptions in SharePoint Server
- CREATING HOST-NAMED SITE COLLECTIONS IN SHAREPOINT 2013
- Fast Site Collection Creation Feature In Sharepoint Server 2016
- Plan alternate access mappings for SharePoint Server
- Design a physical architecture
- Technical diagrams for SharePoint Server
- Planning for SharePoint Server 2016: Physical Topology and Services
- Overview of MinRole Server Roles in SharePoint Server 2016
- SharePoint 2016 Central Admin – System Settings – Manage Farm Solution -Part 1
- New and improved features in SharePoint Server 2016
- Resilient File System Overview
- Request Management in SharePoint Server 2013 Preview, Part One: Feature Capability and Architecture Overview
- Hardware and software requirements for SharePoint Server 2016
- Plan service deployment in SharePoint Server
- Load Balancing Microsoft SharePoint
- Run a high availability SharePoint Server 2016 farm in Azure
- Issues Uploading Large Files To SharePoint
- SharePoint Large File Upload Configuration
- SharePoint 2013 app hosting models
- Plan an installation
- Hardware and software requirements for SharePoint Server 2016
- Scripted Installation of SharePoint 2013 and Office Web Apps Server – From the Field (Part 2)
- Plan for Access Services in SharePoint Server 2013
- Install SharePoint Server 2013 (Project Server 2013)
- Slipstreaming Patches into SharePoint 2013
- Install or uninstall language packs for SharePoint Server 2016
- Configuring Service Connection Points for SharePoint 2013
- Configure audit settings for a site collection
- Configure Office Online Server for SharePoint Server 2016
- Introducing the SharePoint Migration Tool from Microsoft
- SharePoint hybrid
- Plan a hybrid cloud environment
- SharePoint Online Planning Guide for Office 365 for business
- Office Online Server
- Configure server-to-server authentication from SharePoint Server to SharePoint Online
- Authorization Code OAuth flow for SharePoint Add-ins
- Configure hybrid sites features - roadmap
- Hybrid search in SharePoint
- Overview of OneDrive for Business in SharePoint Server
- What is a SharePoint team site?
- The extensible hybrid app launcher
- Plan for the SharePoint Hybrid Picker
Plan authentication and security
- Plan and configure authentication
- Plan for user authentication methods in SharePoint Server
- SharePoint 2016 Outgoing Email Configuration settings
- Quick Start: Enabling Federation in a SharePoint Application with AD FS 2.0 as the STS
- Federated Identity for SharePoint Applications
- Claims provider in SharePoint
- Configure site-to-site (S2S) intra-server and OAuth authentication
- Configure server-to-server authentication from SharePoint Server to SharePoint Online
- Hybrid Cloud Identity Part 1: AD and Azure AD
- Hybrid for SharePoint Server
- Plan and configure authorization
- How to Add a New User Group in SharePoint 2016
- Use the client-side People Picker control in SharePoint-hosted SharePoint Add-ins
- SharePoint Workflow Simplified: One-Click Approvals
- Make SharePoint Site Responsive in One Click
- What is permissions inheritance?
- Understanding SharePoint Permissions Inheritance
- Enable Anonymous Access for SharePoint 2010/2013/2016
- Manage permission policies for a web application in SharePoint Server
- SharePoint security
- How to lock down external anonymous access SharePoint sites
- Configure antivirus settings (Windows SharePoint Services)
- Plan and configure platform and farm security
- SharePoint 2013 Or 2016: Configure Antivirus Settings And Features
- Configure SSL for SharePoint 2013
- Plan for Kerberos authentication in SharePoint Server
- Information Rights Management
- Apply Information Rights Management to a list or library
- Choose administrators and owners for the administration hierarchy in SharePoint 2013
- Administer the User Profile service in SharePoint Server
- Demystifying SharePoint Admin Permissions
- Configure Managed Accounts In SharePoint 2013 Central Administration
- Types of files that cannot be added to a list or library
- SharePoint 2016 Central Admin - Security - Manage Web Part Security
- WOPI Introduction
- Office Web Apps cmdlets in SharePoint Server 2013
- SharePoint 2013: Building your own WOPI Client, part 1
- Create and configure a User Profile Service (UPA) application
- Overview of the User Profile service architecture in SharePoint Server
- Configure My Sites and OneDrive for Business in SharePoint Server
- Configure social computing features in SharePoint Server 2013
- Install Microsoft Identity Manager for User Profiles in SharePoint Server 2016
- Plan user profiles and identities
- Manage site and site collection security
- Provision and configure web applications
Plan workload optimization
- Create and maintain site collections
- Fast Site Collection Creation in SharePoint Server 2016 IT Preview
- Host-named site collection architecture and deployment in SharePoint Server
- Site Owner vs Site Collection Administrator
- How do you manage the size of your SharePoint sites?
- Overview of site policies in SharePoint Server
- Configure site mailboxes in SharePoint Server
- Sites page pinning
- Plan SharePoint high availability and disaster recovery solutions
- Create a high availability architecture and strategy for SharePoint Server
- Supported high availability and disaster recovery options for SharePoint databases
- Run a high availability SharePoint Server 2016 farm in Azure
- SharePoint 2016 load balancing
- Configure SQL Server AlwaysOn Availability Groups for SharePoint Server
- Best Practices: Configuring SharePoint & SQL Server Alias
- Super SQL Server Clusters for SharePoint – Part 1
- SQL Server log shipping offers path to SharePoint disaster recovery
- Microsoft SharePoint 2016: Workload Optimization
- Plan backup and restore
- Backup and restore best practices in SharePoint Server
- Backup solutions in SharePoint Server
- Overview of backup and recovery in SharePoint Server
- SharePoint 2013 Backup with PowerShell and Task Scheduler for beginners
- Restore farm configurations in SharePoint Server
- Restore service applications in SharePoint Server
- Restore items in the Recycle Bin of a SharePoint site
- SharePoint Server 2013 Disaster Recovery in Microsoft Azure
- SharePoint Server 2013 Disaster Recovery Farm in Azure
- Plan and configure social workloads
- SharePoint 2016 Tutorial | Module 6| Social Workloads
- Configure My Sites in SharePoint Server
- Get started developing with social features in SharePoint
- Enable or disable social tag permissions for users or groups
- Create a User Profile service applications in SharePoint Server
- Overview of microblog features, feeds, and the Distributed Cache service in SharePoint Server 2013
- Get and install the Yammer app onto SharePoint Server 2013 sites
- Plan and configure
- Web Content Management (WCM) workload
- Plan and configure an Enterprise Content Management (ECM) workload
- Overview of eDiscovery and in-place holds in SharePoint Server
- Overview of document deletion policies
- Overview of co-authoring in SharePoint 2013
- Everything You Need to Know About Durable Links in SharePoint 2016
- Create a file plan to manage records in SharePoint Server 2013
- Microsoft SharePoint 2016: Workload Optimization
- Software boundaries and limits for SharePoint 2013
- Overview of data loss prevention in SharePoint Server 2016
Plan productivity solutions
- Evaluate content and customizations
- Customizing the "modern" experiences in SharePoint Online
- Customizing "modern" site pages
- [Video] SharePoint Migration: Preparation, Cleanup, and Check Up
- Reduce the Risks of your SharePoint Migration with the Pre-Migration checkup
- Analyze Test-SPContentDatabase Output
- Plan for user authentication methods in SharePoint Server
- Orphans Object Clean Up in SharePoint
- Solving problems and troubleshooting in SharePoint 2013
- SharePoint Performance Problems & Solutions
- Plan an upgrade process
- Upgrade to SharePoint Server 2016
- SharePoint Update Deployment – Automating Parallel Content Database Upgrades
- Set SharePoint Content Database in Read-Only Mode
- Upgrade farms that share services (parent and child farms) to SharePoint 2013
- Plan for upgrade to SharePoint 2013
- Migrate to SharePoint Online
- Migrate to SharePoint Online (O365–SPO) from On-Premise SharePoint or fileshare using new PowerShell migration APIs
- Create and configure app management
- Create and configure productivity services
- Configure Office Online Server for SharePoint Server 2016
- Overview of Access Services in SharePoint Server 2013
- Overview of Visio Services in SharePoint Server
- PowerPoint Automation Services in SharePoint
- Machine Translation Services in SharePoint
- SharePoint hybrid
- Plan hybrid OneDrive for Business
- Installing Office Online Server for SharePoint 2016
- What’s in Insights
- Configure and deploy Telemetry Dashboard
- Create and configure a Business Connectivity Service (BCS) and Secure Store
application
- Business Connectivity Services in SharePoint
- Configure the Secure Store Service in SharePoint Server
- SharePoint 2013 - Export and Import BDC Model to Create External List
- Overview of Business Connectivity Services security tasks in SharePoint Server
- Enhancing the BDC model file for Search in SharePoint
- Configure the Secure Store Service in SharePoint Server
- Secure Store target applications
- Deploy a Business Connectivity Services hybrid solution in SharePoint
- Manage SharePoint solutions and applications
Manage search capabilities
- Create and configure Enterprise search
- Manage the search topology in SharePoint Server
- Add, edit, or delete a content source in SharePoint Server
- Manage continuous crawls in SharePoint Server
- Manage crawl rules in SharePoint Server
- Best practices for crawling in SharePoint Server
- Overview of security trimming, administrative policies, and privacy settings for social feeds in SharePoint Server 2013
- Hybrid search in SharePoint
- Create and configure a Managed Metadata Service (MMS) application
- Introduction to managed metadata
- Configure the Managed Metadata service
- How To Create And Use Content Type Hub In SharePoint
- Set up a new group for term sets
- What is the use of custom properties for terms in term store management of SharePoint 2013
- Assign roles and permissions to manage term sets
- SharePoint- Export/Import Managed Metadata Terms through CSV
- How to Configure Result Source for Search in SharePoint 2013
- Manage search
- Manage result sources
- Manage query rules in SharePoint Server
- SharePoint Design Manager display templates
- Search Engine Optimization (SEO) in SharePoint Server
- Customize search result types in SharePoint Server
- Guide to the search schema in SharePoint 2013
- Display hybrid federated search results in SharePoint Server
- Office Graph, Delve, and SharePoint: Better Together
- Manage taxonomy
- How to build a successful SharePoint taxonomy
- Cross Site Collection Term Set Access in SharePoint 2013
- Assign a category page and a catalog item page to a term in SharePoint Server
- Part 2: Adding Custom Properties to a SharePoint Web Part
- How to add refiners to your search results page in SharePoint 2013
- Step by Step configuration to Add custom Refiners in the Refinement Panel of Search Results page for SharePoint Online
- Plan and configure a search workload
- Displaying Relevant Information with SharePoint Search Results Web Part
- How can I achieve the best freshness of search results? Introducing Continuous Crawls for SharePoint
- Understanding result sources for search in SharePoint Server
- Plan the end-user search experience (Office SharePoint Server)
- Guide to the search schema in SharePoint 2013
- Overview of analytics processing in SharePoint Server
Plan and configure cloud services
- Plan and configure a BI infrastructure
- PerformancePoint Services in SharePoint Server 2016 overview
- Overview of Reporting Services and SharePoint Technology Integration
- PowerPivot for SharePoint
- Excel Services Overview
- Power View in SharePoint Server: Create, save, and print reports
- Secure Store for Business Intelligence service applications
- Create and configure work management
- Plan and configure cloud and federated hybrid search
Monitor and optimize a SharePoint environment
- Monitor a SharePoint environment
- Monitoring and Reporting in SharePoint Server
- Capturing Performance Counters for SharePoint and Project Server into the Logging Database (Part 1)
- Monitoring and maintaining SharePoint Server 2013
- Configure usage and health data collection in SharePoint Server
- Configure SharePoint Hybrid Auditing in SharePoint 2016 (Preview)
- Tune and optimize a SharePoint environment
- Best practices for SQL Server in a SharePoint Server farm
- SharePoint Database Maintenance Recommendations
- Software boundaries and limits for SharePoint 2013
- Storage and SQL Server capacity planning and configuration (SharePoint Server)
- Caching in SharePoint
- 10 steps to optimize SharePoint performance
- Video demo of Zero Downtime Patching in SharePoint Server 2016
- Troubleshoot a SharePoint environment
- Performance testing for SharePoint Server 2013
- How to Debug SharePoint 2013 Using Client-Side Request Tracing
- How to Debug SharePoint 2013 Using Server-Side Request Tracing
- Enable Developer Dashboard In SharePoint Server 2016
- Configure and View SharePoint and Diagnostic Logging
- Using Event and Trace Logs in SharePoint
- SharePoint forum
Next Steps
If you have more questions, feel free to ask in the comments section.
For more information about this exam, refer to these links:
- Exam 70-339 Managing Microsoft SharePoint Server 2016
- Exam Prep: SharePoint Workload Optimization
- 70-339 Study Guide: Managing Microsoft SharePoint Server 2016
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
Article Last Updated: 2018-01-23
