Try our training for free.

Gain instant access to our entire IT training library for 1 week. Train anytime on your desktop, tablet, or mobile devices.

This video training course with Tim Warner covers all objectives in Microsoft's Exam 70-332, Advanced Solutions of Microsoft SharePoint 2013. Due to the advanced nature of this course, we strongly recommend that you first complete our training for Exam 70-331, Core Solutions of Microsoft SharePoint 2013 to ensure that you understand the foundation concepts....
This video training course with Tim Warner covers all objectives in Microsoft's Exam 70-332, Advanced Solutions of Microsoft SharePoint 2013. Due to the advanced nature of this course, we strongly recommend that you first complete our training for Exam 70-331, Core Solutions of Microsoft SharePoint 2013 to ensure that you understand the foundation concepts.

Related Area of Expertise:
  • Messaging/Communications

Recommended skills:
  • According to Microsoft, candidates for this exam typically have more than four years of hands-on experience planning and maintaining SharePoint and other core technologies upon which SharePoint depends, including Windows Server 2008 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2008 R2 or later, Active Directory, and networking infrastructure services.

Recommended equipment:
  • Windows Server 2012
  • SQL Server 2012
  • SharePoint Server 2013 Enterprise Edition
  • Exchange Server 2013
  • Office Professional Plus 2013
  • Project Server 2013
  • Office Web Apps 2013

Related certifications:
  • MCSE: SharePoint
  • MCSM: SharePoint

Related job functions:
  • SharePoint farm administrator
  • SharePoint developer
  • Site collection administrator
  • Site owner
  • Business analyst
  • Systems engineer
  • Database administrator
  • Network manager

Topics include planning for business continuity, high availability, and disaster recovery; managing service applications; Implementing business data connectivity; deploying and managing SharePoint apps, and more.
1. Course Introduction (17 min)
2. Planning for SharePoint Business Continuity (25 min)
3. Planning for SQL Data Tier High Availability - Theory (23 min)
4. Planning for SQL Data Tier High Availability - Practice (22 min)
5. Planning for App Server High Availability (26 min)
6. Planning for Disaster Recovery - Theory (27 min)
7. Planning for Disaster Recovery - Backup (21 min)
8. Planning for Disaster Recovery - Restore (24 min)
9. Upgrading to SharePoint 2013 - Theory (23 min)
10. Upgrading to SharePoint 2013 - Practice (17 min)
11. Managing SharePoint Solutions - Theory (27 min)
12. Managing SharePoint Solutions - Practice (19 min)
13. Implementing an App Management Strategy - Theory (26 min)
14. Implementing an App Management Strategy - Practice (23 min)
15. Configuring BCS and the Secure Store - Theory (26 min)
16. Configuring BCS and the Secure Store - Practice (21 min)
17. Implementing BI Solutions - Theory (28 min)
18. Implementing BI Solutions - Practice (20 min)
19. Configuring Work Management - Theory (25 min)
20. Configuring Work Management - Practice (22 min)
21. Planning a Search Workload - Theory (22 min)
22. Planning a Search Workload - Practice (19 min)
23. Planning a Social Workload - Theory (28 min)
24. Planning a Social Workload - Practice (17 min)
25. Planning a WCM Workload - Theory (27 min)
26. Planning a WCM Workload - Practice (20 min)
27. Planning an ECM Workload - Theory (28 min)
28. Planning an ECM Workload - Practice (23 min)
29. Course Conclusion (18 min)

Course Introduction


Hi, welcome to our CBT Nuggets training course on Microsoft Exam 70-332-- Advanced Solutions of Microsoft SharePoint 2013. My name is Tim Warner, and I'm happy to be your trainer. The title of this Nugget is Course Introduction. My chief goal as your trainer is to prepare you to pass this certification exam and earn your MCSE in SharePoint.


Before we get to that point, I want to make sure that we're both on the same page with regard to how Microsoft SharePoint certification works. If you're taking this course, then chances are, you've already passed the other exams in the MCSE. But I just want to cover that base so I feel confident that you're properly armed with all the facts.


That having been said, if you haven't studied and passed the 70-331-- Core Solutions of SharePoint 2013, you probably want to go back and do that. I'm going to teach in this Nugget how you can know whether you're a good fit for this particular course. I'll give you a brief blueprint of how I organized this course and give you some practical tips and tricks for getting the most out of this training in the smallest amount of time.


And then we'll introduce the 70-332 test. I'm going to give you specific exam strategies at the end of the course, once we have all the theory and practice out of the way. Here I just want to give you need to know info on the front end. Let's begin. Now, in the past few years, Microsoft has changed their IT pro certifications quite a bit.


It used to be that the MCSE, or Microsoft Certified Systems Engineer, was the golden credential for the IT pro. And that-- that is to say MCSE-- was reserved for Windows Server systems engineer tasks. Now, in 2013, Microsoft has brought back the MCSE after for a while going in another direction with titles like MCTS and MCITP that we don't need to be worried about.


But MCSE is now a much broader title. Note that it stands for Microsoft Certified Solutions Expert. It's not a systems engineer. It's solutions. And you'll note that I'm going to put key terms on my whiteboard slides in bold, so you know that this is an important point.


Solutions means that we're experts not only with SharePoint, but with all of the SharePoint dependencies, things like Windows Server, IIS administration, Active Directory, and so forth. So these exams are, by definition, tougher, because they require that you have broad platform knowledge.


So the MCSE is the IT pro credential for folks who are perhaps working in the operations department of your organization, or if it's a smaller shop, maybe you're just the network guy or the network gal. Microsoft has additional tracks for solution developers, AKA programmers.


That's the MCSD or Microsoft Certified Solutions Developer. And the MCSM is the top level credential. That's Certified SharePoint Master-- MCSM. Say that five times quickly. Believe me, that's a very tough certification to earn. Let's quickly jet out onto the web, and I want to take you to a couple pages you need to be familiar with at the Microsoft Learning Web portal.


First, the Microsoft Learning home page at This site is pretty intelligently designed. What I normally do is come under Certification and Exams, and then we can come directly down under Server to SharePoint to see what the certifications look like here.


We're concerned with the Solutions Expert. So I'll click the MCSE SharePoint image. And it tells us exactly what we need to do in order to earn the title. There's five exams, each priced at $150 USD. We are right here in the last step, the so-called Advanced Solutions of SharePoint.


And there's the other half of this two-part series on SharePoint. That's called Core Solutions. That's exam 70-331. And what came as a surprise to many of us is, in keeping with the solutions motif, you have to earn the MCSA in Windows Server 2012 in order to earn your SharePoint MCSE.


At first blush, you might think, well, what does Windows Server 2012 have to do with being a SharePoint administrator? Of course, you know at this point in the game, a lot. So it does make sense to me that Microsoft has that requirement. The other thing I want to draw your attention to on this page is the Upgrade option here, that if you have any of these titles, you can shorten your learning path by taking a composite exam for Windows Server 2012 and then do your 331 and 332 as normal. That will save you quite a bit of money.


The other page I wanted to show you is the exam blueprint page for 332. You'll see that Microsoft tells you the exam fee right up front. I'm grateful that they've done that. It tells us the credit toward certification, which we already know. You can schedule your exam through


And then down below, the real meat and potatoes here are the skills that are measured. You see that the knowledge is broken into five categories-- one on business continuity. That's dealing with things like-- well, actually, let me expand it and show you-- high availability and disaster recovery for all the tiers on a SharePoint farm, how to do backup and restore, not only in SharePoint but also in SQL Server.


Again, we're solutions experts here. So we have to be pretty proficient with SQL Server, Windows, IIS, as well as SharePoint and the Office applications. After that, we go into planning a SharePoint environment, where we look at different workloads. How do we optimize and plan and execute SharePoint for search? How about for web content management? How about for enterprise content management, and so on? We'll be looking at server roles and service applications a lot.


There's a separate section of the exam that deals with migration scenarios. So by the end of this training, you'll understand all the ramifications of what it takes to move from, say, SharePoint 2010 to SharePoint 2013. The next section deals specifically with service applications.


You know by now that the service application is the element of functionality in a SharePoint farm. So you have to know all the basics. All the basics is stuff that we learned in the 331 skill set. Here we assume all that and then go to the next level. We learn how the SharePoint apps store and apps model works.


We learn how to build out our own apps presence within the farm. We have to make sure we are expert with all the built-in productivity services, like Access services, Excel, and Visio services, the conversion services, and language translation. We have to understand how to do inter-farm service application federation.


And we have to have expertise with using Secure Store and Business Connectivity Services. The final section gets back into the idea of apps, where we manage solutions and applications, we differentiate SharePoint apps from Sandbox solutions to farm solutions, we go back into business intelligence and sweep up the shavings by making sure we're fully familiar with PerformancePoint Services and integration between SharePoint and SQL Server Reporting services.


And then finally, we have integration with other servers-- Exchange server, Microsoft Project Server. You might be thinking, Tim, this is a huge amount of information. And you know what? You're absolutely right. It is. To that point, I want you to know that the topics in this exam-- in case you all didn't already know-- are truly advanced.


And they do require that you already know the basics. So we simply don't have time in this course to go back and review how to install SharePoint, how to create a service application instance, how to get to your services in the farm and start and stop. All of that stuff needs to be assumed, and we're going to take the next level.


Therefore, if you're not comfortable with all of the foundations, your best bet, if you're a CBT Nugget site subscriber, is to take one or the other or both of my other SharePoint 2013 courses for CBT Nuggets, specifically the 331, to give you what you need to know from a basic core level regarding SharePoint farm administration.


And I also did a course that deals strictly with SharePoint end user skills. And it maps to the Microsoft Office specialist exam 77-419. Even if you're an admin, please don't poo poo this course. It contains a lot of good, high impact information. And I can almost guarantee you that by the end of that course, you'll think to yourself, wow, I'm actually much more proficient using SharePoint as an end user than I was before.


That, of course, is my goal as your instructor. Answering the question, how did I organized this course, for your benefit, is pretty easy. I always use the exam blueprint from Microsoft as the skeleton of the course. My challenge as an instructor-- and this doesn't have any bearing on you at all, it's my burden to bear-- is, sometimes Microsoft's way of ordering concepts on those exam pages isn't particularly intuitive.


I think in this case, the 332 skill set is quite intelligently laid out. And I think you'll see that it's obvious when you look at the Nuggets in this course, that I used the exam blueprint. After all, being a certification candidate myself, I know how important it is to feel secure that all of the bullet points on an exam blueprint are being covered in your training, because if you've taken Microsoft tests before-- and I have to assume you have-- you know that those questions will, in fact, go to the outer limits and beyond of what's on the exam blueprint.


I'm going to give you something to look at in every Nugget. And by something to look at, I mean some kind of demo. I've watched hours and hours and hours of computer-based training, not only from CBT Nuggets, but just about all the other major providers in the world.


So I'm definitely as much a student as I am a teacher. I know that it can get tedious and boring to watch white board after white board after white board. So I'm going to make sure that we have that healthy balance. Now, sometimes in this course, you'll find that the material is so intense that I have to split the Nuggets in two, where I'll give you one that is theory, that has very limited demo, and the next one will be a practical lesson that's almost entirely demo.


But I want to make sure to repeat that you pick up both the head knowledge as well as the practical application. You absolutely need that. Be on the look out in the CBT Nuggets website over the coming months for virtual labs that will give you the ability to practice in a SharePoint sandbox and do all the labs along with me as you go through your training.


I love to sprinkle external resources through the training. So you'll see a lot of pop-up balloons that point you to web resources. We have our own custom short domain called And you'll find that the short links are that, and then forward slash, and then there'll be a short string of alphanumeric characters.


Please note that those alphanumeric characters are case sensitive. I wish that you could click the link directly in the movie player. You'll have to jot them down on your phone or on a piece of paper. But it should save you, because some URLs are ridiculously long.


Believe me. You'll thank me for giving you this short URLs. Finally, we build our skills incrementally as we move through the course. To that end, I formally recommend you watch the Nuggets in series so you don't come across references where I say, well, we learned such and so three Nuggets back.


And now let's go on from that. Well, if you've watching the Nuggets sequentially, you already have those concepts under your proverbial belt. Let's finish this introductory Nugget with some general comments regarding that 70-332 exam. Like I told you earlier, we're going to do a separate Nugget where I give you specific targeted strategies.


You'll notice that I have in bold "case study." The most important thing for you to keep in mind at this point in the game with regard to 70-332 is that its format may be different from other certification tests that you've taken in the past. A case study format means that you have a number-- I can't tell you how many because I don't want to violate my non-disclosure agreement.


I'll just use three for the sake of example here. Three representative fictional cases. Each one of those cases involves a fair amount of reading but not as much as we've seen in the past. Years ago, when Microsoft first started rolling out the case study exams, around 2000, 2003, there was a lot of text to go through.


And that can have issues if you're not taking the exam in your native language. So definitely make sure you're doing that. But it also brings up the question, how much of this is about validating my skills with the technology, and how much of this is like an LSAT exam or a GRE test, where you're testing my ability to read and process information? I don't know.


I'll leave that question for you to consider. Email me if you want to talk about it. But the non-negotiable is, you're going to have to deal with these cases. The good news is that they're all set up the same general way. You'll have some fictional description of what the company does.


And then the main parts of the cases that are important is that you'll see a section for their business requirements. This is what we've got going on now, but these are the requirements that we need going forward and that we're hoping SharePoint will help us with.


So in a sense, you as the exam candidate are role playing a little bit. You could almost imagine yourself being hired on as a consultant, and you're sitting down with all the key decision makers of this company. They're telling you what they have and what the requirements are.


And then you need to map those requirements to capabilities in SharePoint Server. So there's the business requirements, which may or may not map directly to SharePoint. And then you have the technical requirements that give you limitations in their IT infrastructure.


Remember it's all about doing as close a match as possible to make sure that the SharePoint solution you propose satisfies their requirements-- the business requirements as well as the technical requirements. And each of those cases will have about a dozen or so questions that grill you about various aspects of the case.


There are a lot of interactive items on the 332 test. Other Microsoft tests do not have any interactive items. By interactive items, I mean things like drag and drop, where you have a series of tasks and you need to arrange them in their proper order. Sometimes you just have to pick which ones are relevant and they don't have to be in an order.


And there's also place the target items, where you'll see a user interface element, maybe a screen capture from Central Administration, and it asks you where would you click in that interface to get to where you need to be. So like I said, in some past exams, not only where there are no interactive questions, but the item writers focused on PowerShell big time.


For some weird reason, I don't see that trend with the SharePoint exams. I find it really weird. It may be-- well, I don't even want to speculate. But know the user interface cold. Know Central Administration, know the SharePoint team site and some of the other main templates-- the Records Center template, the Business Intelligence center.


We'll get to that as we go on. I told you to go to Prometric to register for these things. On that Prometric landing page, there's a link for special offers. Please keep that page bookmarked so you can take advantage of offers like the second shot promotion.


Microsoft has had a lattice success with this over the last years. What it does is allows you to essentially get two vouchers for the price of one such that if you don't pass the test on your first try, you can immediately reapply, use your second voucher code, and you've only still paid their initial $150 instead of $300. That's pretty cool, isn't it? Let's wrap up what we've learned in this course introduction.


Now, if you've been with me for other courses, you'll notice that I'm trying some new instructional techniques in this series. I look forward to hearing your feedback. I'm going to pop my email address right up at the front end of the course, and I'll give it to you again at the end of the course.


I love to keep in touch with my students. Let me know what works. Let me know what doesn't. I'm here. After all, my main goal is to help you achieve your goal with SharePoint Server. In this Nugget, we reviewed SharePoint certification so you know about the different general tracks, IT pro, dev, and master, and that our focus is that Solutions Expert credential.


You now know whether you should wait before entering this course or go ahead with it. Remember, this is not beginner information. And we make assumptions at the outset of your current skill level with Windows, SQL Server, IIS, SharePoint, Exchange, and so forth.


We do have other courses available, not just my courses in SharePoint. But we have courses in the CBT Nuggets library on SQL Server 2012, web development, all that good stuff. You know how this course is organized. You know that the course is arranged to map to the exam blueprint and that we're going to integrate both the theory and the practice so that you have a nice healthy balance of both.


We finished with approaching the 70-332 test. You're aware of the format of the test. And you at least have that in your mind, I hope, as you go through the training. Continue to think of yourself, whether you are a SharePoint consultant or not, act as if you are.


And think about how you would respond to different questions that a client might ask you about how SharePoint can help them achieve their business and technical goals. Well, that's it for the introduction. We're ready to get into the content proper now. So fasten your proverbial seat belts, because it's going to be an intense ride.

Planning for SharePoint Business Continuity

Planning for SQL Data Tier High Availability - Theory

Planning for SQL Data Tier High Availability - Practice

Planning for App Server High Availability

Planning for Disaster Recovery - Theory

Planning for Disaster Recovery - Backup

Planning for Disaster Recovery - Restore

Upgrading to SharePoint 2013 - Theory

Upgrading to SharePoint 2013 - Practice

Managing SharePoint Solutions - Theory

Managing SharePoint Solutions - Practice

Implementing an App Management Strategy - Theory

Implementing an App Management Strategy - Practice

Configuring BCS and the Secure Store - Theory

Configuring BCS and the Secure Store - Practice

Implementing BI Solutions - Theory

Implementing BI Solutions - Practice

Configuring Work Management - Theory

Configuring Work Management - Practice

Planning a Search Workload - Theory

Planning a Search Workload - Practice

Planning a Social Workload - Theory

Planning a Social Workload - Practice

Planning a WCM Workload - Theory

Planning a WCM Workload - Practice

Planning an ECM Workload - Theory

Planning an ECM Workload - Practice

Course Conclusion

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Intermediate 11 hrs 29 videos


Basic Plan Features

Speed Control
Included in this course
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Included in this course
Follow what the trainers are saying with ease.

Files/materials that supplement the video training

Premium Plan Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Included in this course
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Included in this course
Our mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Included in this course
Develop and maintain a study plan with assistance from coaches.