MCSD.NET - 70-316 Exam Question:
Download Questions PDF

You plan to develop a customer information application CustomEX that uses a Microsoft SQL
Server database. CustomEX will be used frequently by a large number of users. Your application
code must obtain the fastest possible performance when accessing the database and retrieving
large amounts of data. You must accomplish this goal with the minimum amount of code.
How should you design CustomEX?
A. Use classes in the System.Data.OleDb namespace.
B. Use classes in the System.Data.SqlClient namespace.
C. Use remoting to connect to the SQL Server computer.
D. Use interoperability to include legacy COM-based data access components.

Answer:

B. Use classes in the System.Data.SqlClient namespace.

Download MCSD.NET - 70-316 Exam Interview Questions And Answers PDF

Previous QuestionNext Question
You use Visual Studio .NET to create an assembly, called XYZAssembly, that will be used by
other applications, including a standard COM client application.
You must deploy your assembly on the COM application to a client computer. You must ensure
that the COM application can instantiate components within the assembly as COM components.
What should you do?
A. Create a strong name of the assembly by using the Strong Name tool (Sn.exe).
B. Generate a registry file for the assembly by using the Assembly Registration tool
(Regasm.exe)
Register the file on the client computer.
C. Generate a type library for the assembly by using the Type Library Importer (Tlbimp.exe).
Register the file on the client computer.
D. Deploy the assembly to the global assembly cache on the client computer.
Add a reference to the assembly in the COM client application.		Suppose As a developer at XYZ you develop a new sales analysis application that reuses existing data
access components. One of these components returns a DataSet object that contains the data for
all customer orders for the previous year.
You want your application to display orders for individual product numbers. Users will specify the
appropriate product numbers at run time..
What should you do?
A. Use the DataSet.Reset method.
B. Set the RowFilter property of the DataSet object by using a filter expression.
C. Create a DataView object and set the RowFilter property by using a filter expression.
D. Create a DataView object and set the RowStateFilter property by using a filter expression.