Detailed Answers

A1: The correct answer is D. The DataView class represents a data-bindable, customized view of a data table that is optimized for sorting, filtering, searching, editing, and navigating. Answers A and B are not correct because these actions will impact SQL Server with additional hits, thereby decreasing performance. Answer C is not correct because it is complicated and requires additional programming, and you were asked to present a solution that requires little programming.
A2: The correct answer is C. Although answers C and D both use correct syntax of the Fill method, the question clearly states the name of the table; therefore, it is recommended to use the name of the table when filling the DataSet. Answer A is not correct because ...

Get Developing and Implementing Windows®-Based Applications with Visual C#™ .NET and Visual Studio® .NET Exam Cram™ 2 (Exam 70-316) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.