Which code should you use?

You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort.

Which code should you use?

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: A

Explanation:

* Scenario:

/ During your investigation, you discover that the sales force reports are causing significant contention.

/ Sales force data access

Sales people at both the headquarters office and the satellite office must generate reports that read from the Product and SalesOrderDetail tables. No updates or inserts are ever made by sales people. These reports are run at random times and there can be no reporting downtime to refresh the data set except during the monthly maintenance window. The reports that run from the satellite office are process intensive queries with large data sets. Regardless of which office runs a sales force report, the SalesOrderDetail table should only return valid, committed order data; any orders not yet committed should be ignored.