Study Guide for Exam 70-489 – Developing Microsoft SharePoint Server 2013 Advanced Solutions

Finally I could publish the Study Guide for Exam 70-489 – Developing Microsoft SharePoint Server 2013 Advanced Solution. It’s also based on Martin Bodocky’s preparation links with some additions, like the previous post for Study Guide for Exam 70-488 – Developing Microsoft SharePoint Server 2013 Core Solutions.

Exam on Microsoft’s website: https://www.microsoft.com/en-us/learning/exam-70-489.aspx

Actually I’ve decided to publish this one because the high number of page views for the last one. At the same time Microsoft launches SharePoint 2016 and keeps improving SharePoint Online, people still are looking for the SharePoint 2013 exams.

Design and Implement Search

Query Search

• Build search queries using FQL (FAST Query Language) and KQL (Keyword Query Language):
  • http://msdn.microsoft.com/en-us/library/ff394606.aspx
  • http://msdn.microsoft.com/en-us/library/ee558911.aspx
• Execute search queries using client-side object model (CSOM):
  • http://sp2013searchtool.codeplex.com/
  • http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2013/04/18/how-to-query-search-with-the-sharepoint-2013-javascript-client-object-model.aspx
• Web Services (Deprecated in 2013):
  • http://msdn.microsoft.com/en-us/library/ee872313(v=office.14).aspx
• REST:
  • http://msdn.microsoft.com/en-us/library/jj163876.aspx

Customize search results

• Create custom result sources:
  • http://blogs.technet.com/b/mspfe/archive/2013/02/01/how-query-rules-and-result-sources-can-be-used-to-customize-search-results.aspx
  • http://technet.microsoft.com/en-us/library/jj683115.aspx
• Create display templates:
  • http://technet.microsoft.com/en-us/library/jj679900.aspx
  • http://technet.microsoft.com/en-us/library/jj944947.aspx
• Create result types:
  • http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=1041
• Create custom refiner definitions:
  • http://aghy.hu/AghyBlog_EN/Lists/Posts/Post.aspx?ID=181
• Implement query rules:
  • http://blogs.technet.com/b/tothesharepoint/archive/2012/09/18/what-happened-to-best-bets-introducing-query-rules.aspx
  • http://sharepoint-community.net/profiles/blogs/sharepoint-2013-manage-search-query-rule-using-powershell

Customize content processing

• Feed external content types:
  • http://msdn.microsoft.com/en-us/library/jj163139.aspx
  • http://msdn.microsoft.com/library/3c67b1cf-5fca-4805-a1b5-c9ac1ff8aede.aspx
• Implement content processing extensions (entity extraction):
  • http://technet.microsoft.com/en-us/library/jj219480.aspx
• Configure out-of-the box content processing:
  • http://msdn.microsoft.com/en-us/library/jj163968.aspx
  • http://blogs.msdn.com/b/sharepointdev/archive/2012/11/13/customize-the-sharepoint-2013-search-experience-with-a-content-enrichment-web-service.aspx
• Create content mappings:
  • http://blogs.technet.com/b/tothesharepoint/archive/2013/03/06/from-site-column-to-managed-property-what-s-up-with-that.aspx
  • http://www.hersheytech.com/Blog/SharePoint/tabid/197/entryid/37/Default.aspx
  • http://technet.microsoft.com/en-us/library/jj219667.aspx

Implement BCS (Business Connectivity Services)

General information: http://msdn.microsoft.com/en-us/library/jj163782.aspx

Create a model

• Optimize queries for performance and throttling:
  • http://thesharepointproject.com/2012/03/05/bcs-and-external-list-item-throttling/
  • http://technet.microsoft.com/en-us/library/ff607630.aspx
• Use naming conventions:
  • http://sharepointdragons.com/2012/12/10/naming-conventions-for-sharepoint-2013-service-accounts/
• Use batching (the same as 2010):
  • http://blogs.msdn.com/b/sharepointdev/archive/2011/11/14/client-object-model-request-batching-in-sharepoint-2010.aspx
• Create filters:
  • http://benredl.wordpress.com/2012/12/11/sharepoint-2013-external-list-enhancements-with-odata-sorting-and-filtering/
• Implement methods:
  • http://msdn.microsoft.com/en-us/library/gg294165.aspx
• Create associations:
  • http://blog.johnnyt.me/2013/03/crawling-with-fast-and-sharepoint-2013/
  • http://code.msdn.microsoft.com/SharePoint-2013-Create-2d2ec458

Create external content types

• Use SQL data sources:
  • http://msdn.microsoft.com/en-us/library/jj220063.aspx
  • http://wyldesharepoint.blogspot.co.uk/2012/12/sharepoint-2013-setting-up-external.html
• Use WCF (Windows Communication Foundation) (like 2010, deprecated?):
  • http://msdn.microsoft.com/en-us/library/ee556831(v=office.14).aspx
• Web Services (like 2010, deprecated?):
  • http://msdn.microsoft.com/en-us/library/ee556431(v=office.14).aspx
• Use oData:
  • http://msdn.microsoft.com/en-us/library/jj163967.aspx
• use.NET connector (Exactly the same):
  • http://msdn.microsoft.com/en-us/library/ee557349(v=office.14).aspx
  • http://code.msdn.microsoft.com/SharePoint-2013-MyFileConne-79d2ea26
  • http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/221221cb-5901-45c5-9fca-836778fcdec4/

Implement authorization and authentication

General links:

• http://technet.microsoft.com/en-us/library/jj683116.aspx
• http://technet.microsoft.com/en-us/library/ee661743.aspx
• Use pass-through;
• Use BCS Identity and User Identity;
• Use a custom model.

Create custom connectors

General information:

• http://code.msdn.microsoft.com/SharePoint-2013-MyFileConne-79d2ea26
• Implement methods (including Search);
• Implement security trimming;
• Implement configuration properties;
• Implement caching;
• Implement external event receiver:
  • http://msdn.microsoft.com/en-us/library/jj163976.aspx

Access BCS data

• Use BCS Web Parts,
• Use BCS data in workflows,
• Use BCS CSOM:
  • http://msdn.microsoft.com/en-us/library/jj164116.aspx
• Use the server-side object model,
• Use BCS REST:
  • http://msdn.microsoft.com/en-us/library/jj163227.aspx

Implement client-side BCS

• General information: http://msdn.microsoft.com/en-us/library/jj163972.aspx
• Use caching;
• Use Microsoft Office apps;
• Use Microsoft Visual Studio Tools for Office;
• Use SQL replication;
• Implement authorization and authentication.

Implement User Profiles and Customize Social Workload.

Manage user profile properties

• Create and update user profile properties:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163800
• Update privacy filters (deprecated ?):
  • http://msdn.microsoft.com/en-US/library/office/apps/ms583766
• Map properties to external data:
  • http://technet.microsoft.com/en-us/library/ff382639.aspx
  • http://technet.microsoft.com/en-us/library/hh147510.aspx
  • http://www.sharepointsecurity.com/sharepoint/sharepoint-security/sharepoint-2013-user-profile-property-mapping-and-synchronizing-groups/
• Use managed metadata term sets:
  • http://technet.microsoft.com/en-us/library/ee721054.aspx
  • http://najro.wordpress.com/2013/03/27/empty-term-set-in-custom-user-profile-property-sharepoint-2013/
• Update profile picture:
  • http://lixuan0125.wordpress.com/2013/04/08/upload-user-profile-pictures-programmatically-sharepoint-2013/

Manage feeds

• Use CSOM to follow documents or Sites:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163217
  • http://msdn.microsoft.com/en-US/library/office/apps/dn194080
• People:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163130
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163133
• Get feeds:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj164025
• Create posts:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163977
• Manage Like, reply, mention, tag, link, add pictures:
  • http://msdn.microsoft.com/en-us/library/jj863442.aspx
  • https://coderwall.com/p/urb8kg
  • http://blog.mastykarz.nl/like-publishing-pages-sharepoint-2013/
  • http://habaneroconsulting.com/insights/SharePoint-is-FINALLY-Social-mdash-Microblogging-and-Newsfeeds-in-SharePoint-2013

Access user profile data

• Use CSOM:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163182
  • http://msdn.microsoft.com/en-US/library/office/apps/jj920104
• Use the object model:
  • http://msdn.microsoft.com/en-US/library/office/apps/jj163142
• use REST (http:///_api/SP.UserProfiles.PeopleManager);
• Use Web Services (deprecated).

Implement ECM (Enterprise Content Management) and WCM (Web Content Management)

Implement a multi-lingual site

General links:

• http://www.mavention.com/blog/support-translation-sharepoint-2013
• http://office.microsoft.com/en-us/sharepoint-server-help/create-a-multi-language-website-HA102886546.aspx?CTT=5&origin=HA102771975
• http://office.microsoft.com/en-us/sharepoint-foundation-help/introduction-to-multilingual-features-HA102771975.aspx
• Lab material:
  • http://www.microsoft.com/resources/msdn/en-us/office/media/courseviewer/CourseViewerR5.htm?CourseXmlFile=http://www.microsoft.com/resources/Technet/en-us/office/media/WCMCourse.xml&Operation=LoadModule&Module=11
• Submit a page or batch of pages for translation:
  • http://msdn.microsoft.com/en-us/library/jj163145.aspx
• Publish pages;
• Create source and target labels;
• Create channels;
• Implement multi-language site navigation.

Implement E-discovery

General links:

• http://msdn.microsoft.com/en-US/library/office/apps/jj163267
• http://msdn.microsoft.com/en-us/library/jj193044.aspx
• http://blogs.askcts.com/2013/03/12/ediscovery-overview-in-sharepoint-2013/
• Create a new hold:
  • http://office.microsoft.com/en-us/sharepoint-server-help/create-a-hold-to-suspend-documents-or-items-HA101729113.aspx
• Integrate with Microsoft Exchange Web Services
  • http://technet.microsoft.com/en-us/sharepoint/jj650012.aspx
• Specify content sources and Search criteria
  • http://technet.microsoft.com/en-us/library/jj683115.aspx
• Export discovery sets;
• Manage permissions for hold.

Implement SEO (Search Engine Optimization)

General links:

• http://en.wikipedia.org/wiki/Search_engine_optimization
• http://blog.mastykarz.nl/search-engine-optimization-sharepoint-2013/
• http://www.iblogzone.com/2013/01/best-seo-practices-and-tips-for-2013.html
• Create a site map:
  • http://www.learningsharepoint.com/2012/09/21/sharepoint-2013-site-collection-seo/
• Customize a site map,
• Maintain SEO configuration properties,
• Maintain robots.txt file:
  • http://www.darrenmarsden.com/post/2012/03/22/Adding-a-robotstxt-to-SharePoint-2010.aspx
• Maintain SEO properties on term.

Implement content management

• Create information management policies (the same as 2010):
  • http://msdn.microsoft.com/en-us/library/ms499244.aspx
• Create content organizer rules (the same as 2010):
  • http://office.microsoft.com/en-us/sharepoint-server-help/create-content-organizer-rules-to-route-documents-HA102772939.aspx
  • http://code.msdn.microsoft.com/office/SharePoint-2010-Creating-a6fe3187
• Create document sets:
  • http://blogs.msdn.com/b/mittals/archive/2013/04/03/how-to-create-a-document-set-in-sharepoint-2013-using-javascript-client-side-object-model-jsom.aspx
  • http://technet.microsoft.com/en-us/library/ff603637.aspx
• Create document ID providers:
  • http://msdn.microsoft.com/en-us/library/microsoft.office.documentmanagement.documentidprovider.aspx
  • http://zimmergren.net/technical/sp-2010-sharepoint-server-2010-creating-a-custom-document-id-provider

Implement a publishing page

http://code.msdn.microsoft.com/office/SharePoint-2013-Create-9bfa6f5c
http://blogs.technet.com/b/tothesharepoint/archive/2013/04/10/stage-7-upload-page-layouts-and-create-new-pages-in-a-publishing-site.aspx
Add field controls to a page layout,
Add web parts to a page layout,
Create a publishing page layout:
http://msdn.microsoft.com/en-us/library/jj822368.aspx
Inherit content types.

Design for Performance and Troubleshooting

Design solutions to handle a high-traffic site

General information: http://technet.microsoft.com/en-us/library/gg441255.aspx

• Combine images:
  • http://blog.mastykarz.nl/easier-working-size-based-image-renditions-sharepoint-2013/
• Implement caching:
  • http://technet.microsoft.com/en-us/library/jj219613.aspx
• Minimize number of queries:
  • http://msdn.microsoft.com/en-us/library/ff798465.aspx
  • http://www.novolocus.com/2013/04/26/query-throttling-in-sharepoint-2013/
• Optimize JavaScript loading:
  • http://www.sharepointnutsandbolts.com/2011/01/eliminating-large-js-files-to-optimize.html
  • https://www.nothingbutsharepoint.com/sites/devwiki/articles/pages/eliminate-large-js-files-to-optimize-sharepoint-2010-internet-sites-the-complete-reference.aspx
• Use CDNs (Content Delivery Networks):
  • http://blogs.msdn.com/b/ramg/archive/2013/02/19/implementing-cdn-based-caching-for-sharepoint-internet-sites.aspx
• Create a scalable aggregator:
  • https://social.msdn.microsoft.com/Forums/sqlserver/en-US/80a478c8-4dcd-4801-a2f7-49ce633677a8/what-is-a-scalable-aggregator?forum=sharepointdevelopment

Design client applications for performance.

• Leverage health score rules:
  • http://www.wictorwilen.se/sharepoint-2013-sharepoint-health-score-and-throttling-deep-dive
• Optimize number of batch server requests:
  • http://technet.microsoft.com/en-us/library/jj219591(v=office.15).aspx
• Use client-side cache:
  • http://technet.microsoft.com/en-us/library/cc261797.aspx
• Minimize amount of data requested:
  • http://technet.microsoft.com/en-us/library/ff758647.aspx

Monitor and mitigate performance and scalability issues

General information: http://blog.hametbenoit.info/Lists/Posts/Post.aspx?ID=455

• Diagnose application stability issues;
• Debug the server side and app code on the client side;
• Create application diagnostics;
• Measure and test application performance.

Implement Managed Metadata Service (MMS)

General links:

• http://technet.microsoft.com/en-us/library/ee424403.aspx
• http://technet.microsoft.com/en-us/library/ee519603.aspx
• http://msdn.microsoft.com/en-us/library/jj163949.aspx

Manage term sets

General information: http://technet.microsoft.com/en-us/library/ee519604.aspx

• Import and export term sets:
  • http://code.msdn.microsoft.com/office/SharePoint-2013-Import-a-4d3d900b
• Create multi-lingual labels:
  • http://office.microsoft.com/en-ca/sharepoint-help/work-with-multilingual-term-sets-HA102771984.aspx
• Re-use terms;
• Manage term properties;
• Perform translation;
• Create groups and assign permissions.

Create solutions by using MMS

• Use Profile Pages,
• Use the Product Catalog,
• Use cross-site publishing:
  • http://blogs.technet.com/b/tothesharepoint/archive/2013/02/19/an-introduction-to-cross-site-publishing.aspx
  • http://technet.microsoft.com/en-us/sharepoint/jj872721.aspx
• Integrate with Search:
  • http://msdn.microsoft.com/en-us/library/jj163789.aspx
• Implement metadata-driven navigation:
  • http://msdn.microsoft.com/en-us/library/jj163978.aspx
  • http://blog.mastykarz.nl/building-global-navigation-sharepoint-2013/

Use an MMS API

• Use CSOM in client applications:
  • http://code.msdn.microsoft.com/SharePoint-2013-Synchronize-d40638d1
  • http://code.msdn.microsoft.com/SharePoint-2013-Assign-new-5c19062b
• Use REST in client applications,
• Use managed fields,
• Use server-side object model:
  • http://code.msdn.microsoft.com/SharePoint-2013-Synchronize-4c191e68
  • http://code.msdn.microsoft.com/SharePoint-2013-Assign-new-c79ce037

Well, that’s the second one. The first was the 70-488. Hope it can be useful to you when studying and preparing for the test.

References:
Martin Bodocky’s Linkedin