Exam 70-483 topic 2 question 117 discussion

Actual exam question from Microsoft's 70-483

Question #: 117
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. DbDataAdapter
B. unTyped DataSet
C. OleDbDataAdapter
D. DbDataReader

Show Suggested Answer

Suggested Answer: D 🗳️
The DbDataReader class reads a forward-only stream of rows from a data source.

Reference: DbDataReader Class -
https://msdn.microsoft.com/en-us/library/system.data.common.dbdatareader(v=vs.110).aspx

by VladWork at April 16, 2020, 9:17 a.m.

Comments

Submit Cancel

VladWork

Highly Voted 5 years, 3 months ago

Should be OleDbDataReader

upvoted 7 times

HgstExam

4 years, 10 months ago

I had to read the question again to understand, that it is correct, OleDbDataReader does not exist, OleDbDataAdapter does.

upvoted 1 times

...

mmarinov

Highly Voted 5 years, 2 months ago

OleDbDataAdapter is the answer.

upvoted 5 times

HgstExam

4 years, 10 months ago

Don't you mean OleDbDataReader

upvoted 3 times

...

Mona30

Most Recent 4 years, 10 months ago

Using the DataReader can increase application performance both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory, reducing system overhead. https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/dataadapters-and-datareaders

upvoted 4 times

...

Mona30

4 years, 10 months ago

Same question #42 on page 28 says answer is DbDataReader (and OleDbDataReader is not among offered answers)

upvoted 3 times

...

HgstExam

4 years, 10 months ago

To sum it up OleDbDataAdapter is not correct because it is not readonly and forward only. DbDataReader is the only correct choice, but if there was an option OleDbDataReader then that would be a better choice.

upvoted 4 times

...