Exam 70-483 topic 2 question 2 discussion

Actual exam question from Microsoft's 70-483

Question #: 2
Topic #: 2

You need to write a method that retrieves data from a Microsoft Access 2013 database.
The method must meet the following requirements:
✑ Be read-only.
✑ Be able to use the data before the entire data set is retrieved.
✑ Minimize the amount of system overhead and the amount of memory usage.
Which type of object should you use in the method?

A. SqlDataAdapter
B. DataContext
C. DbDataAdapter
D. OleDbDataReader

Show Suggested Answer

Suggested Answer: D 🗳️
OleDbDataReader Class -
Provides a way of reading a forward-only stream of data rows from a data source.
Example:
OleDbConnection cn = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
DataTable schemaTable;
OleDbDataReader myReader;
//Open a connection to the SQL Server Northwind database.
cn.ConnectionString = "Provider=SQLOLEDB;Data Source=server;User ID=login;
Password=password;Initial Catalog=Northwind";

by supersunny at July 22, 2019, 2:45 p.m.

Comments

Submit Cancel

supersunny

Highly Voted 5 years, 10 months ago

Correct Answer: D OleDbDataReader Class is the appropriate class to use.

upvoted 9 times

...