Exam 70-487 Preparation, Part I - Accessing Data

This is the first part in the Exam 70-487 preparation materials series. This post will cover all objectives regarding data access. If you want to see all of this in action, check out the Github repository.


  • Choose data access technologies
    • Choose a technology (ADO.NET, Entity Framework, WCF Data Services, Azure storage) based on application requirements
  • Implement caching
    • Cache static data, apply cache policy (including expirations); use CacheDependency to refresh cache data; query notifications
  • Implement transactions
    • Manage transactions by using the API from System.Transactions namespace; implement distributed transactions; specify transaction isolation level
  • Implement data storage in Azure
    • Access data storage in Azure; choose data storage mechanism in Azure (blobs, tables, queues, SQL Database); distribute data by using the Content delivery network (CDN); handle exceptions by using retries (SQL Database); manage Azure Caching
  • Create and implement a WCF Data Services service
    • Address resources; implement filtering; create a query expression; access payload formats (including JSON); use data service interceptors and service operators
  • Manipulate XML data structures
    • Read filter, create, modify XML data structures; Manipulate XML data by using XMLReader, XMLWriter, XMLDocument, XPath, LINQ to XML; transform XML by using XSLT transformations

Choose data access technologies


Entity Framework

Implement caching

Implement transactions

Implement data storage in Windows Azure

Create and implement a WCF Data Services service

Manipulate XML data structures

Written on June 4, 2016