Home | Exam Information
Home | Microsoft Exam information, study guides, training courses, help and advice.
Copyright © Accelerated Ideas 2005-2018

70-516 Exam Overview - MCPD 4

70-516 is one of the new Visual Studio 2010 exams covering the .NET Framework 4. Official title is: Accessing Data with Microsoft .NET Framework 4. Exam available from summer of 2010.

The 70-516 exam will test your knowledge and skills on accessing data sources using ADO.NET and the .NET Framework. You'll need to have strong skills in manipulating data using technologies such as LINQ, ADO .NET, XML and stored procedures.

The exam is a prerequisite for the following higher level certifications:

  • MCPD: Windows Developer 4
  • MCPD: Web Developer 4

As usual, questions that contain code will be presented in either VB or C#. You get the choice to select which language you prefer when you start the exam. Before you take the 70-516 exam, Microsoft recommends that you should have a minimum of two to three years of experience developing application components that interact with a variety of data sources. In addition to this, you should have a solid understanding of relational database concepts and have good experience using a relational database management system (RDMS).

The following core topics are covered by the exam:

  • ADO.NET 4 coding techniques and framework components
  • ADO.NET Data Services LINQ
  • LINQ to SQL
  • Entity Framework technologies
  • Structured Query Language (SQL)
  • stored procedures
  • Database Structures/Schemas (Objects) XML

Other topics covered include:

  • Entity Data Model
  • POCO model
  • PCOC templates
  • Conceptual Schema Definition Language (CSDL)
  • Multiple active result sets (MARS)
  • SqlCacheDependency
  • DBCommand, DataReader, DataAdapters, DataSets
  • DataContexts
  • Transactions, rollback and synchronisation
  • Logging and traces

When you pass the 70-516 exam (TS: Accessing Data with Microsoft .NET Framework 4) you achieve:

MCTS: .NET Framework 4, Data Access

You'll also get credit towards:

  • MCPD: Windows Developer 4
  • MCPD: Web Developer 4

ADO .NET Background:

ADO.NET is a set of computer software components that can be used by programmers to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also be used to access data in non-relational sources

LINQ Background:

Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.


XML (Extensible Markup Language) is a set of rules for encoding documents electronically. It is defined in the XML 1.0 Specification produced by the W3C and several other related specifications; all are fee-free open standards.

If you would like to take a free practice exam for the 70-516 exam, then check out our free practice exams section.

Popular Sections

Free Practice Tests

We have a large selection of free Microsoft practice tests to help you prepare for your exam
Microsoft Practice Tests


Azure and Amazon AWS Certification Salaries
Azure and Amazon AWS Certification Salaries

Few would argue that cloud certifications are on the rise. There's an increasing number of job opportunities for those with skills in cloud architecture and infrastructure for both Amazon AWS and Azure. A recent market report highlighted that..
Do you need to recertify your Microsoft exams? Recertification for MCSE and MCSA Explained
Do you need to recertify your Microsoft exams? Recertification for MCSE and MCSA Explained
Microsoft have updated their recertification process which requires IT professionals to renew their MCSE and MCSD certifications every 2-3 years to stay up to date. Recertification exams, just like any other exam, are published on a regular basis as
SQL Server 2014 Exam Numbers and Certifications
SQL Server 2014 Exam Numbers and Certifications
Microsoft have confirmed the new SQL Server 2014 certifications and associated exams. As the new version of SQL Server is focused on performance tuning and high availability, they've placed the new DB platform solely in the MCSE certification..

English English  |  Portuguese Portuguese