exam questions

Exam 70-487 All Questions

View all questions & answers for the 70-487 exam

Exam 70-487 topic 1 question 79 discussion

Actual exam question from Microsoft's 70-487
Question #: 79
Topic #: 1
[All 70-487 Questions]

DRAG DROP -
You are designing a service layer endpoint named EndPoint1 that will read more than one million rows from a database named DB1, and then update several rows in multiple tables in a database named DB2.
You need to identify a data access strategy that meets the following requirements:
✑ Uses the OData protocol to retrieve data from EndPoint1
✑ Creates a strongly typed object based on the table in BD2
✑ Retrieves data from DB1 as quickly as possible, while minimizing memory use on the application server
What should you identify for each requirement? To answer, drag the appropriate data access strategies to the correct requirements. Each data access strategy may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/wcf/wcf-data-services-overview https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/populating-a-dataset-from-a-dataadapter https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/retrieving-data-using-a-datareader

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
SvM
Highly Voted 5 years, 6 months ago
"Creates a strongly typed object based on the table in BD2" it is Entity Framework, not DataAdapter
upvoted 26 times
...
sti88
Most Recent 4 years, 7 months ago
The answer is correct, you'll create a strongly typed dataset with DataAdapter. https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/dataset-datatable-dataview/generating-strongly-typed-datasets
upvoted 1 times
modsjunk
4 years, 5 months ago
Questions say Creates a strongly typed object based on the table in DB2, not a strongly typed dataset so answer is Entity Framework
upvoted 2 times
...
...
MaverickCalibre
5 years, 6 months ago
Dataset created from DataAdapter are not strongly typed as it cannot infer or refer to columns in the table directly with .(dot) or property accessor syntax. It has to be access with ["<ColumnName>"] syntax.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...