Microsoft 70-516-CSHARP Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | TS: Accessing Data with Microsoft .NET Framework 4 |
| Exam Number: | 70-516-CSHARP |
| Exam Format: | Multiple Choice, Code-based Questions, Case Study, Drag-and-Drop |
| Exam Duration: | 120-150 |
| Related Certifications: | MCPD: Windows Developer 4 MCPD: Web Developer 4 MCPD: Windows Azure Developer MCPD: Silverlight Developer 4 |
| Exam Price: | $150 USD |
| Passing Score: | 700/1000 |
| Real Exam Qty: | 45-65 |
| Available Languages: | German, English, Spanish, French, Japanese |
| Certificate Validity Period: | Retired (no longer active; MCTS certifications do not expire) |
| Recommended Training: | MCTS Self-Paced Training Kit (Exam 70-516) |
| Exam Registration: | Microsoft Learning Archive |
| Sample Questions: | Microsoft 70-516-CSHARP Sample Questions |
| Exam Way: | Proctored onsite at Prometric test centers; retired since January 31, 2021 |
| Pre Condition: | 2-3 years of .NET development experience; understanding of relational databases and SQL; familiarity with C# or VB.NET |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions//gg697604(v=msdn.10) |
Microsoft 70-516-CSHARP Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Developing and Deploying Reliable Applications | 18% | - Implement offline data synchronization - Deploy data access components - Ensure data integrity and security - Monitor and optimize data access performance |
| Modeling Data | 20% | - Work with XML schemas and data structures - Define entity relationships and associations - Create and customize Entity Data Models - Use LINQ to SQL data modeling |
| Managing Connections and Context | 18% | - Configure and manage database connections - Secure connection strings and data access - Implement connection pooling - Manage object context and life cycle |
| Manipulating Data | 22% | - Handle data conflicts and exceptions - Insert, update, and delete data - Work with DataSets and DataAdapters - Manage concurrency and transactions |
| Querying Data | 22% | - Use Entity SQL and query builder methods - Execute SQL statements and stored procedures - Implement WCF Data Services queries - Write LINQ queries (LINQ to Entities, LINQ to SQL, LINQ to XML) |
We're so confident of our products that we provide no hassle product exchange.


By Lesley

